Hi Andre,

It is possible to Set Sort Order and Summarize by more than one column. Perhaps that might be useful for getting Totals/Averages on the lines you want (ie by customer or by document). If you summarize by customer and document number and set the Summary method to Average for all fields that are 'header' information like 'Total Order/Dollar Value', you are guaranteed to get the exact amount for the document on the 'summary by document' sub-total row. You would get a different value for the customer that has multiple orders, as you indicated earlier.

To do this, first make sure your View is not summarized. Then multi-select columns (say Customer and Document #) and then choose Set Sort Order. Sorting will be done from left-to-right of sorted columns, so the left-most column chosen to sort by will be the primary sort.

In following this thread where you desire particular information in the Sub-total lines, it may be that Crystal is the better reporting tool in some cases that GridView. When you start wanting to manipulate the sub-total or grand total lines, GridView isn't the best because I believe it's best usage is to be detail-driven and provide simpler summary operations.