Doing a report where I have duplicate records, I have managed to suppress these using the following
{INVOICE.ORDER_NUMBER}=previous({INVOICE.ORDER_NUMBER})
But I am also doing a summary on cost and the "Sum of INVOICE.CARR_NET" appears to still be pulling the costs on duplicate records that have been suppressed.

I know this must be to do with the way the tables are linked on the database because what we have is an order going out with 3 lines linked to the order number with 1 shipping cost, but the shipping cost is pulling in 3 times on the report once for each line on the order, I can suppress the order number to only show once, but the summary (sum) still adds the cost associated with the missing lines.

Hope this makes sense.
I tried a few of the other topics which helped me suppress the duplicate records but cant find an answer that will help me ignore the associated costs.

Any help appreciated
Thanks
Rob

as a general rule in crystal do not confuse getting data to display a particlular way (unduplicated) and actually altering your data set. The sppressed data is still part of the report and must be accounted for in any calculations.