Jump to content

Recommended Posts

Posted

Hello,

I created main report with subreport in detail section.

In main report i have query that returns 15 rows and subreport is called 15 times with different parameter.

All that is working just fine, now i need to place each subreport to be on separate excel sheet when exporting report to excel.

Any idea how to achieve this?

I tried with net.sf.jasperreports.export.xls.break.before.row in static element but where to place that element?

If i place it in detail section of main subreport, after subreport element i got more than 15 sheets, some of them are empty.

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Posted


Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

 

Posted

Hi

Have you tried following what @rpachipu suggested? You should see each subreport going to new sheet if you can add the static field with 

net.sf.jasperreports.export.xls.break.after.row

Example: https://community.jaspersoft.com/wiki/how-split-xls-document-according-some-condition
 

You can also use page break element too. 

One of these elements should be placed in the subreport page footer to export the report out in separate sheets.

 

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