Scheduler Timezones in Excel Output

This documentation is an older version of JasperReports Server Administration Guide. View the latest documentation.

Overview of JasperReports Server Administration
Organization, User, and Role Management
Repository Administration
Data Sources
Other Resources in the Repository
Themes
Import and Export
Application Security
System Configuration
Server Diagnostics
Troubleshooting
Localization
Glossary
About This Guide

When scheduling a report, you can specify the timezone that should be applied to the output instead of using the data source's timezone. This works for all outputs except Excel (XLS), both paginated and non-paginated. To overcome this limitation, you must explicitly enable timezone usage in XLS output.

Setting Timezones in Scheduled Excel (XLS) Reports
Configuration File
.../WEB-INF/classes/jasperreports.properties
Property	Value	Description
net.sf.jasperreports.export. xls.use.timezone	true	Define this property as true to apply timezones in scheduled Excel (XLS) reports.