Question Re: Sum the amount using name in Technology Q&A

Sum the amount using name

Former Member — Thu, 22 Mar 2018 06:06:17 GMT

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

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...

Re: Sum the amount using name

Former Member — Thu, 22 Mar 2018 16:57:00 GMT

Sort report by Name

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

Ian

Re: Sum the amount using name

vitaly_izmaylov — Thu, 22 Mar 2018 17:25:52 GMT

Group the records by Name field

Add Amount Summary to Group Footer

Suppress Details section

Re: Sum the amount using name

Former Member — Fri, 23 Mar 2018 11:32:15 GMT

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

Re: Sum the amount using name

Former Member — Mon, 26 Mar 2018 18:35:30 GMT

Thank you, Ian Waterman and Vitaly Izmaylov...

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

Re: Sum the amount using name

Former Member — Thu, 29 Mar 2018 13:59:26 GMT

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