RunningSum in Report not re-setting by group

[Pea]

Hello,
I have a report with groups, subgroups and counts. I'm trying to give
a total for each group and used the RunningSum property by group. But
I find that it's running throughout the report. Is there a way to
reset this ? Here's an example:

June 2004
John Doe
6/18/04 ABC Transaction 6
6/22/04 XYZ Transaction 2
6/29/04 LMN Transaction 1
Total Transactions for John Doe 9 *exactly what I want

Jane Doe
6/03/04 ABC Transaction 3
6/13/04 XYZ Transaction 1
Total Transactions for Jane Doe 13

*The total should be 4 under Jane Doe but it's keeping a running
total throughout the report instead of re-setting at each user-name
group which is where I set the RunningSum property. Any ideas?

Thanks,
Tara Pillion

[Reggie]

Pea, Set the RunningSum = No. Now it will do an individual sum per group.
Setting runningSum to Over Group sums the first group, sums the second group
and adds that to the first group and so on.

--
Reggie

----------
"Pea" <ta******@yahoo.com> wrote in message
news:f4**************************@posting.google.c om...

Hello,
I have a report with groups, subgroups and counts. I'm trying to give
a total for each group and used the RunningSum property by group. But
I find that it's running throughout the report. Is there a way to
reset this ? Here's an example:

June 2004
John Doe
6/18/04 ABC Transaction 6
6/22/04 XYZ Transaction 2
6/29/04 LMN Transaction 1
Total Transactions for John Doe 9 *exactly what I want

Jane Doe
6/03/04 ABC Transaction 3
6/13/04 XYZ Transaction 1
Total Transactions for Jane Doe 13

*The total should be 4 under Jane Doe but it's keeping a running
total throughout the report instead of re-setting at each user-name
group which is where I set the RunningSum property. Any ideas?

Thanks,
Tara Pillion

[Pea]

Thanks Reggie. That worked like a charm!
Tara

"Reggie" <NoSpam_chief123101@NoSpam_yahoo.com> wrote in message news:<_N********************@comcast.com>...

Pea, Set the RunningSum = No. Now it will do an individual sum per group.
Setting runningSum to Over Group sums the first group, sums the second group
and adds that to the first group and so on.

--
Reggie

----------
"Pea" <ta******@yahoo.com> wrote in message
news:f4**************************@posting.google.c om...

Hello,
I have a report with groups, subgroups and counts. I'm trying to give
a total for each group and used the RunningSum property by group. But
I find that it's running throughout the report. Is there a way to
reset this ? Here's an example:

June 2004
John Doe
6/18/04 ABC Transaction 6
6/22/04 XYZ Transaction 2
6/29/04 LMN Transaction 1
Total Transactions for John Doe 9 *exactly what I want

Jane Doe
6/03/04 ABC Transaction 3
6/13/04 XYZ Transaction 1
Total Transactions for Jane Doe 13

*The total should be 4 under Jane Doe but it's keeping a running
total throughout the report instead of re-setting at each user-name
group which is where I set the RunningSum property. Any ideas?

Thanks,
Tara Pillion