Removing Repetitive Column Headers From CSV Export in Jasper

Removing The Repetitive Column Headers From CSV Export in Jasper

Prerequisites::
Jasper Server 5.5, IReport

Database:: Foodmart

Scenario: I need to remove the repetitive column headers of a report after exporting the report in CSV format in Jasper server

Created a Sample Report which includes a Table component,

for this report below are screenshots for actual output and expected output

Actual:

Expected:

To achieve the above-expected result we need to set 3 properties for the report

<property name=”net.sf.jasperreports.export.csv.exclude.origin.report.myreport” value=”<ReportName>”/>

<property name=”net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.myreport” value=”columnHeader”/>

<property name=”net.sf.jasperreports.export.csv.exclude.origin.keep.first.report.myreport” value=”*”/>

Now deploy the changes in Jasper server and verify the CSV export the headers will repeat only once

Output:

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download

Thanks,

SatyaGopi,

BI Developer.