Stumped! Multiple Report Print Jobs Taking Forever! 1

[MrMeric]

Good day to all -- I'm stumped!

My database consists of 4 reports; for ease of use I will call them Report1, Report2, Report3 and Report4.
Each one of these reports is more or less a legal form.

The user would like to have the reports collated for each record that is printed, so the reports end up printing like so:
(Assuming there are 2 records in the database. One record for "Joe Bob" and another for "Tom Lam")

-----[Example Print Job]-----
Report1 for "Joe Bob"
Report2 for "Joe Bob"
Report3 for "Joe Bob"
Report4 for "Joe Bob"

Report1 for "Tom Lam"
Report2 for "Tom Lam"
Report3 for "Tom Lam"
Report4 for "Tom Lam"
-----------------------------

I already developed the code for collating the reports, but it runs so slow! For each report and customer it must create a new print job. As you can see, for 2 people and 4 reports, it needs to create 8 print jobs!

There are about 1,000 customers in the database right now... so this type of printing is not really an option as it will take forever.

My question is this: Is there a faster way to print multiple reports for each customer within a database?

I tried a MailMerge, but that took forever also. I also tried combining the reports, but the reports can only be 21" IIRC.. so that was a no go.

I really need some assistance. I'm stumped.

Thanks!

 

[dhookom]

You don't say whether or not you have page numbering that needs to start over with new customers. Can't you just run a report with two subreports?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[MrMeric]

Duane,

Page numbering is not a concern, as these are all one page reports.

How would I go about using subreports for this?

 

[dhookom]

I would create a new main report that is based on your table of customers. Then drop each of your four other reports on the new report and set the Link Master/Child properties to the Customer primary key. You may need to add a page break control between each of the subreports.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[MrMeric]

[COLOR=red yellow]DUANE, YOU ARE A GOD![/color]