Search code examples
c#crystal-reportsreportdistinct

Crystal Report: How do you add distinct values?

For example I have:

Supplier GroupName

ID name value

01 chair 5,000

02 table 3,000

03 mantle 4,000

01 cabinet 5,000

02 closet 3,000

The total result should be 12,000 since the ID was repeated.

another example is this: https://i.sstatic.net/Yp2Qr.jpg

the total for cash should be 75,000 based on the SOS#

Solution

  • Use a Running Total which sums value, but only evaluates on change of ID and doesn't reset.