Hi Guys,

I have one table order
 with two colums orderid and orderamount

orderid and orderamount
1000         $10
1000         $20
2000         $30
3000         $40
4000         $50
4000         $60

I want to display records in crystal report
OrderId       Sum of order amount
1000           $30
2000           $30
3000           $40
4000          $110

I have create formula for orderamount sum(orderamount,OrderId)
this crystal report group by orderId.
but i am not geting actual answer

Thanks in advance for help

Lancecoder