Export report to excel using multiple worksheets

[rongrajo13]

I have a created 4 reports. 1 report will serve as the main report and the 3 reports are subreports. This is a scheduled report that will run daily and should export 2 outputs 1 excel file and 1 pdf file.

is it possible that when the report is exported it will create the following?

 

1. an excel file that contains a worksheet or tab for each subreport

2. the same report in PDF which each tab just initiating a page break in the pdf document

 

thanks in advance

[lucianc]

Place a break element before each subreport, and set the net.sf.jasperreports.export.xls.one.page.per.sheet property to true at report level.

HTH,

Lucian