SUM DISTINCT RECORD IN CRYSTAL 9.0

[BHAT100]

server :SQL SERVER 2000
CRYSTAL 9.0
I have linked two inventory table of great plains
( IV30300). This table has purchases qty (lump sum), Which I have put in detail column. the other table (iv30301) have sales against these purchases that have multiple records against one record.

What I want to do, I want to place sum of all the sales records of iv30301 table against each purchase reciept.


any idea would great help?
-b

 

[lbass]

You could insert a group on purchase receipt, drag the purchases quantity into the group header, insert a sum on {table.sales} and drag that into the group header and then suppress the detail section.

-LB