Jasperserver changed my date

[reportah]

hi

I built a report with iReport then moved it to the repository.

data from an informix database via jdbc

date shows in iReport as 20/05/08 which is the same as in the informix table

date shows in Jasper Server as 19/05/08

In fact all dates in this report are minus one day

I have tried changing Time Zones in my JNDI Data Source and on the login screen but this makes no difference

Thanks

 

[reportah]

'gotcha' forgot to save the Data Source - all good now, no more time travel

 

[henryho]

Hi,

 

I have the same problem that date column is minus one day and i also change the time zone in JasperSever but make no difference.

 

How can u solve this problem ?

 

Many Thanks

[reportah]

select your Data Source - right click and edit - select the BLANK in time zone and remember to SAVE -> check your report again.

 

[henryho]

correct.. many thanks!

[sebastien]

Hi,

 

I've the same problem.

I try to apply your recomendations but it dosen't solved the problem.

I'm on the 2.1.0.1 JasperServer version.

Did someone have à other idea

 

Thanks for youre help!

[lucianc]

sebastien
Wrote:

I'm on the 2.1.0.1 JasperServer version.

Try to restart the server as well.  And you could also try the latest JS version to see whether the issue is still present.

Regards,

Lucian