By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,742 Members | 1,570 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,742 IT Pros & Developers. It's quick & easy.

RunningSum in Report not re-setting by group

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.