Print two reports - alternating between the two 1

[jbehrne]

Hi all,

I've got two reports that I finished creating recently. One report is a correspondence letter to contacts in various departments that my organization deals with. The second report contains billing data for review by the same contact.

Here is the problem that I am facing. I need to print both reports - but alternating between the two for each contact.

So when my user press the print button both reports would print, but the corresondence report for that contact would print first and then the data verification report for the same contact would print, and then the correspondce report would print for the next contact and the data verification report for the same contact, etc..

Thus the reports should print like this:

Ex:

Jim - Correspondence report
Billing data verification report
Sara- Correspondence report
Billing data verification report
etc...

How can this be done? I'm stumped and did not find any info on the net... Any ideas would be greatly appreciated!

jbehrne

If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

 

[Remou]

I think the safest way would be to include billing as a subreport. Or even create a new report with correspondence as subreport one and billing as subreport two. It would be possible to use the PrintOut method, but there is a great danger of things going out of sequence.