Page numbering for each subreport in a master report.
Posted on 2004-10-01
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.
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.