In my report and from my other post...

I'm dealing with old reports that uses a bunch of groups footers and sections.

Eveything is looking great. Until the Total Page count seems to reset it's counter.(Displaying 1) I kind of need to use the Reset Page Number After for my reports. As it's seem to be the only solution that would fix my spacing problem.

So I was wondering if there is a work around for counting pages.

I don't know if this will work, but it's worth a try....

1.  I assume you have an outer group that determines where the page number gets set.  Create a formula that is a combination of the field for the outer group and the page number.  Assuming the group field is a string, it would look something like this:

{group field} + ToText(pagenumber, 0,'')

2.  Create a running total that does a count of this formula, evaluate on change of the formula, reset never.  This should give you the total number of pages that have processed so far at any point in the report.  At the end of the report it will have the total number of pages in the report.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

Ah thanks.

i had to wrap it around in a group.

then i just used your idea.

but you have to use a dummy field for {group field} + ToText(pagenumber, 0,'') or else you can't create a running total.

thanks a lot.