Hi Sam

Expanding on Andrew's question, if they are interested in adding the QOH for all locations, then the table to use is the ICW65 Items table and create a formula which sums up the five QOH buckets.

If they want the QOH for selected locations, you would be FAR better off doing the report in GridView. Doing it using Crystal Reports would require creating a sub-report, and this will tremedously slow down the performance of the report.

Steve