Multiple Reports-One output file

[Guest]

I have several reports that I would like to be able to get into one file. I
tried to combine the reports but they contain different information/formats.
Is there code I can use to output a snapshot of all three reports in one file?

Example- Report 1 is a summary, report 2 is a more detailed level, report 3
contains all the detail.

I would like to be able to create one file that the recipient can scroll
through to get to each report. Any ideas or am I dreaming?

 

[SA]

Cortney:

There's no way to merge snapshot format files. To do that you'd need to
output PDF files and merge them into one file.

Alternately, you could create a main report and add each of the current
reports as subreports. Note however that if you do this, you need to move
any report header date in the current reports to page headers.

 

[Guest]

That works but it causes another question. I have a subreport inserted in
the main report and i would like to average the values in the subreport in
the footer of the main report. is that possible? Everything I have tried
has not worked.