| report date parameters string format [message #834657] |
Mon, 02 April 2012 08:17  |
 Anthony Farrell
Messages: 25
Registered: April 2011
Location: Ireland |
Junior Member |
|
|
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.
|
|
|
| Re: report date parameters string format [message #835720 is a reply to message #834657] |
Tue, 03 April 2012 15:39  |
|
I believe this is correct. One simple test to try is in the preview
options set the locale for testing. See attached screenshot. Also set
Always use external browser and when you preview the report you will see
the url. You can add the date parameter to the url and refresh the
report. This should prevent the parameter box from being displayed.
Jason
On 4/2/2012 4:17 AM, Anthony Farrell wrote:
> 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.
>
|
|
|
| Re: report date parameters string format [message #835723 is a reply to message #834657] |
Tue, 03 April 2012 15:39 |
|
I believe this is correct. One simple test to try is in the preview
options set the locale for testing. See attached screenshot. Also set
Always use external browser and when you preview the report you will see
the url. You can add the date parameter to the url and refresh the
report. This should prevent the parameter box from being displayed.
Jason
On 4/2/2012 4:17 AM, Anthony Farrell wrote:
> 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.
>
|
|
|
|
|
| Re: report date parameters string format [message #899373 is a reply to message #899223] |
Tue, 31 July 2012 15:17 |
|
Thanks for posting the update.
Jason
On 7/31/2012 3:12 AM, Anthony Farrell wrote:
> Just to round off this thread, we have over 50 reports in our app and
> they are in globalisation/localisation testing, when invoking our
> reports are build a URL and we are setting the date format on the URL to
> be in the format of "yyyy-MM-dd".
|
|
|
Powered by
FUDForum. Page generated in 0.03925 seconds
] 
Search
Help
Register
Login
Home
