Hi All,

I am facing an issue with TimeZone.

Scenario:

Environment: Apache Tomcat: TimeZone set to IST
I have developed a report using Pentaho report Designer and I am using KTR to provide the result set to the report. When i see the output of the KTR and report they work fine independently. But when I publish this report on to the server the result set retrieved from the DB by KTR is not correct.

Environment: Apache Tomcat: TimeZone set to GMT

When I set the time Zone to GMT. Report runs fine with the correct data.

I am missing something here. Please tell me how to deal with this kind of issue.