FishKiller
IS-IT--Management
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?
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?