[AccessD] Interleaving two reports

[Ryan W]

Well right now both reports are a main report with (different) page header
data and a subreport in the details section.

I may try the two sub reports on a main to see what comes of that.


On Tue, Jan 17, 2023 at 1:25 PM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

> Ryan,
>
>  Why not a main report and a sub-report?  Or two sub reports on a main
> report based on the ID with no detail?
>
> Jim.
>
> -----Original Message-----
> From: AccessD On Behalf Of Ryan W
> Sent: Tuesday, January 17, 2023 1:37 PM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: [AccessD] Interleaving two reports
>
> 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
>