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???
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...
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
Thnx ernestoo for your helping hands, but that was not the issue.. Its compatibility issue.. of java 1.7 with SqlServer