Tags: access, combine, combining, create, database, footers, microsoft, mysql, oracle, pageheaders, report, reports, snapshot, sql

Combine 2 reports into one

On Database » Microsoft Access

3,854 words with 5 Comments; publish: Fri, 30 May 2008 20:55:00 GMT; (250125.00, « »)

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

All Comments

Leave a comment...

  • 5 Comments
    • 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

      "Sarah" <Sarah.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      news:A5E6F779-683A-4F02-AFFB-8964AE2DFC48.ms-access.questionfor.info.microsoft.com...

      > 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

      #1; Fri, 30 May 2008 20:56:00 GMT
    • 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.

      "Jeff Boyce" wrote:

      > 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

      > "Sarah" <Sarah.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      > news:A5E6F779-683A-4F02-AFFB-8964AE2DFC48.ms-access.questionfor.info.microsoft.com...

      >

      >

      #2; Fri, 30 May 2008 20:57:00 GMT
    • 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

      "Sarah" <Sarah.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      news:D67FF095-BA07-4141-8A15-49FD67598F49.ms-access.questionfor.info.microsoft.com...[vbcol=seagreen]

      > 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.

      > "Jeff Boyce" wrote:

      #3; Fri, 30 May 2008 20:58:00 GMT
    • 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.

      "Jeff Boyce" wrote:

      > 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

      > "Sarah" <Sarah.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      > news:D67FF095-BA07-4141-8A15-49FD67598F49.ms-access.questionfor.info.microsoft.com...

      >

      >

      #4; Fri, 30 May 2008 21:00:00 GMT
    • Thanks for taking the time!

      Regards

      Jeff Boyce

      Microsoft Office/Access MVP

      "Sarah" <Sarah.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      news:B0186F13-5EC3-4682-9119-A35F7A1E7582.ms-access.questionfor.info.microsoft.com...[vbcol=seagreen]

      > 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.

      > "Jeff Boyce" wrote:

      #5; Fri, 30 May 2008 21:01:00 GMT