Combine 2 reports into one.

[Ben]

Hello,

I have two completely different reports say called rpt1
and rpt2. I have a button on a form to print out each
report seperately. I want a third button that will print
rpt1 with a page break at the end then concat rpt2 to the
end after the page break. I want them both to preview
into the same print preview so I can make it into 1 pdf
file.

Thanks,
(e-mail address removed)

 

[Guest]

I have tried that but the reports are 100% different in
the layout so the report/page headers and footers conflict
with each other.

 

[Katie]

I am looking to do the same thing with three different
reports to send to a customer. I have been looking for
information on how to do this and haven't found anything
useful yet.

I was thinking about just exporting each report and then
combinding them in a different program. Until I come up
with an easier way.

Katie

 

[Jim/Chris]

Have you tried creating a report with no headers and adding
both rpt1 and rpt 2 as subreports?

Jim

 

[Larry Linson]

Have you considered that you can add the other necessary information into
the main report, so that, when printed, it will look like the original two
separate reports?

Larry Linson
Microsoft Access MVP

 

[SA]

Ben:

1.) When combining reports with headers and footers into a main report (i.e.
your originals are now the subs), then note that page headers and footers
from the original report will not display. That information needs to be
moved either report header/footer or to a group header/footer (the latter
is usually the best scenario.) That will retain your headers. If there
aren't natural and logical groups in the reports to be come sub reports,
(e.g. a group in customerid) then you can create an artifical group in the
report by specifying the field name as "1" (without the quotes) and that
will work.

2.) If that doesn't give satisfactory results then you might consider
outputting the two reports to PDF files and then merging those into one PDF
to have a final single document to archive, print or display. (If you've
got Acrobat or say Win2PDF print drivers then you might look our PDF and
Mail Library, Pro or Pro Plus edition to do just that operation.)