Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

Page numbering for each subreport in a master report.

I have a report that combines 3 subreports in one master report.  

I want to be able to print, on the bottom of each page of the master report, the number of the subreport on that page and the page number within that subreport.  
Example:
If the master report is being printed and subreport 1 spans 2 pages, subreport 2 spans 3 pages, and subreport 3 spans 1 page, the bottom of the report for those pages will be...

Subreport 1 - Page 1
Subreport 1 - Page 2

Subreport 2 - Page 1
Subreport 2 - Page 2
Subreport 2 - Page 3

Subreport 3 - Page 1

*Comment - Each subreport starts on a new page*

The bottom line question is this - Can I tell which subreport is being printed on a particular page?
If I can get this information I can set the the subreport/page information into the footer via vba.
0
jhadley
Asked:
jhadley
  • 7
  • 3
  • 2
  • +1
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
In all of these reports/subs enter this code in the PageFooter.OnFormat property

Me.MyLabel.Caption = "Whatever this report name is - Page " & Me.Page

You can also use the line above, with & " of " & Me.Pages to display the total number of pages.

Hope this helps.
-Jim
0
 
Excalibur_SoftwareCommented:
Have you tried placing the Page object in the subreport footer?
0
 
jhadleyAuthor Commented:
I tried it to confirm.  Subreports do not have pages/page events triggered.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
jhadleyAuthor Commented:
Sorry, I was not very clear.  Jim - I appreciate your suggestion, but it does not work because sub reports don't have page events.  Bummer.
0
 
jhadleyAuthor Commented:
Excalibur, I may have read your suggestion wrong, but I think it suffers the same limitations as Jim's solution.  Please clarify, if I am missing something.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Every report has a Page Footer, and every Page Footer section has an OnFormat event.

If you can't see it on your report, go to the View menu item and select Page Header/Footer.

-Jim
0
 
jhadleyAuthor Commented:
Jim
I put your suggested code in the OnFormat event on my first subreport.  If I run that subreport by itself (and not within the master report), it works fine.  Once I put it into the master report that code does not work (in fact it doesn't get called at all) - presumably because subreport don't trigger page events.

Am I missing something in your instructions?
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Hmm.. I'd have to test that one, but it looks like you've already done that.  Does the master report's .PageFooter fire even when the sub breaks?
0
 
jhadleyAuthor Commented:
The master report's page footer fires for each page.
0
 
shanesuebsahakarnCommented:
As you've noted, the page event doesn't fire for subreports. What you will need to do is to bind the report to a one-record table and create three group headers. Put the subreports into each of the group headers and reset the page numbers like this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;841779&Product=acc
0
 
jhadleyAuthor Commented:
Your answer will work for the question that I asked, so I will award shaesuebsahakarn the points.  Unfortunately, I actually have more than 10 subreports in the master report.  The proposed solution will work for the three reports I described in me question, but because the maximum number of groups that you can have is 10, it won't work for me.  In trying to make my scenario as easy to follow as possible and I inadvertantly crossed a important criteria boundary that I did not realize existed.

Thanks for the help, and I will probably post another question with more accurate criteria.
0
 
shanesuebsahakarnCommented:
Don't forget that you can use both the group header and footer for this purpose (giving you a total of 20 sections).
0
 
jhadleyAuthor Commented:
Thanks for the tip.  I'll give it a try
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 7
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now