Exporting a report with multiple sheets from JasperServer to Excel

excel jasper-reports export jasperserver
user1133591 picture user1133591 · Jan 6, 2012 · Viewed 8.1k times · Source

I created a report using iReport and set the 'One Page per Sheet' option to true in the Excel Export parameters, this generates a report in iReport with multiple sheets.

I then loaded the report onto JasperServer, the report's output appears on multiple pages, exporting the report to Excel results in the data appearing on one sheet instead of multiple sheets.

Is there a way or an option that can be set so that the data appears on multiple sheets when exported from JasperServer?

Thank you.

Answer

Alex K picture Alex K · Jan 6, 2012

You can use the net.sf.jasperreports.export.xls.one.page.per.sheet property.

The information about this property is here.

  • The property can be added to the jasperreports.properties file (in *jasperserver\WEB-INF\classes* folder):
net.sf.jasperreports.export.xls.one.page.per.sheet=true
  • The property can be added to the report template (jrxml file)

The sample:

<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" ...>
    <property name="ireport.zoom" value="1.0"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="0"/>
    <property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="true"/>

Related questions

How do you export a JasperReport to an Excel file with multiple worksheets?

We have a report that the customer would like to have exported to an excel format where it has multiple worksheets. Essentially the two queries share the same parameters, but everything else is different. In jasper-reports how do you export …

Read More
Jasper Reports Excel Output Problems

I am new to Jasper Reports and iReports that I am using to design the reports. I am currently designing a report in iReport and want to export it in excel (xls). Here is the screen shot of what I …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More