Page numbers on sub reports?

[Tony Williams]

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

 

[John Spencer]

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
'====================================================

 

[Tony Williams]

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
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. 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