JRS not setting timezone on date input controls.

[spierepf]

Greetings,

I've built a simple report with a date input control and a single text field showing the value of that input control. When I log into JRS and set a timezone, the date displayed by the report is still in my local timezone.

Does anyone know the reason why?

Peter

[aspanier]

Hi, Peter. A similar problem occurred for another customer. Below is the solution that fixed their problem - maybe it applies to your issue as well. Let me know if it doesn't work:

"I think time zone awareness comes from the JS Pro query executor. If you would map it to another one it should work. 

just replace in WEB-INF/classes/jasperreports.properties 

net.sf.jasperreports.query.executer.factory.sql=com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory 

with 

net.sf.jasperreports.query.executer.factory.sql=net.sf.jasperreports.engine.query.JRJdbcQueryExecuter" 

 

Thanks!

 

aimee