Ireport 5.0 Multiple Sheet Export to Excel

[wolverto]

 

I am attempting to split my report into multiple Excel sheets when I export from Jasperserver.

Report Structure - Main page with four subreports. A group header and footer for each subreport, the header contains the subreport element while in the footer I have placed page break elements with the property..

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

Placing the Pbreaks in the header/footer doesn't seem to make a difference and each subreport has ignore pagination checked (true).

The main report has this property,

net.sf.jasperreports.export.xls.one.page.per.sheet

I have read through similar questions on here and have not been able to produce any results with many different combinations. Not sure if my problem is specific to Ireport 5.0.