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:

Thanks,

SatyaGopi,

BI Developer.

Free Open Source BI Platform

• AI-Powered Analytics
• Embedded Analytics
• Single Sign-On (SSO)
• Multi-Tenancy
• Paginated Canned Reporting
• Interactive Dashboard
• White Labeling

Download Free