Remove Repeated Column header, Page Header, Page Footer in CSV Export (JASPER)
Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.
In CSV export, we want only column header once and data should be printed. We do not want page header, page footer and repeated columns header. So in order to achieve this do the following.
-
- Remove Page Header:
<property name="net.sf.jasperreports.export.csv.exclude.origin.band.(uniqueValue)" value="pageHeader"/>
-
- Remove Page Footer:
<property name="net.sf.jasperreports.export.csv.exclude.origin.band.(uniqueValue)" value="pageFooter"/>
-
- Remove Title Band:
<property name="net.sf.jasperreports.export.csv.exclude.origin.band.(uniqueValue)"value="title"/>
-
- Remove Repeated Column Header:
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.keep.first.band.(sameValue)" value="columnHeader"/>
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.keep.first.report.(sameValue)" value="*"/>
Some times we are using sub report to display page header and page footer. Do the following to remove the it in CSV Export.
-
- Remove Sub Report:
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.report.(sameValue)" value="Actual Report Name not the sub report name"/>
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.(sameValue)" value="detail"/>
This is not working for crosstab.
Thanks & Regards,
Fahad Anjum
Best Open Source Business Intelligence Software Helical Insight is Here
What does unique value means in above parameter