Start New Page for Excel only

[christopher.astles]

I want to create a report which will break at natural places when exported to PDF, but I want to use the 'Start New Page' property on the group when exporting to Excel, so that I can combine this with the net.sf.jasperreports.export.xls.one.page.per.sheet property to have all of my groups on different sheets within my excel. Is there a way to do this?

[szaharia]

The following steps should work in this case:

• in your report set the following properties:

<property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="false"/><property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>

• for the first element in the group header band set this property:

<property name="net.sf.jasperreports.export.xls.break.before.row" value="true"/>

 

[christopher.astles]

@shertage sorry for the slow response - the email notification went to my spam and in the end we did the report a different way. I tried your suggestion but it still creates a new pdf page every time the group changes, and because of

<property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="false"/>[/code]

now the groups don't come out on different tabs