jasper server ignoring timezone setting?

[phodges]

I want times to come out on my reports in EST, even though I am in CST. When I choose the EST timezone on the login prompt, the times are still displayed in CST... does jasperserver ignore this login setting?

I have checked the database output... it is outputing java.sql.timestamps which represent the right time offset wrt UTC.

This is the last bug before rollout... Help!

 

--Paul

[kkelleher]

Which dates do you mean? Modification dates in the repository, or perhaps dates returned by reports? If the latter, what kind of data source are you using, and how is it configured?

Thanks,

Kristen

[moremr]

 

We are experiencing the same problem. The locale and time zone selected at login time are applied to reports only when the report is run in the foreground. If the report is scheduled or run in the background the default JVM time zone is applied. This can easily be seen by formatting a date/time input control passed to the report to print the date, time and time zone, and running the report in the foreground and again in the background under a login session which is using a time zone that differs from the JVM time zone.

Scheduling a report or running a report in the background allows you to specify the language specific locale for the execution of that report, but not the time zone. It seems the only workaround for this is to use an additional input control for each report to select the desired time zone from a configured list of values, and convert this string value to a java.util.TimeZone object in the report, ignoring the built-in REPORT_TIMEZONE parameter.

Tested with JS 3.7.0

[lucianc]

moremr
Wrote:

If the report is scheduled or run in the background the default JVM time zone is applied.

That's right.  Log a bug for this so that we'll address it.

Regards,

Lucian

[171334125]

Any update on this? was it resolved or still there in 6.1?