Hi Samuel:

You're very nimble with Crystal Reports. How about modifying the existing report to simplify it - remove the portions you don't want? As long as you feel the calculations are accurate, you can let it do that work for you.

Or if you want the challenge of calculating the figures with a GridView report, I would start with "I/C Transaction History". It has both the inventory shipment and receipt transactions in one table.
_________________________
Bruce Gardner
ARX Business Solutions Inc.