SUM error while surpressing duplicates 1

[FishKiller]

I am running CR9 and tring to get use simple sum from SQL2000 returned values. Some of the customers have duplicate ID's and duplicate product id's so I am surpressing the duplicates by using a formula in the Details section expert:



if not on firstrecord then
{vr.id}=previous({vr.id}) and {vr.proid} = previous({vr.proid})

*I also enabled the surpress checkbox under Section Expert > Details

This returns only one record however, when I use running totals it counts these values how do I surpress the duplicates and not have them count in the sum?

 

[lbass]

In the evaluation section of your running total, choose "use a formula" and then enter:

on firstrecord or
(
{vr.id} <> previous({vr.id}) and
{vr.proid} <> previous({vr.proid})
)

-LB

 

[FishKiller]

Sorry for the delay. Had an emergency. This worked perfectly sometimes thinking backwards helps.