Exclude table component columnFooter and tableFooter on export

0
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?
 
Thanks
msiljegovic's picture
Joined: Dec 15 2015 - 12:53pm
Last seen: 11 months 2 days ago

nm

ghudson_1 - 3 years 3 months ago

Thanks,

would never guess without your help.

 

msiljegovic - 3 years 3 months ago

1 Answer:

1
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
20393
Joined: Oct 30 2012 - 12:51pm
Last seen: 4 weeks 23 hours ago
Feedback
randomness