[AccessD] Interleaving two reports

[Jim Dettman]

 You can't rely on Format Count if Access retreats up a page.

 << 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).>>

 That's the ticket.

Jim.

-----Original Message-----
From: AccessD On Behalf Of Bill Benson
Sent: Sunday, January 22, 2023 7:34 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Interleaving two reports

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