Print Separate Reports with collate

[HendriX99]

Hi All
I have to print 3 different reports (say: rpt1, rpt2 and rpt3), each report is grouped by a field which is present in every one (say: PRODUCT CODE).



Now, I'm trying to print all the reports at the same time collating them by the "PRODUCT CODE" with no luck.
Basically, I'd like to get printed, in sequence:

1. rpt1 (all the pages related to the first PRODUCT CODE)
2. rpt2 (all the pages related to the first PRODUCT CODE)
3. rpt3 (all the pages related to the first PRODUCT CODE)
4.rpt1 (all the pages related to the second PRODUCT CODE)
5.rpt2 (all the pages related to the second PRODUCT CODE)
6.rpt3 (all the pages related to the second PRODUCT CODE)
and so on, for each product code record


I've tried several VBA codes without success, any idea?


thanks in advance

[HendriX99]

I have also tried the solution by Microsoft:
http://support.microsoft.com/kb/292461/en-us?fr=1

but just one page is printed...

[SteveF]

Hi All
I have to print 3 different reports (say: rpt1, rpt2 and rpt3), each report is grouped by a field which is present in every one (say: PRODUCT CODE).

Now, I'm trying to print all the reports at the same time collating them by the "PRODUCT CODE" with no luck.
Basically, I'd like to get printed, in sequence:

1. rpt1 (all the pages related to the first PRODUCT CODE)
2. rpt2 (all the pages related to the first PRODUCT CODE)
3. rpt3 (all the pages related to the first PRODUCT CODE)
4.rpt1 (all the pages related to the second PRODUCT CODE)
5.rpt2 (all the pages related to the second PRODUCT CODE)
6.rpt3 (all the pages related to the second PRODUCT CODE)
and so on, for each product code record


I've tried several VBA codes without success, any idea?


thanks in advance

How about designing your reports so that they group by each product code, with a group footer that includes a page break between each group?

Then, you just need to call rpt1, rpt2, and rpt3. Each report will then be collated and separated for each product code.

Steve

[HendriX99]

thanks for the tip, but the reports have a differnt page orientation (landscape and portrait), so the trick doesn't work

I was thinking to use a VBA code with the variable "PRODUCT CODE" in a loop to use as FILTER of each report, but honestly I don't know how to do it...