Larry Moody solution can work for you then.
>>>>>How to make that _PageTotal variable that is placed in field in page footer to show total pages for groups in report?
>>>>>Also if there are groups _PageTotal doesn't show correct number of total pages in report, how to correct that?
>>>>
>>>>Check
Re: Page Total Problem Thread #
1320884 Message #
1321284>>>
>>>I thought that there is some simple "one word" solution. :)
>>>Unfortunately, this seems to much bigger issue, with running report twice, writing custom functions...
>>>Are you sure that there isn't some simpler solution?
>>>
>>>And, I am not using Report Listener, just for info.
>>
>>If you know how many records are always on one page and how many records per group you may try to pre-calculate the numbers in advance. But if there is no fixed numbers of records per page, I can only recommend double run.
>>
>>See
Re: Page Total Problem Thread #
1320884 Message #
1321006>
>No, I have fields with overflows, I can't be accurate with calculating records.
>Double run is just too slow, it's not a good alternative.
>I never in the past put Page # of ##, so I was really surprised that this is an issue that Microsoft didn't solved correctly as you might expected.
>Hm, I guess it will never be solved now.
If it's not broken, fix it until it is.
My Blog