Create Multi Page Letters on one Access Report
Posted on 2014-01-22
I recently posted a question on this. I have many pages of legal documents that must be combined as one access report. All of the document pages/reports pull data from the database.
I set up each page as its own report and wanted to combine them all to print as one report. I got an excellent suggestion to add the individual pages as subreports on one main report. I tried it with a five page report and it worked great.
Now I am trying the technique for the second time on a nine page report and it's not working great. When viewed individually all the pages fit onto one page. When I pull them into the main report as nine subreports, the individual page/reports no longer fit on a single page. The formatting is all askew starting with the first page, which get broken apart over two pages.
I pull each report in as a subreport, one by one.
It's a mess and can't be delivered as is. I am wondering if there are any tricks to using this approach?
Any ideas on what the issue might be.