how to suppress the page columns header in jaspersoft reports exported in csv file

Products

• CA Spectrum

Issue/Introduction

Exporting Adhoc jaspersoft Reports to csv file, if the report is more than 1 page, the columns page header is populated for each page.

Is there a way to suppress it?

Environment

Release : Spectrum 10.4.3 Jaspersoft 7.1.1.1

Component :

Resolution

Open the configuration file, \jasperserver-pro\WEB-INF\classes\jasperreports.properties, in your favorite editor 

Add to the very end of the configuration file the lines below:

#suppress page and column footers and all but the first page and column headers when exporting to CSV
net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.1=pageHeader
net.sf.jasperreports.export.csv.exclude.origin.band.2=pageFooter
net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.3=columnHeader
net.sf.jasperreports.export.csv.exclude.origin.keep.first.report.3=*
net.sf.jasperreports.export.csv.exclude.origin.band.4=columnFooter