I have report template and requirement to exclude part of table when exporting report to excel.
Report have summary band with table component inside. I set up properties as below. It works for columnHeader, but cannot make it work work for columnFooter and tableFooter.
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.keep.first.band.1" value="columnHeader"/>
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.keep.first.report.1" value="*"/>
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.4" value="columnFooter"/>
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.report.4" value="*"/>
Anyobody know the trick?
Posted on April 28, 2016 at 12:40pm
Table column footer cells actually end up rendering as a page footer band in a subreport generated for the table. Therefore if you want to exclude the column footer cells you'll need to define a property for pageFooter.
<property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.1" value="pageFooter"/>
A defect or feature request for improvement in the product for this issue has already been filed against JR Library 6.2.x