Scheduler Timezones in Excel Output

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.

This property can also be defined on individual elements in the report's JRXML if only certain fields should apply the timezone.

Version: 
Feedback