Skip to Content
0
Former Member
Jun 11, 2009 at 12:13 PM

Different date formatting when scheduling from InfoView and SDK

63 Views

Hi

I wrote a Java standalone application to schedule Business Objects reports using the SDK (BusinessObjects Enterprise Java SDK and Business Objects Report Engine Java API).

We are running BO XI R2 SP4 on a Windows Server 2003 server.

The thing is: I created a Webi report displaying a date field (type date in both the database and the universe) without explicit formatting (rendered using the default date format). When I schedule this report from InfoView, it uses the (correct) french date format DD/MM/YY (i.e. "11/06/09") in the report but when I schedule it from the Java SDK, it uses the (M)M/(D)D/YY (i.e. "6/11/09") date format and I can't find where to change it.

com.businessobjects.rebean.wi.ReportEngine.getLocale() and com.businessobjects.sdk.plugin.desktop.webi.IWebiBase.getContentLocale() both return "fr_FR" which is our locale here in France but dates are still in english format in the generated instance of the report.

com.businessobjects.rebean.wi.ReportEngine.getDefaultFormatNumber(FormatNumberType.DATE_TIME).getSample() shows "21/09/2004 20:45:30"

Is there somewhere in the SDK (or somewhere else) I can specify the date format to use in the report I am sheduling?

Regards

Guillaume