Remove repeating headers in the crosstab report when exported to XLS/CSV only.

Issue Description:

Customer with report which contains crosstab often whats to hide headers for each page excluding first page of report when exported to xls/csv.

Resolution:

This can be achieved by setting isIgnorePagination="true" for the report template while exporting to xls or csv only.  This will consider the export has one single page eliminating the repetition of headers on every page and printing the header on only first required page. 

There is a report export property  "com.jaspersoft.jrs.export.csv.paginated"  and  "com.jaspersoft.jrs.export.xls.paginated"  that you can use to fulfill your need in addition to the ignorePagination option for JasperReports Server .

You can set this property by using any one of below two ways:

1) Use this property in your report template JRXML file to ignore pagination in CSV/XLS output for a report only.

<property name="com.jaspersoft.jrs.export.csv.paginated" value="false"/>

<property name="com.jaspersoft.jrs.export.xls.paginated" value="false"/>

2) Set it in jasperreports.properties file.

-  Navigate to jasperserver-proWEB-INFclassesjasperreports.properties file.

- Add below two peoperty in the file to affect only csv/xls export output of report

   com.jaspersoft.jrs.export.csv.paginated=false

   com.jaspersoft.jrs.export.xls.paginated=false

- Restart the Application server after making chnages in configuration file.