Jump to content
Changes to the Jaspersoft community edition download ×

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


gauravkumar350

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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.

Link to comment
Share on other sites

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]

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...