mlcktmguy
asked on
Create Multi Page Letters on one Access Report
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you