Diff. Result between IReport and JasperServer

[tmoeller]

Hi,

I desingned a report in IReport which shows the expected results in Preview-Mode. It contains one input parameter for the Dateof the report, which is currently defined as Java.Util.Date.

Deploying this report to the JasperServer 3.7.0 end always in a wrong result. The report is show correctly but the content is always dated one day before the chosen date.

I tried any combination of changing the parameter definition, the underlying sqlstatement or the resource (input control definition).

The only things i could achive was a wrong report or no report.

As this gets really annoying it hope there is somebody with more knowledge, perhaps of java, who can help me out of this. 

So, any ideas are welcome.

 

Cheers

Thorsten

[msn]

Why not simply print todays date, instead of having an input parameter?
A Java.util.Date field filled with new Date() will give you todays date.

The other problem might be a timezone difference between your iReport installation and your JasperServer installation. I think it is using the machine settings.

Post Edited by msn at 01/07/2010 12:48

[sjongenelen]

i've had the same issue: its the fault of JDBC. My solution was to set the 'Time Zone' value in the datasource to blank

[tmoeller]

Thanks,

 

it was the same problem here too.

 

 

[saurabhmca2003]

Hi All,

I faced the same issue. My date is coming one less from database. I have set it then as mentioned below:

You can set the database timezone in jasper server from where you are setting the datasource for your iReport. So, go to jasper server, add/edit datasource, set TimeZone to the one you want. If you want the date to coming from database, set 'Use Database Settings' from dropdown. Please do let me know if you face any issue in this.

Thanks,
Saurabh