Hello,
I recently moved from JetReports7 to 2010 and I have a problem with the Options filters: now, they appear with =" " (eg a date filter was 01.01.2010 an now is ="01.01.2010"). And now I have a problem with the reports because it doesn't recognize the field as a date filed (if I want to find the end of month, if I want to compare some dates etc. I get #VALUE!). Any idea about how to lose the =" "?
Thank you,
P.S. - this only happens when I want to run reports created with JetReports7… I don't have this problem with those created with JetReports2010.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi!
This behavior was intentionally added in Jet Reports 2009 in order to avoid the exact scenario you were using in v7. We have found in the past that many users have values in their databases such as APR10 which may not be an actual date, but which Excel converts to a date. Similarly, leading zeros are removed from numbers by Excel. Both of these cases can cause problems for filtering later, so quoting was added in order to avoid this case. It looks like one person's trash is another person's treasure, as the saying goes. :-)
Fortunately, it should be easy to work around the problem you are having with Excel/Jet formulas. If you have the value "01.02.2010" in cell C4, you could use the following functions to get the day, month, and year:
Day: =NL(1,NP("Split",C4,"."))
Month: =NL(2,NP("Split",C4,"."))
Year: =NL(3,NP("Split",C4,"."))
From there, you can either use those directly or use the Excel Date formula to turn the value into an actual Excel date. Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Thanks for your reply… I solved the issue by re-building the reports with JetReports2010 and everything works great now.
Please sign in to leave a comment.