remove duplicates

[debson]

Hi I have a report where I am adding up totals of a group in the the report footer my code for this is

IF {BKGCNT.BKESIZ}= 20 and
{BKGCNT.BKETYP}=["DC","DH","FP","HC","HW","OT"]then
numbervar X:=X +{BKGDTL.BTEQTY}

My problem is that BKGDTL.BTEQTY has duplicates which are also added to the equation giving a false total.

I am new to crystal but is there a code I could use to either delete the duplicate or ensure it is not added.

Any help would be great... thankyou in advance.

[gjack72]

1 thing I can think of is select distinct records. On the toolbar under database select distinct records. That should help eliminate dups.
That is for CR 9

Hope that helps,

GJ

[debson]

Thankyou... I did try this but it didn't work unfortunately....
I will just keep trolling the web to see if I can find something..

cheers