Collate and print multiple reports

  • Thread starter Thread starter HilcrRWise
  • Start date Start date
H

HilcrRWise

I have 4 separate reports each containg 2 A4 pages of data. What I wan
to be able to do is

print record 1 of report 1 followed by record 1 of report 2, rec 1 o
rpt 3, rec 1 of rpt 4 and

then go back and print rec 2 of rpt 1, rec 2 of rpt 2, etc.

I have tried setting them up as subreports but all the data togethe
exceeds the maximum

available space for the details section of a report.

Is there another way to do this, ie: VB code linked to a button on
form
 
HilcrRWise said:
I have 4 separate reports each containg 2 A4
pages of data. What I want to be able to do is
print record 1 of report 1 followed by record 1
of report 2, rec 1 of rpt 3, rec 1 of rpt 4 and then
go back and print rec 2 of rpt 1, rec 2 of rpt 2, etc.

I have tried setting them up as subreports but all
the data together exceeds the maximum
available space for the details section of a report.
Click to expand...


I don't know what you mean by exceeding the available space.
Generally, subreports only need to take a small amount of
design space and, with their CanGrow property set to Yes,
they will expand to use whatever space they need when the
report is printed.

I think the problem you have is how to coordinate the
subreports to the desired records you want the subreports to
display. Because you didn't explain how the data in the
subreports is related, I can only give a general guideline,
the main report should be based on a query that only
provides the key values of the data records you want the
subreports to print. Use the Link Master/Child properties
so the four subreports in the main report detail display the
matching records.

If you need more help with this, please post back here with
more details about the structure of the data tables
involved.
 
Back
Top