Removing headers for excel

[allenmvt.edu]

Is there a way to dynamically print headers for PDF but not for Excel? I'm assuming i would use a "pint when" expression, but i dont know what to evaluate to determine if it PDF or Excel.  Thanks

[mrcaffeine]

The Print When expression is global and gets applied to the JasperPrint object which is the source for all exporters. Nevertheless there is way to configure hiding bands for output formats by setting report properties.

For example to hide the pageHeader only in excel you could set a global report property

net.sf.jasperreports.export.xls.exclude.origin.band.1=pageHeader

Please refer the JasperReports Configuration Refernce for further details: http://jasperreports.sourceforge.net/config.reference.html on net.sf.jasperreports.export.{format}.exclude.origin.{suffix}.{arbitrary_name}.

 

Post Edited by mrcaffeine at 25/02/2010 08:58 AM

[allenmvt.edu]

Thanks ... i'll give it a shot.