How to exclude Jaspersoft report headers in CSV export (Clarity PPM)

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

We are using a Jaspersoft report with pageHeader which uses a Table Component. We would like to exclude the Page Headers from being exported to CSV. We have tried all the csv <property name="net.sf.jasperreports.export.csv.exclude properties in the report and it does not work. 

Environment

Release : Any

Resolution

The reason the typical <property name="net.sf.jasperreports.export.csv.exclude headers do not work is that the report is that the report is using Table component.

1. Add a key property to each pageHeader field and then exclude it as follows: 
   
2. Then add this to the top of the report in properties:
       <property name="net.sf.jasperreports.export.csv.exclude.key.reportName"/>
3. Repeat for all the Page Headers - and recreate the report

 

Additional Information

Also refer to Stack Overflow