Link to home
Start Free TrialLog in
Avatar of mlcktmguy
mlcktmguyFlag for United States of America

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.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mlcktmguy

ASKER

Yes, I checked the setup on both and the main report was different on the most recent 9 pager.  When I made it consistent with the way the main report on the 5 pager had been set up it all worked as it should.
Thank you