date appears one day prior to what is programmed

[fcramy]

 My biggest single gripe about JasperServer is that it flat out behaves differently than JasperReport (specifically, jasperreports developed in iReport).

 

The problem I'm seeing now is that dates are displayed as one day prior (in fact, exactly 4 hours prior) to the date put into the parameter.

this is what I put into the default value expression of the JRXML:

 

 

 ((new Date().getMonth() / 3) + 1 == 1)? new Date(new Date().getYear(), 0, 1) :

((new Date().getMonth() / 3) + 1 == 2)? new Date(new Date().getYear(), 3, 1) :

((new Date().getMonth() / 3) + 1 == 3)? new Date(new Date().getYear(), 6, 1) :

new Date(new Date().getYear(), 9, 1) 

 

 

This code works to correctly calculate the beginning of the quarter from within the default value expression of JasperReports. When i run this through iReport, i see no problem whatsoever. For any reports I've run in this quarter, i'm seeing July 1, 2010 as the start date.

When I modify the JRXML to account for the "repo:subreport_name" format of jasperserver and run this report and have jasperserver email the output to me I get a different result:

 

 

6/30/10 8:00 PM

 

This seems like a bug to me.

[fcramy]

 so i've found this:

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=47753

 

which points to this:

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=45272

 

which effectively says this:

Resolved the problem by blanking the time zone setting for the data sources used in JasperServer. Apparently if this is left blank on the data source config, it will use the local time zone (since I am 7-8 hours from GMT, the time difference calc's were resulting in dates being one-day off).

 

how do I go about "blanking the time zone setting for the data sources used in JasperServer."? 

[fcramy]

 another twist in the puzzle (see attachment)

[lucianc]

fc_rba
Wrote:

how do I go about "blanking the time zone setting for the data sources used in JasperServer."?

Locate the JNDI or JDBC data source object in the JasperServer repository (you can edit the report unit and see the data source path in the Data Source section).  You'll see a Time Zone select; make sure nothing is selected there (in 3.7 the default option is labeled Use database setting).

Regards,

Lucian

[fcramy]

 PERFECT!

Thank you, Lucian.

[fcramy]

 Lucian,

this all makes me wonder why it doesn't use EST when EST is selected both on the login screen and under the datasource configuration

[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