UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Combine two reports to print (and display) as one    
 
   
jagoodie
post Jun 16 2010, 08:22 AM
Post #1

New Member
Posts: 13



What is the best way to take two separate reports and have them print as one? Currently the user has to run and print each report individually.
tried adding both reports onto another blank report as subreports, but it only prints the Detail section out for some reason.. why?
Sorry, I am new to Access Reports...
Go to the top of the page
 
+
pere_de_chipstic...
post Jun 16 2010, 08:30 AM
Post #2

UtterAccess Editor
Posts: 8,945
From: South coast, England



Hi jagoodie
How are you printing your reports; if in code you could simply print one after the other
DoCmd.OpenReport "Report1", acNormal, , stLinkCriteria
DoCmd.OpenReport "Report2", acNormal, , stLinkCriteria
hth
Go to the top of the page
 
+
jagoodie
post Jun 16 2010, 08:58 AM
Post #3

New Member
Posts: 13



The user actually views the report first.. This method would be good otherwise. Any idea on how to get both reports combined? Why is only the detail section printing?
Thank you!
Go to the top of the page
 
+
pere_de_chipstic...
post Jun 16 2010, 09:31 AM
Post #4

UtterAccess Editor
Posts: 8,945
From: South coast, England



Hi jagoodie
Any headers and footers in a report don't show if the report is included as a sub report to another report.
Logical really because if there were two page headers, one in the report and the other in the sub report there would be a conflict as the page header for the subreport could not be placed at the top of a page esp if there was a page header for the main report - and similarly with the report header.
If your user insists on previewing both reports before printing them there may not be an easy way around the problem.
You could perhaps include both reports as sub reports to a third report in the preview, but you would probably need to use code to change the headers and footers when you moved from the first to the second sub report.
If your user only needs to preview one report before printing then you could use a custom ribbon or menu command to print each separate report consecutively as suggested before.
hth
Go to the top of the page
 
+
jagoodie
post Jun 16 2010, 10:49 AM
Post #5

New Member
Posts: 13



Good info! Thanks again!
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 22nd September 2014 - 07:16 PM