[AccessD] Interleaving two reports

[Ryan W]

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