[AccessD] Interleaving two reports

[Rocky Smolin]

Does each page have the headers and footers repeated?

Is the format of the data in the detail section of reports 1 and 2 the same
or different?

Is the number of pages in each of the reports the same ? Can the number of
pages in the reports vary? Maximum?


r


On Tue, Jan 17, 2023 at 4:50 PM Ryan W <wrwehler at gmail.com> wrote:

> 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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>