Combining multiple reports

  • Thread starter Thread starter BarryL
  • Start date Start date
B

BarryL

I have a database that consists of a large number of individual reports
(100+). To produce custom reports for clients, I create one large report by
printing a selection of several individual reports to a pdf file and then I
combine the resulting pdf files into a single multi-page report for
distribution.

Is there some way to combine selected multiple reports within Access so that
I could print the report directly as a single pdf.
 
You could add a sub report to the main report.

I recently made a report that has a variable subform in its detail section.
The properties Link Child Fields and Link Masterfields are set to a global
record key (GUID in my case). Then in the open event I added the following
code:

Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = GetSource(Me.OpenArgs)
Me.subwindow.SourceObject = "Form." & Me.OpenArgs
DoCmd.Maximize
End Sub

the child form's name was pushed into the OpenArgs property of the report
like this:

docmd.OpenReport "Report Name",acViewPreview,,,,"Subform Name"
 
Back
Top