Multiple Records Sum Field Creates Problem

[earljgray]

Here's the issue:
Report is based on a stored procedure that will return rows which look like this:
ACCT NUMBER Field1 Field2 Field3 Dec Susp
30393359 Group1 Group2 Group3 1 1
30393359 Group1 Group2 Group3 1 0
30393359 Group1 Group2 Group3 1 1
30393359 Group1 Group2 Group3 1 1
30393359 Group1 Group2 Group3 1 1
30393359 Group1 Group2 Group3 1 1

Because of a one to many relationship, there are numerous examples of the above - multiple records for 1 account. What I need to do is generate the sum of the field DEC and the sum of the field SUSP over Group3, Group2, and Group1 as wll as a grand total.

The Grouping looks like this
Group 1 (3 identities in this grouping)
Group 2 (18 identities)
Group 3 (variable identities)
Group 4 (Account Number)

I have tried versions of running total; three formula counters, etc. I'm not seeming to be able to properly collect the numbers - in the example above, the count at the ACCOUNT level should be 1 DEC 1 SUSP; at the Group3 level, it should be the sum of all the Accounts in that group, and so on...

I've tried a bunch of combinations; scraped the web (a lot close, but no cigar) tried methods of doing the counts in the Stored Proc (couldn't -too many barriers in code).

Any suggestions????



Crystal Reports Design/training/Consultation
earljgray@gmail.com

 

[Charliy]

Set up a Running Total to sum DEC, check Evaluate on Change of Field, and select ACCT_NUMBER

 

[earljgray]

Thanks!

Not used to Running Totals - being a VBA and programming type (go to formulae first to solve ALL the world's problems!)

Anyway, did a quick test, looks good! Need to set up a couple more and go from there!!!!


Thanks again!!!



Crystal Reports Design/training/Consultation
earljgray@gmail.com