Print several reports as one


W

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.
 
Ad

Advertisements

D

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.
 
W

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.
 
Ad

Advertisements

D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top