 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2008Page numbers on sub reports?
I have a report that has 2 subreports. The main report is only 1 page long. The 2 subreports can be many pages and I want to show page numbers on these. I have put this in a text control in the page footer of each report ="Page " & [Page] & " of " & [Pages] I want the page numbers for each subreport to start at 1. When I run the reports independently, the page numbers appear. However when I run the reports as subreports on the main report, the page numbers don't show. Why is that? Thanks Tony Because the main report controls page headers and footers. When a report is used as a sub report, it no longer controls the page headers and footers. If you will settle for just Page Number and drop the Of Pages portion, you should be able to get the effect you want. All you need is an event to set the page value to 1. How have you split out the sub reports to print on separate pages? If you are using the grouping to do that you could set the page number in the group header. '==================================================== John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County '==================================================== > I have a report that has 2 subreports. The main report is only 1 page long. > The 2 subreports can be many pages and I want to show page numbers on these. [quoted text clipped - 6 lines] > Thanks > Tony Hi John, the subreports are both in the Report Footer of the main report separated with a page break. This was on the advice of someone as I kept getting a blank page at the start of the report. I created a Groupnumber Footer to overcome this with the subreports in the report footer. I can drop the of pages portion just need the word "page" and then the number starting at 1 for each subreport. How do I set the page value for each subreport to 1? Thanks for your help. Tony > Because the main report controls page headers and footers. When a report > is used as a sub report, it no longer controls the page headers and [quoted text clipped - 25 lines] >> Thanks >> Tony |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.