|report date parameters string format [message #834657]
||Mon, 02 April 2012 04:17
| Anthony Farrell
Registered: April 2011
In our application BIRT reports have to work for different locales, I would like some guidance on how BIRT should be used:|
We have some server side Java code which builds a URL to execute a report, (the reports are managed by a separate J2EE applicaition, like the samplebirtviewer) the URL will contain the report name and parameters. I am guessing that we should adopt the following approach :
1. Ensure any java code places the date parameter on the URL in a fixed format, e.g. "yyyy-MM-dd" format. Currently, as we have had many developers who coded the URL for a report, we have a situation where the date string being placed in the URL in a slightly different format for each report URL invocation. We need to standardize.
2. The report parameter e.g. "startdate" will have its data type set to "date", should we also set the "format as" to custom and "yyyy-MM-dd". I am guessing that this "format as" setting is only applied to the parameter string being passed to the report, i.e. it is not used for display purposes for this parameter anywhere else in the report.
If we adopt these two standards in the Java code and associated BIRT rptdesign file respectively, we we have reports that will execute in any locale, the primary concerns at present are "en", "de_DE" and "en_US".
My understanding is that if we fix the date format for the URL and match this in the report, the reports should work for all locale when the application is deployed. The assumption is that we should NOT place the date parameter on the URL is a locale specific format.