Crystal Reports Suppressed
Hi Todd,
If you are suppressing the duplicate records, then you can use the same
suppression formula for a running total. When you create a running total,
choose the field that you would like to sum and choose to perform the total
based on a formula. This is the inverse of the formula you used to suppress
the unwanted records:
Suppression formula - Field1 = Previous(Field1)
Evaluation Formula - Field1 <> Previous(Field1)
Your formulas may have to be a little more sophisticated in order to
accomplish your goals, but, this is the principle.
Bob Holmes
Quote:
> Hello Everyone,
> My question is, I am desigining a report to display Accounts, and all of
the
> purchases on these accounts. My problem is when I am showing my accounts
> along the amounts in these accounts I am getting duplicate ammounts
because
> there is multiple purchases on these accounts. So when I go to do a
subtotal
> of the account amounts I am getting large numbers because it is adding up
> the duplicate ammounts for that account. I was wondering if there is a way
> to add up the unique account amounts without adding up the duplicate
ones.
> Thanks, Tood
> If someone could reply to this asap, it would be greatly appricated.
