Exclude table component columnFooter and tableFooter on export

Hi all,
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?
msiljegovic@gmail.com's picture
Joined: Dec 15 2015 - 12:53pm
Last seen: 4 months 3 weeks ago


ghudson_1 - 7 years 1 month ago


would never guess without your help.


msiljegovic@gmail.com - 7 years 1 month ago

1 Answer:

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
ghudson_1's picture
Joined: Oct 30 2012 - 12:51pm
Last seen: 1 year 12 months ago