Suppress some bands when exporting to excel at report level.

[ssunilkumar]

Hi,

I have a report when exported to excel should supress the page header and footer. I have searched a lot and found that there are some properties which needs to be changed at server level. But it the changes are done on server level it apllies to all the reports but in my case I do not want to do it at server level as I need the the headers to export for some reports and do not need to export for some reports.

 

Please can you suggest as early as possible.

Thank You

Sunil Kumar Sappa

suniltvg@gmail.com

 

[elizam]

You don't name the specific properties, so I'm not sure, but most properties that can be set at the server level can also be set as advanced properties in the report.

[ssunilkumar]

The properties I was talking about are:

<property name="net.sf.jasperreports.export.xls.exclude.origin.band.1" value="pageHeader"/>

<property name="net.sf.jasperreports.export.xls.exclude.origin.band.2" value="pageFooter"/>

 

These changes had to be done in Web-INF/ Folder. So just wondering without doing it in such level if can be done in report level.

I tried applying those properties to my report but it did not work as expected.