One Excel Sheet for each Subreport

[welsa.chy]

Hi Guys,

This is really driving me mad.. I read everywhere but still can't understand why mine isn't working

I have a main report( a dummy query returning me only one row) and 2 subreports(each with its own header) found in two different detail band. The second subreport splits into multiple excel sheets!

The main report doesn't contain any groups.. its just a dummy query and has no links with the subreports.

This is what i did in the main report:

1. Add in Properties : Name="net.sf.jasperreports.export.xls.one.page.per.sheet "  with Value="True"

2. Set Igonre Pagination="True"

3. Added a Line element and set the Properties Expression: Name="net.sf.jasperreports.export.xls.break.after.row"  and Default Value="True"

Then for the second subreport:

1. Set Ignore Pagination="True"

I just want one excel sheet for each subreports. But the second subreport is being split to multiple sheets... :(

Does anybody know what's the problem...?

 

[wolverto]

Did you ever get this to work?

[welsa.chy]

nops.. :(