Jump to content

Unable to split Excel output into multiple sheets


errol

Recommended Posts

Hi guys,

after trying to create multiple Excel sheets in iReport 3.7.4, i have not found out how to get it working. The export property "net.sf.jasperreports.export.xls.one.page.per.sheet" has been set to true in the jrxml file as shown below.

<property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="true"/>

I have ticked the "Ignore pagination" checkbox under the report properties. As i want each group header to be on a new sheet so i have added the page break element inside the group footer band. I have also ticked the "Start on a new page" checkbox for the group header. For the subreport inside the report, i have also ticked the same property "Start on a new page".

The result that comes out is that the spacing between each group header is wider instead of on separate sheets. Any ideas on what is needed or to be corrected to make the multiple sheets appear?

Thanks for your replies.

Link to comment
Share on other sites

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Hi guys,

if the "One page per sheet" option in the iReport Excel export options is checked, then multiple sheets will appear. However the sheets are not separated by the group header. They are instead separated based on the length of the page. This is still not correct as it should split by the group header.

Is there any way to force iReport to page break according to the group header & not depend on the iReport settings? As the report will be generated from outside of iReport so it will not work if it's only set for iReport.

Thanks for your replies.

Link to comment
Share on other sites

  • 2 years later...
An ugly work around is to set the length of the page to a very high height. Go to Format -> Page Format... in Height enter 500 inches (36,000 pixels, 1270 cm, or 12,700 mm). If you still have problems double this value and double again if required.
Link to comment
Share on other sites

  • 4 months later...

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...