sub-reports page numbering

[bmo]

Hello. I hope you can help.

I have a report with about 4 subreports in it. No subreports are nested
within each other so the report looks like this

--main report (grouped on accountID)
--subreport1
--subreport2
--subreport3
--subreport4
--end main report

All the subreports relate to an account number grouped on the main
report. Each sub report can be more then one page long. What I am
looking for is to be able to number the pages of all subreports
starting from page one of subreport1 to the last page of subreport4.
then start the numbering all over again on the next account number. I
need the number in the format of "1 of 10".

I hope this makes since. If I put this =[Page] & " of " & [Pages]
in the footer of the main report and it just gives me the total number
of all reports like Page 1 of 4356, not Page 1 or 10 pages.

Any help would be appreciated.

 

[Marshall Barton]

I have a report with about 4 subreports in it. No subreports are nested
within each other so the report looks like this

--main report (grouped on accountID)
--subreport1
--subreport2
--subreport3
--subreport4
--end main report

All the subreports relate to an account number grouped on the main
report. Each sub report can be more then one page long. What I am
looking for is to be able to number the pages of all subreports
starting from page one of subreport1 to the last page of subreport4.
then start the numbering all over again on the next account number. I
need the number in the format of "1 of 10".

I hope this makes since. If I put this =[Page] & " of " & [Pages]
in the footer of the main report and it just gives me the total number
of all reports like Page 1 of 4356, not Page 1 or 10 pages.

This is not a simple problem, especially since the main
report is in charge of paging activities. Subreports do not
have page headers/footers, nor page numbers so everthing
will have to be done in the main report.

Fortunately you want to number all the pages within an
account, so the subreports really do not really enter into
the problem.

With that background, you can use the technique provide in
this article:
http://support.microsoft.com/kb/841779/en-us

 

[bmo]

Thanks. It worked like a charm!

I have a report with about 4 subreports in it. No subreports are nested
within each other so the report looks like this

--main report (grouped on accountID)
--subreport1
--subreport2
--subreport3
--subreport4
--end main report

All the subreports relate to an account number grouped on the main
report. Each sub report can be more then one page long. What I am
looking for is to be able to number the pages of all subreports
starting from page one of subreport1 to the last page of subreport4.
then start the numbering all over again on the next account number. I
need the number in the format of "1 of 10".

I hope this makes since. If I put this =[Page] & " of " & [Pages]
in the footer of the main report and it just gives me the total number
of all reports like Page 1 of 4356, not Page 1 or 10 pages.

This is not a simple problem, especially since the main
report is in charge of paging activities. Subreports do not
have page headers/footers, nor page numbers so everthing
will have to be done in the main report.

Fortunately you want to number all the pages within an
account, so the subreports really do not really enter into
the problem.

With that background, you can use the technique provide in
this article:
http://support.microsoft.com/kb/841779/en-us