I would like to total a field and group the total in a Crystal Report. my formula is : Sum ((@No_Of_Boxes)) : and this works fine, but if the report spans many Sales Orders, the total becomes the complete total for all orders. I need to subtotal on each order, the report page breaks on each new order.
Any ideas? I have been told that adding the field name I want it to break on or group by to the formula will work, but I am not sure of the syntax.

Cheers
Rob