Combine 2 reports into one

  • Thread starter Thread starter Sarah
  • Start date Start date
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
 
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
 
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.
 
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
 
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.
 
Back
Top