Two Reports into One

[ArfurFuxache]

I have developed two reports that work perfectly as individual reports - (same as other thread) but I need them to print as one report in order that when the PDF printer driver is selected it outputs both reports in a single file as a PDF.

Report 1 is a quotation report with a sub report for the quotation line items.
Report 2 is an order form with three different layouts depending on the type of quotation.

I have tried including the order form as a subform of the quotation form but I seem to be struggling with:

1. The order form refuses to start on a new page, it just continues on from the main report.

2. The layout of the order form is totally dependant on the vba behind the report to drive content and visibility. I have set watches on this code but when run as a subform the watch doesn't even trip - To me this means it is not executing. I have tried on activation and on page.

Any help would really be appreciated

 

[misscrf]

Have you tried putting the second report as a subreport of the main reports Report Footer and forcing that section to 1)keep together, 2) force new page/section (can't remember option).

Please let me know if you need more.

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[ArfurFuxache]

Thanks for responding Misscrf. I have tried the sub report route but for one reason or another (probably my lack of knowledge) the VBA behind report two wouldn't kick in.

I have since included report 2 into report in the footer and transfered the VBA into report 1 - All works fine.

 

[misscrf]

cool. Glad you found a solution.

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[sxschech]

Another option...If you don't need full automation and want to compile multiple reports AND you have Adobe Acrobat Professional, you could output all the reports to PDF and then use Acrobat to combine them into one PDF file.