Combining 5 separate reports in One Spreadsheet

[andrew_50]

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?

[andrew_50]

It turns out I what I want to do can be done (should be done?) with a "Report Book."

Desperate times, desperate measures etc.