rstuart
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by rstuart
-
-
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
Change the Format of "Date Refreshed"
in Products
Posted
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=MMu2215ddu2215yyyycalendar.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