Timezone in report incorrect

Hi, 
In some of my reports I use.... 
As at: <VALUE-OF format="dd/MM/yy hh:mm:ss">BirtDateTime.now()</VALUE-OF> 
I recently discovered it was giving me an incorrect time.I live in the Austrlalia/Sydney timezone and I have tried setting BIRT_VIEWER_TIMEZONE in my web.xml as both Austrlalia/Sydney and also GMT+11 but both don't seem to change the default timezone. 
Can someone help me with what I need to do to change birt reports to use the Australia/Sydney timezone? 
I am using BIRT 3.7.2. 
thanks

Find more posts tagged with

Comments

micajblock

Is this in the designer? If yes, there is a setting in preferences for this. See image below (newer version but should be the same). If this is in your application, how are you deploying?

richie.riviere

thanks for that info. It is good and will fix my problem when previewing the report in eclipse.
 
I still have an issue though because when I deploy my application the timezone will be wrong.
 
The architecture of my web application is to integrate birt reports my web application by including all the birt engine jars inside my webcontent folder.
 
All my BIRT report configuration is sitting inside my web.xml file. These are the two settings I would have thought I should set to get the BIRT timezone correct however changing these settings does not seem to be changing the result returned from BirtDateTime.now(). It is still returning the wrong timezone.
 
  
 <context-param> 
 <param-name>BIRT_VIEWER_LOCALE</param-name> 
 <param-value>en_AU</param-value> 
 </context-param> 
  
 <context-param> 
 <param-name>BIRT_VIEWER_TIMEZONE</param-name> 
 <param-value>GMT+10</param-value> 
 </context-param> 
 
Can you think of anything extra I might have to do or why this might not be working?
 
thanks

richie.riviere

A question for you Mica, with respect to the answer you previously gave me, will that change anything in each individual report? Or is that suggested solution you gave me specific to previewing the reports in eclipse? Ie. Will it have any effects on reports I am deploying in my application? 
Thanks

micajblock

How are you deploying BIRT?

richie.riviere

I'm including all of the birt engine libraries inside my web application war file.

micajblock

Not my area of expertise, but the engine task has a setTimeZone method.

richie.riviere

Mica, thank you for spending the time to have a look at this problem for me. 

Today I found out what my problem was. It was caused by me being very silly.
 
As mentioned in my first post the expression I was using was....
 
As at: <VALUE-OF format="dd/MM/yy hh:mm:ss">BirtDateTime.now()</VALUE-OF>
 
It should have been...
 
As at: <VALUE-OF format="dd/MM/yy HH:mm:ss">BirtDateTime.now()</VALUE-OF>
 
This was totally confusing me. But it was the cause of my problem. I did not have to set anything inside BIRT_VIEWER_TIMEZONE which is consistent with what I've read. i.e. if you do not set anything for this value then birt should inherit the timezone of your JVM.