Removing duplicate entries - repeating transaction

[omega1983]

Using CR8.5, I am showing a pledge and payment transaction as follows:
date amount transaction
01/15/05 25 pledge
01/25/05 5 payment
It works okay unless the person makes multiple payments on the same pledge. If that occurs here is what happens:
01/15/05 25 pledge
01/25/05 5 payment
01/15/05 25 pledge (repeats)
01/28/05 5 payment
Essentially the pledge transaction repeats itself every time a new payment is made. I tried the select disinct records option but it does not work. All data rests on the detail line. There is one group (effective-date -A) In terms of linking I have a gift.table linking the gifttimekey to another gift.tables gift.pledgekey. Any ideas on how to eliminate the duplicates since this affects the counting of pledges and payments. The only problem is the pledges.

 

[synapsevampire]

Select distinct works fine, I think that if you pay closer attention to the entire rowset you'll find differences.

This is generally termed row inflation, try reading up on that as well.

Rather than describing what you don't want, please post the data you're getting (you did that), and what you want Crystal to output.

-k