Subreports in different excel sheets

[nmilasinovic]

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.

[anish.rai]

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.

 

[rpachipu]

Hi , Please can you place inside the subreport's page footer (.ie., end of the subreport make sure no pixel space left after the element)

[Jitendra Mandalia]

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.