Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » report date parameters string format(report date parameters string format)
report date parameters string format [message #834657] Mon, 02 April 2012 08:17 Go to next message
Anthony Farrell is currently offline Anthony FarrellFriend
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 #836376 is a reply to message #834657] Wed, 04 April 2012 12:11 Go to previous messageGo to next message
Anthony Farrell is currently offline Anthony FarrellFriend
Messages: 25
Registered: April 2011
Location: Ireland
Junior Member
thanks for your reply, just wanted to check this was correct before I make the java changes.

When I confirm this all work, I will update this post.

many thanks again Jason.
Re: report date parameters string format [message #899223 is a reply to message #836376] Tue, 31 July 2012 07:12 Go to previous messageGo to next message
Anthony Farrell is currently offline Anthony FarrellFriend
Messages: 25
Registered: April 2011
Location: Ireland
Junior Member
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".
Re: report date parameters string format [message #899373 is a reply to message #899223] Tue, 31 July 2012 15:17 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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".
Previous Topic:Report is erroring out with an error in onFetch method.
Next Topic:Duplicate class definition in Birt runtime 4.2
Goto Forum:
  


Current Time: Thu Dec 18 23:22:56 GMT 2014

Powered by FUDForum. Page generated in 0.03316 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software