Crystal Reports v6 design problem

I am trying to sumarize a formula field in a crystal report (v 6). I have a table which contains order lines. This table specifies the order number, product id, and the quantity ordered. I have a second table which contains delivery info which is a child of the order line table. This table specifies the order number, product id, and quantity delivered, and there can be multiple delivery line corresponding to a single order line.

My report is group first by product id and then by order number.

I calculate the difference between the amount ordered and the amount delivered on the order number level. I have setup a formula called @open which has this format:

 {PO_DETAIL.QTY} - Sum ({PO_RECV_DETAIL.QTY}, {PO_DETAIL.PO_NO})

The object of creating this formula is that I need the sum of these values grouped at the product ID level.

So I try to set up a formula which gives this sum, but I cannot do it. I get an error message saying that this field cannot be summarized.

Does anyone know how I should go about getting this sum on the Product ID level?

Thanks for the help
Neal Gran
Anisoft Corp.
neal_at_anisoft.com

PS. Are there any other newsgroups which would be appropriate for Crystal Reports questions? Received on Tue Dec 30 1997 - 00:00:00 CST