Joining Several Reports into One Report Object

[Gunner113]

Hi all,

Here's the story... I am working with a great, third-party, PDF renderer,
though it does not appear to have the ability to combine multiple Access
Report objects, and only renders a single object to a single PDF. There is
no PDF printer involved.

My client needs to be able to combine several report objects into a single
(uniquely named) report object that would then be rendered to PDF for
dissemination. I could build several long, specialized reports, but I'd
rather find out how to leave them a dynamic, coded solution that they can use
long after I leave.

Any ideas?

 

[Marshall Barton]

Here's the story... I am working with a great, third-party, PDF renderer,
though it does not appear to have the ability to combine multiple Access
Report objects, and only renders a single object to a single PDF. There is
no PDF printer involved.

My client needs to be able to combine several report objects into a single
(uniquely named) report object that would then be rendered to PDF for
dissemination. I could build several long, specialized reports, but I'd
rather find out how to leave them a dynamic, coded solution that they can use
long after I leave.

The standard approach for that is to create a new unbound
report and drag/drop your existing report into it.

The subreport page headers and footers (and Page event) will
not be processed so you may have to make some additional
changes.