[AccessD] Interleaving two reports

Wed Jan 18 00:36:40 CST 2023

I must be missing soemthing. That sounds to me like just a normal report with two sub 
reports linked on ID and a page break between them.

On 17 Jan 2023 at 22:28, Ryan W wrote:

> Sorry if I added confusion. The whole sum of pages from report 1 ID1
> should be extracted, then the whole sum or pages for report 2 ID1 come
> after, rinse and repeat. 
> 
> They are related by an ID but the reports are for different datasets. 
> This is a pretty rare occurrence and request by a small handful of
> clients and I am just trying to make it easier on the ones running the
> reports as the process is tedious and error prone to do "by hand"
> 
> The reports don´t always have an identical number of pages so
> obviously interleaving would stop at one point if the reports are not
> equal length. 
> 
> Sent from my iPhone
> 
> > On Jan 17, 2023, at 9:55 PM, Rocky Smolin <rockysmolin2 at gmail.com>
> > wrote:
> > 
> > That is a very odd requirement.  Does the content of each page of
> > the report stand alone? IOW does the page end at a logical place. 
> > Most reports I have written in Access the content from page one
> > continues on page 2.
> > 
> > What I'm seeing in my mind's eye are two books with their pages torn
> > out and stitched back together - the first page of both books then
> > the second page of both  books, etc.  When trying to read the
> > combined books there's no continuity of either story - pages of the
> > two books break in the middle of a paragraph, or sentence, or even a
> > word.
> > 
> > This can't be the case with your two reports. Can it? So I will have
> > to accept that interleaving the pages as you say doesn't lead to an
> > incomprehensible mash-up of the two reports.
> > 
> > Are the number of pages of each report the same? Is there a
> > one-for-one relationship?
> > 
> > I would love to see these two reports to see how the content of the
> > several pages of each.  Is that possible?
> > 
> > r
> > 
> >> On Tue, Jan 17, 2023 at 6:01 PM Ryan W <wrwehler at gmail.com> wrote:
> >> 
> >> The reports differ in nearly every regard, there are some
> >> commonalities in the page headers and the page footer always just
> >> shows page N of NN, worrying about the page footer during the
> >> interleaving process is not of importance. Both page header and
> >> footers repeat on a per page basis on both reports.
> >> 
> >> The number of pages per report can differ, maximum would be 99 IDs,
> >> possibly more than 99 pages if any of the detail section data
> >> spills into more pages with our current config.
> >> 
> >> After I emailed this off I talked to one of the users doing the
> >> hand interleaving and there may be a third report that is used
> >> depending on client requirements.
> >> 
> >> 
> >> 
> >> 
> >> 
> >> On Tue, Jan 17, 2023 at 7:46 PM Rocky Smolin
> >> <rockysmolin2 at gmail.com> wrote:
> >> 
> >>> 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
> >>>> 
> >>> --
> >>> 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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com