How to get paginated Excel export. Page footer is being ignored when exported as excel(xls) paginated from jasper server.

[gauravkumar350]

Jasper studio version 6.3.1

Jasper server version 6.3.0

I have one simple report with bands

• Title
• Page Header (height 0px)
• Column Header
• Detail
• Column Footer (height 0px)
• Page footer (which consist pagination)
• summary (height 0px)

It is working fine with other formats like

• PDF
• XLSX (PAGINATED)(Here it is being well paginated).
• XLSX

But issue appear when exported as Excel paginated. In this case it completly ignores the footer band and it just appear same like Excel without pagination.

Please help.

[szaharia]

By default page footers are excluded from the Excel export. To change this behavior, you need to set this property in your JRXML file:

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

This will override the net.sf.jasperreports.export.xls.exclude.origin.band.2=pageFooter setting in the jasperreprts.properties file.

[gauravkumar350]

Thanks shertage it worked :)

But what if i have to repeat header too.

[szaharia]

In case of repeating page header, set this property in the report:

<property name="net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.1" value=""/>[/code]

To repeat column header, you should set this property:

<property name="net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.3" value=""/>[/code]