suppress headers and footers from a csv export in Jasper

Products

• CA Service Management - Service Desk Manager
• CA Service Catalog
• CA Service Desk Manager

Issue/Introduction

When exporting a CSV from a table in a Report in JasperReports Server, headers and footers are included

Environment

JasperReports Server 8.x, 9.x

Resolution

1. Edit the jasperreports.properties file located in jasperserver-root>/WEB-IN/classes 

2. Add the following to this file:

net.sf.jasperreports.export.csv.exclude.origin.band.1=pageHeader
net.sf.jasperreports.export.csv.exclude.origin.band.2=pageFooter
net.sf.jasperreports.export.csv.exclude.origin.band.3=columnHeader
net.sf.jasperreports.export.csv.exclude.origin.report.3=*
net.sf.jasperreports.export.csv.exclude.origin.band.4=columnFooter

3. Save changes

4. Restart JasperReports Windows Service

5. Remove cache from browser