Excel export - show header

[gundinge]

I am using JasperServer 3.7.0 und iReport 3.7.0

when I receive the report in excel format from a scheduled task (defined in JasperServer), the header is not displayed in it. Why?
If I saved the Report from preview - view from iReport as excel - the header will be displayed.

My property settings in jrxml is following:
<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>
<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/>
<property name="net.sf.jasperreports.export.ignore.page.margins" value="true"/>
<property name="net.sf.jasperreports.export.xls.ignore.graphics" value="true"/>

are they any other property setting to set?

many thank for you help
best regards

Stefan

[gundinge]

nobody can help me?

[gundinge]

I need help. are the separated setting on jasperserver for exporting excel sheets?

[tcejones]

Hi,

I am having the same problem.  We recently migrated from an old version of Jasper (v2) where everything worked fine.  Since moving to 3.7.1, I don't get any page headers, column headers or page footers.  All other formats seem fine, but in Excel I only get the Page and detail bands.  I've tried ignoring pagination etc. but nothings seems to sort it out.  All our reports are Excel so this is also a real issue for us.

Can anyone help?

Thanks,

Trevor.

Post Edited by tcejones at 03/22/2010 16:21

[tcejones]

Stefan,

I've finally found why we're having this issue, if you're still interested.

If you look in jasperreports.properties in the relevant server directory - for Tomcat it's in /webapps/jasperserver/WEB-INF/classes - you'll see the following lines:

#suppress page and column headers and footers when exporting to XLS
net.sf.jasperreports.export.xls.exclude.origin.band.1=pageHeader
net.sf.jasperreports.export.xls.exclude.origin.band.2=pageFooter
net.sf.jasperreports.export.xls.exclude.origin.band.3=columnHeader
net.sf.jasperreports.export.xls.exclude.origin.band.4=columnFooter

Comment these lines out and and re-run your reports and you should see the headers and footer.

Why these were set to true by default I don't know!!!!

Regards,

Trevor