reset page number

[alvintse]

I am using CR9 and have the question below:

Say a report returns 3 users and has total of 9 pages. I set new pages after each user. For each page, I want to place the "Page N of M" at the page footer.

User A contains 3 pages.
User B contains 2 pages.
User C contains 4 pages.

The result should look likes this for each page at the footer:

User A:
Page 1 of 3
Page 2 of 3
Page 3 of 3

User B:
Page 1 of 2
Page 2 of 2

User C:
Page 1 of 4
Page 2 of 4
Page 3 of 4
Page 4 of 4

It seems the special field "Page N of M" will not work in this case.
I am thinking if I can find out how many pages of data for each user from the beginning of the report, then I can manually increment the page number and reset the starting page number after each user.

Any suggestion on how to deal with this?

Thanks.

 

[lbass]

Page N of M should work fine, as long as you set "Reset Page Number After" on the same group footer (the user group) where you are setting "New Page After."

-LB

 

[alvintse]

Thanks lbass, I never notice this function even I accessed section expect thousands of times.