Sum the amount using name

[Former Member]

Though selecting distinct records in Crystal Report because of other fields in the report along with the following two, I am getting values for the two fields as mentioned below

Name Amount

Raja 200

Raja 250

Sekaran 500

Sekaran 500

I tried to insert sum through regular Crystal formula I am getting the following result:

1450

But I need Both values as separate like

Raja 450

Sekaran 1000

Thank you in advance...

[vitaly_izmaylov · Accepted solution]

Group the records by Name field

Add Amount Summary to Group Footer

Suppress Details section

[Former Member · Accepted solution]

I Using this method and I got the result in next to details part. But I need the same result in Page footer. I need help

[Former Member]

Thank you, Ian Waterman and Vitaly Izmaylov...

I'm using both methods to get a result I need...

[Former Member]

Hi Lan and Vitaly,

I have tried those methods that you told me.

I have sort with ID and sum amount it results as like:

Raja 1450

Sekaran 1450

Thank you in advance

[Former Member]

Sort report by Name

Use a running total to sum amount field and resets on change of name field.

Ian