Running Sum Across Groups

[Larry]

I find a lot of post talking about running sum but still can not make it work.

I'm grouping bank account data by Region, Bank & Branch. In each group
footer I want to count the number of accounts opened during a specific period.

In the detail section I'm testing account opening dates to see if it was
opened during the specified period and setting it to 1 if yes or 0 if no and
that works fine.

In the Branch Footer I add a text field with it's control as "=sum(<<same
expression as in detail>>) and set the running sum to Across Group.

I repeated that for the Bank Footer and Region Footer.

Within the first Region, all the Branch Footers work and all the Bank
Footers work and the Region Footer works.

Going into the 2nd Region Group and thereafter, the group counter stop
resetting and just keep a running total.

I see lots of people using the running sum by group but have seen a post
stating that this doesn't work.

Any help would be greatly appreciated because I have about 20 other status
for each account that I need to track in a similar manner (count the number
of each transaction types, count the number of account types etc).

I'll be glad to send any other details you want.

Thanks.