rstuart

The file you need is bundles/jasperserver_config.properties. The datetime for "Data Refreshed" came across as "53/17/18". I made several attempts to "escape" the slash, but settled for using unicode character. The lower case mm intended for the day was displaying the minutes. Using uppercase MM worked for me. I made the following changes: date.format=MMu2215ddu2215yyyy datetime.format=MMu2215ddu2215yyyy HH:mm:ss calendar.date.format=MMu2215ddu2215yyyy calendar.datetime.format=MMu2215ddu2215yyyy HH:mm:ss Best Regards, rstuart It appears that changing format for calendar.date.format and calendar.datetime.format will cause formatting errors for some report components. My impact was intended only for the datetime refresh display for reporting refreshed datetime. To correct this, I have changed these back to original setting; calendar.date.format=mm/dd/yy calendar.datetime.format=mm/dd/yy HH:mm:ss

I am attempting to create a filter on my adhoc view to filter when date1 value is between date2 value and date2+1 value. In a regular Jasper report, fields can be accessed using $F{date2}. It does not appear to work this way in adhoc view. Other relative dates can be entered in a date filter, ie. DAY + 1, DAY - 30, ... Is it possible to reference field values, other than the one on which the filter is created, in adhoc view? Best Regards, rstuart