[AccessD] Interleaving two reports

[Ryan W]

Shuffle the pages:

Rpt 1 P 1
Rpt 2 P 1
Rpt 1 P 2
Rpt 2 P 2...

I have the code to do and print to a PDF printer which can then be merged
quite easily, but it would be nice if I could just append each page sent to
the PDF printer to the PDF being built.

I'll be tinkering around with Jim's idea of trying to interleave the data
in the report as opposed to my code loop but I didn't have luck using my
existing reports as subreports on a new main report (likely due to having
page headers, detail sections etc).  It only printed the first detail
section from the first subreport and not the second subreport.



On Tue, Jan 17, 2023 at 6:42 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> By interleave do you mean show part of report A, then part of report  B,
> then another part of report A, another part of report B, etc.?
>
> r
>
> On Tue, Jan 17, 2023 at 10:37 AM Ryan W <wrwehler at gmail.com> wrote:
>
> > Does anyone have any suggestions on how I can interleave two separate
> > reports?
> >
> > They both contain data that can be grouped together by an ID, but the
> > report format is different between them and at the moment my end users
> are
> > printing both reports to PDF and then interleaving them in the PDF to
> > produce the desired report.
> >
> > My current thought is somehow to use DoCmd.PrintOut and a loop to print
> an
> > alternating page range.  I just need to somehow ensure that if the report
> > per ID is more than one page that gets accounted for as well.
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>