Clarity PPM - Remove repeating table headers in the report that should be exported to CSV in Jaspersoft

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Table Headers are repeating while exporting Adhoc Reports to CSV

Step to Reproduce:

1. Create an adhoc report using domains 
2. Run the report immediately or schedule  and export to csv 

Expected Result : If the report is more than 1 page the header should populate at the start of csv file 

Actual Results : The headers are repeated as soon in the CSV file 

Environment

Release : 15.x, 16.x with Jaspersoft 7.1.3 

Component : CA PPM SAAS JASPERSOFT

Cause

Configuration issue with Jaspersoft tracked through DE59751.

Resolution

Workaround: 

• With release of Jaspersoft 7.8 this feature is included. 

On Premise customers who have not yet upgraded to Jaspersoft 7.8 can add the below in the jasperreports.properties file and restart Jaspersoft service.  

• • Open the configuration file, \jasperserver-pro\WEB-INF\classes\jasperreports.properties, in an editor
  • Add to the very end of the configuration file the lines that are quoted 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