I've been trying to do this, and have had no joy.
Specifically, what I want to do is have these 5 reports each appear as one worksheet in a single spreadsheet.
The first three reports each have a variable length, and are not paginated. These are to make up the first 3 worksheets.
The other two reports are summary reports and each fill one page.
I've tried using the master/subreport approach but I am not able to separate the reports, they all start on the same page.
Maybe I should expect that as I placed them all in the master summary band (as I believe is correct practice).
Getting correct location / pagination is my main problem.
Does anyone have an exemplar on this sort of thing?