Exclude table component columnFooter and tableFooter on export

[msiljegovicgmail.com]

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

[ghudson_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]

nm

[msiljegovicgmail.com]

Thanks,

would never guess without your help.