[AccessD] Interleaving two reports

Ryan W wrwehler at gmail.com
Wed Jan 18 06:55:29 CST 2023


Ideally, yes but I thought maybe there was a quick way to interleave them. 

I tried (briefly) to make a new report with two sub reports and a page break but it only printed the detail data from the first sub reports first page and nothing from the second. 

I’ll examine this further once I get into work   



Sent from my iPhone

> On Jan 18, 2023, at 12:36 AM, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:
> 
> 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
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


More information about the AccessD mailing list