Jump to content


Recommended Posts

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


Link to comment
Share on other sites

  • 1 month later...
  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

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