Running Sums are grouping like "Over All" though "Over Group" is s

[Guest]

Hello,

I have a report with three group levels; Facility, Acct Type, and Discharged
(Yes/No). There is a Sum function (=Sum([acctBal])) summing the acct balance
dollar amounts, and a Count function (=Count([AcctBal])) counting the accts
in each group. For each group level, the totals are continuing to accumulate
beyond each change in group value, even though "Over Group" is selected for
the running sum property. For instance, at the facility group level, the
first facility total/count is correct, but the second facility contains the
total/count of the first AND the second facility. Same is true for Acct
Type, but the aggregation seems to "reset" at a change in value of the group
above it (Facility). Same holds true for "Discharged".

Originally, I thought I was supposed to be able to just add a text box
control to the group header, type in the name of the control from the details
section I was totalling ([AcctBal]), and select Running Sum = Over Group, and
that would total the values by group... but when I do that, instead, I get
the value of ONLY the first record in the details section, instead of the
total of all of the records. Is this because the control in the Detail
section does not have Running Sum turned on? I don't want it turned on,
because I want each record to show the total for that patient only, not the
running total. That is why I did it this way (with the sum function). Please
advise on if I am doing something wrong, or if this is a bug?

Thanks!

-Max

 

[Guest]

PLEASE DISREGARD this thread. Of COURSE, as the rule goes, after
troubleshooting this problem for probably 3 hours, I post the question to the
newsgroup, and about 3 minutes later figure out the solution. Turns out when
using the Sum function, you want to turn OFF Running Sum for that control
(set it to NO). Who woulda thought?

-Max