jaspersoft report server: Exporting Data to multiple tabs/sheets in a single excel file

[linsam.gct]

Hi All,

I have tried many suggestions in the forum but could not find a working solution for exporting data to multiple tabs/sheets in a single excel file. I created the .jrxml using iReports Designer Pro 5.0.0 and when i preview in iReport Report viewer, i can see multiple tabs (each tab is supplied by a different DataSet/Query and the rows are > 10000) as expected. But when i deploy in jaspersoft report server and try to export in excel it gives all the data from two queries/dataset into a single excel tab only. Could anyone send a working example to solve this problem.

I have already tried the Page Break, Line Break, Sub report, Groups, Different properties like "ignore pagination", "net.sf.jasperreports.export.xls.one.page.per.sheet", "net.sf.jasperreports.export.xls.break.after.row" and "net.sf.jasperreports.export.xls.break.before.row".

Thanks,

Muni

 

[Srikanth Kattam]

Hi,

Try this property:

net.sf.jasperreports.export.xls.one.page.per.sheet = "true".

Hope this resolves your concern.

 

Regards,

Srikanth Kattam

[mike2tango]

Hi, use this post: http://community.jaspersoft.com/questions/533232/how-create-multi-worksheet-excel-jasper-repor