HI Has anyone figured out how to reset the page numbers after a grouping and have it display in the format Page X of Y? I can get it to reset the page number for each group and display Page X but its the of Y part that is a problem. Thanks,

Hi, Do you want something like this. If their are 10 pages in your report do you want to display Page1of 10 in first page, Page 2 of 10... in next page in page footer? Let me know.. Anupama

Look for "Resetting the Page Number on a Group" inside the following article. Report Design Tips and Tricks http://msdn2.microsoft.com/en-us/library/bb395166.aspx AMB

There was an extensive discussion on this forum about getting page totals by group, with a quite creative yet effective technique for accomplishing this task. See the entry at: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1807270&SiteID=1 and then follow the links on the post dated March 2, 2008 by Lisa Nicholls. These take you to a detailed discussion with lots of code about how to meet your objective. Warning: this may not be for the faint-of-heart. Hope this helps, Scott

Hi, I'm am following this along in the article but the screenshot showing the programming to key in on the Code Tab is cut off. Can you tell me what it should say? Shared offset as Integer Shared currentgroup as Object Public Function GetGroupPageNumber(group as Object, pagenumber as I (it is cutoff here) If Not (group - currentgroup) ....

Please disregard my post above. I have it working.