Date shift Issue (time zone)

Hi,

I have 2 reports with some bar, pie charts, those work fine when I work in my laptop.. But when I deploy the same into the production server, the dates are shifted 2 days before..

i.e., If I give filter as June, instead of getting the data dated from 2012-6-1 to 2012-6-30, I get the data dated from 2012-5-29 to 2012-6-28...

So, the dates are shifted to 2 days before, but I am able to get the proper data for the month.. I guess it is some timezone issue, but how do I resolve this in ireport..?

I found options in ireport Tools > Options >    Compilation and execution -- Report Locale, Report Time Zone... what values should I provide here??

Or Is there any other way to resolve this date shift issue???

subashmy's picture
154
Joined: Jan 3 2012 - 2:01am
Last seen: 8 years 7 months ago

2 Answers:

Hi All,

I have found answer to my own issue... The problem is java 7 doesnt support sqlserver2005, instead we need to use java 1.6 & it works fine...

subashmy's picture
154
Joined: Jan 3 2012 - 2:01am
Last seen: 8 years 7 months ago

Are you picking the right timezone when you log in via the browser? 

 

Also, this page might help: http://community.jaspersoft.com/wiki/timezones-jasperreports-server

ernestoo's picture
18058
Joined: Nov 29 2010 - 11:59am
Last seen: 5 years 5 months ago

Thnx ernestoo for your helping hands, but that was not the issue.. Its compatibility issue.. of java 1.7 with SqlServer

subashmy - 10 years 3 months ago
Feedback