Print several reports as one

[Warman]

I have several reports (8) that I would like to print as one. It's just
easier to have one big report to present to someone (email) than to print 8
reports and combine them somehow.

I have tried the macro route - it prints them all but as separate reports.

I have tried the switchboard route - same thing.

The only thing left is a Master report with 8 subreports. I am having
trouble with getting blank pages (every other page) and how do I handle
headers? The reports will have slightly different headers. All of the reports
are 2 pages. I can get a header on the first page only.

Any help/ideas is appreciated.

 

[Duane Hookom]

I expect you are getting blanks because of either widths or keep together/new
page properties.

Subreports won't have page header sections. You typically create a Sorting
and Grouping section on a constant like:
=1
View the group header section for this group and set its Repeat Section
property to Yes.

 

[Warman]

Thanks for your help. Things are starting to work on this one. Tell me this,
since the headers will be a little different for each report (there are 8 of
them), what is the best way to change the header for each one.

I have the header for the first one working and then I have page breaks set
to start the next report. You may be answering this with the "Repeat Section
property to Yes". I just haven't had time to try that one yet.

Thanks Again.

 

[Duane Hookom]

Each of the subreports can have their own Report Header section. This section
will only render once per subreport. The other group section I suggested
would be similar to a Page Header in terms of functionality.

I don't know what else you might want.