[AccessD] Interleaving two reports

Bill Benson bensonforums at gmail.com
Sun Jan 22 18:33:55 CST 2023

I think you can use the Format event and the FormatCount property inside
that to control whether and when to show headers, and the parent’s header
can be read from within the code module of the subreport and assigned to
the subreport’s header section as well… long time since I have done
anything fancy.

On Sun, Jan 22, 2023 at 3:28 PM Ryan W <wrwehler at gmail.com> wrote:

> Hey all,
> So sorry I've been quiet on the topic. Weird week at work.
> For now, because of the header differences between the reports I decided to
> use some looping code to use the existing reports to interleave.
> Basically building a recordset for each report ID and opening the report
> hidden with a WhereStatement to limit it by ID, using DoCmd.OutputTo PDF
> with the ID name and date so the files land in the right order in File
> Explorer.
> Once everything is exported the user can select all PDFs and right click ->
> Combine with (Pdf Editor).
> So far it works just as requested.  If I get a chance to rebuild a main
> report with multiple subreports with their own respective page headers (if
> I remember right you make a custom group "=1") so that it shows on each
> page since page header don't work in subreports (going off memory).
> So far the user who primarily hand interleaves these reports is excited to
> use this new method next time.

More information about the AccessD mailing list