Have report page number restart after each group

[DataHandler]

I have a query that shows various medical carts with appropriate items on the carts. I would like to be able to print an entire report based on this query and to restart the page numbering when a new cart group begins, this can vary depending on the number of items on the cart.

 

[CautionMP]

Create a macro with the following information.
Action: SetValue
Item: [Page]
Expression: 1

After saving the macro set the OnFormat event in the Group Header to the name of the macro.

I got this tip from this site or MSDN if you need more details.

 

[DataHandler]

Thank you CautionMP, however this is only gives me half of what I need.
While it does restart the page count for a new group, I would also like for it to tell me the total number of pages in the group - for instance the first group prints on 3 pages therefore I need to see Page 1 of 3, Page 2 of 3, Page 3 of 3; then the next group may print on 10 pages, so I need Page 1 of 10, Page 2 of 10, etc. until the last group prints and show its appropriate page count.

Hope this isn't to difficulty?