Crystal Reports Suppressed
Author Message
Crystal Reports Suppressed

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.

Sat, 06 Mar 2004 00:48:10 GMT
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.

Sat, 06 Mar 2004 01:43:09 GMT
Crystal Reports Suppressed
Quote:

>Date: 9/17/01 11:48 AM Central Daylight Time

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

If you are doing the addition in a Running Total you can use a formula in the
Running Total that will only add when:
{table.account} <> Previous({table.account})

Sat, 06 Mar 2004 03:46:59 GMT

 Page 1 of 1 [ 3 post ]

Relevant Pages