Combine 2 reports into one

S

Sarah

Does anyone know a good way of combining 2 reports into one report with page
headers and footers from both reports? I need to create a snapshot file
which contains both reports. Unless there is a way to take the results of
one report and append them to a snapshot file.

Thanks for any ideas.

Sarah
 
J

Jeff Boyce

Sarah

Are the two reports related in some way?

Have you looked into adding one or both as "subreports" to another "report"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
S

Sarah

Yes I have looked into adding Rpt1 into Rpt2 as a subreport, but can't seem
to get the page headers and footers to come out on the subreport. The 2
reports do not have similar data sources. Both reports have grouping and
within the grouping I reset the Page everytime a new value is encountered for
the group. Also the Pages is always reset to the number of pages for each
group value.
 
J

Jeff Boyce

Not sure how to help on something like that.

Maybe one of the other newsgroup readers can offer ideas...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
S

Sarah

Jeff, I was able to figure it with some help from 2 other question/answers
about getting page headers for subreports and re-numbering the Page and Pages
property for groupings.

Thanks for your time.
 

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

Similar Threads

Combine / Append Reports 2
Multiple Reports-One output file 2
Print several reports as one 3
snapshot viewer problem 3
Gouping In Sub Reports Leaving Windowed Headings 2
Combining multiple reports into one report or PDF 3
Combine 2 reports into one 2
ConvertReportToPDF - Lebans - Converting Multiple Reports at once 3

Top