Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Multiple page Report
Som Szilard 
   
4 years ago
Dear Sir,

may i ask your help please,
I have a project what include a report with 4 pages, on two of them there is a subreport which should display more records.
my question is if there a way somehow to make a single report with 4 pages (build, or concatenate these pages), I've tried but not succeeded.

Thank you in advance.
Szilard
Europe, Romania  
Richard Rost  @Reply  
          
4 years ago
I can't picture what you're trying to do. Can you upload some screen shots of what you'd like it to look like?
Som Szilard OP  @Reply  
   
4 years ago
Dear Richard
Thank you for your answer, and I'm sorry for my bad English,
so, I will try to attach some pictures
the idea it would be that I've created 4 reports (FirstPageR, SecondPageR, ThirdPageR, LastPageR) all reports are A4 format, and now if I want to print them it will send to the printer 4 jobs each with 1 page, I would like to merge them into a single Report, but I don't know how I should achieve it.
thank you for your help
Sincerely
Tahnk you in advance.
Szilard
Som Szilard OP  @Reply  
   
4 years ago

Som Szilard OP  @Reply  
   
4 years ago

Som Szilard OP  @Reply  
   
4 years ago
this is the first page and i a have 4 reports with page 1, page 2, page 3, page4 these are separate reports i would like to merge them into one single report, maybe if you can post an example, because viewing your videos and reading your documentations are very useful.
Thank you,
Richard Rost  @Reply  
          
4 years ago
Make one report with 4 subreports - each of those single page reports can be a subreport - just like you can have a form with multiple subforms.

However, if the data is similar in each of the pages, why not just merge them all together first with a Union Query?
Som Szilard OP  @Reply  
   
4 years ago
Thank you for your quick answer
unfortunately, each page contains different information (Ordin de compensare its the title of each page), how should i position each subreport one single report, and where I mean on the Page Header, or Details section?
Because if ai tried to add like subreports. (I will attach some screenshots, what I've tried) but didn't succeed.
if i put them into the detail section I can't see only a half page or less from each page and if I large them, access telling me that the report is bigger than the report margins. i tried to search in Microsoft access courses section but I did not find any sample or video.

thank you for your support

Som Szilard OP  @Reply  
   
4 years ago

Som Szilard OP  @Reply  
   
4 years ago

Som Szilard OP  @Reply  
   
4 years ago

Richard Rost  @Reply  
          
4 years ago
You may have to reduce the width of the subreports. If your parent report is 8.5" wide, with .25" margins, that only gives you 8 usable inches. Your subreports should therefore be no wider than 7.9" INCLUDING their margins.
Kevin Yip  @Reply  
     
4 years ago
You may want to put a "page break control" in between reports so they all start on a new page, if that's how the reports are supposed to start.  Also, the subreport controls need to have "Show Page Header and Footer" set to Yes if you want to show them.  See pictures below.
Kevin Yip  @Reply  
     
4 years ago

Som Szilard OP  @Reply  
   
4 years ago
Dear Richard and Kevin

Thank you for your support and help
i succeeded to place on one report all 4 reports (like subreports) but if you can help me with one more info please
I've selected the show page header and footer option in properties to yes as you suggested to me, but the Page Footer information is missing form all pages, everything else it seems to be good on the report.
Thank you once again for your effort to help me

Som Szilard OP  @Reply  
   
4 years ago

Som Szilard OP  @Reply  
   
4 years ago

Som Szilard OP  @Reply  
   
4 years ago

Kevin Yip  @Reply  
     
4 years ago
Yes, I forgot. This method does not print page footers, because subreports have no control of the page settings of the parent report.

Without modifying your reports (which could be daunting), the simplest way is to export your 4 reports to PDFs, then use an external PDF merger tool to merge the 4 PDFs together.  I used a freeware tool a long time ago called PDFtk, and fortunately it is still in business: https://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/ .  

On the Access navigation pane, right-click on a report name -> Export -> PDF.  This can also be done in VBA with DoCmd.OutputTo.

Then open the freeware tool to merge the PDFs manually with its graphical interface.  This can also be automated with VBA by running a command line supported by this freeware tool.  The command line looks like:

pdftk file1.pdf file2.pdf file3.pdf file4.pdf cat output merged.pdf

You can use the Shell() function to run a command line in VBA.

Som Szilard OP  @Reply  
   
4 years ago
Dear Richard and Kevin

Thank you for your support and your help, it's working now.
Thank you.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/7/2026 5:17:46 AM. PLT: 1s