Exie Posted April 28, 2009 Share Posted April 28, 2009 Hi,I've got a report I built in iReport with an SQL query that works great. But when I publish the report to JasperServer and run the report, the dates get shifted 1 day back.I know the datasource is correct, and the report works fine on my PC, but not on the server. I've checked the clock and time-zone config on the server operating system and it's all correct.Any idea what could be causing this ?Tim. Link to comment Share on other sites More sharing options...
tuxce Posted April 28, 2009 Share Posted April 28, 2009 Same problem here. Link to comment Share on other sites More sharing options...
Exie Posted April 29, 2009 Author Share Posted April 29, 2009 So its not just me! Its actually a big problem for us... in my example, a customer order was due 29/04/09, the Oracle data was correct, running the report in iReport was correct, but running from JasperServer returned 28/04/09 ... one day early! I mean, thats nice to deliver early, but its put our warehouses under alot of pressure. I just cant figure why its doing it. Link to comment Share on other sites More sharing options...
lucianc Posted May 4, 2009 Share Posted May 4, 2009 If the data source that you defined in JasperServer for the report specifies a timezone, unset it.Regards,Lucian Link to comment Share on other sites More sharing options...
Exie Posted May 8, 2009 Author Share Posted May 8, 2009 Many thanks Lucianc, This solved the problem. Not sure why, but it worked! Link to comment Share on other sites More sharing options...
swood Posted May 10, 2009 Share Posted May 10, 2009 Check out the FAQ ShermanJaspersoft Link to comment Share on other sites More sharing options...
saurabhmca2003 Posted November 7, 2012 Share Posted November 7, 2012 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now