Separate Excel tab for each subreport?

[estatham]

I have a master report with multiple sub reports, each of which I want to put on a separate Excel tab. Currently each subreport appears as the sole item within a detail section, and each of these detail sections is followed by a further detail section which contains only a page break. I have tried using the net.sf.jasperreports.export.xls.break.after.row property on the subreport, but that doesn't work. I have tried inserting a "dummy" text field after each subreport, to force a row, and putting the property on there. But that messes up the pagination. I tried using a PrintWhenExpression on the dummy row to suppress printing, but if the row doesn't print, the excel break is not evaluated.

I know there must be a simple way to do this, but I can't see it. I'm using JasperReports/iReport 3.7.0

Please advise.

thanks

 

[macivic]

This post explain similar problem:

http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=68388[/code]

I hope it help you.[/code]