Combine two reports from two different queries

[Tim]

Hello all...

I have two reports pulling information from two different queries that are
creating two different reports. The reports are formated very differently,
with one having a report header and footer, they other doesn't.

Is there a way to get them to show up in one report and maintain the format
of each report? I need the report header and footer to only show up on pages
3 and on.

Any help out there?????

 

[Marshall Barton]

I have two reports pulling information from two different queries that are
creating two different reports. The reports are formated very differently,
with one having a report header and footer, they other doesn't.

Is there a way to get them to show up in one report and maintain the format
of each report? I need the report header and footer to only show up on pages
3 and on.

You could try dropping both those reports into a new unbound
blank main report. Everything except the subreports' Page
Header/Footer and the Page event should work.

 

[Mark Andrews]

If the other suggestion doesn't work (just making them subreports in a new
report or one a subreport in the other) then the only
suggestion I can think of is to create pdf files and then merge the pdf
files into one file.

You can use some of the lebans code to possibly merge pdf files (or their
are other pdf merge capabilities out there).

HTH,
Mark
RPT Software
http://www.rptsoftware.com