Combine 5 reports.

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a list box where I select the reports I want to
view.
I'm using an if statement, If this is selected, open this
report.

Each report is using a different Query with different
information.
Is there any way to combine 5 reports into 1, so I can go
to page 1, page 2?

Thanks

Tim
 
Tim:

There are really only two practical ways to combine reports, however doing
so on the fly requires a bit more work.

Method 1:

You can create a single main report and then add each individual report that
you want to combine as a sub report. Note however that if you use page
headers in your reports that you want to combine, these need to be changed
to either report headers or group headers. If there's no groups in your
reports, then you can either create one using say the primary key that the
report is based upon and simply move your page header into that section.

To "merge" reports on the fly you'd have to open your main report in design
view (using the Echo command to hide this from the user) and then change the
control source for each of the sub report controls that you've added to the
main report.

Method 2:

You could output your reports to individual PDF files and then merge those
into a single PDF file. Since Access doesn't have this capability built in
you'd have to use a third party tool to do this. There are a few out
there, including the one you'll find on our web, our PDF and Mail Library
for Access, which, if you use the PDF Pro or PDF Pro Plus edition would
allow you to combine reports on the fly.

HTH
 
Steve,

Part A of Method 1 seems to be ok.
Can you please explain part 2 "merge" ?
What do you mean "On the fly" ?
Is this a different Method?

Thanks
Tim
 
Back
Top