I would like assistance on the following Crystal report Issue:
I am creating a Inventory variance report with the following field:
1. Opening Bal
2. Purchases
3. Requisitions
4. Closing Bal
5. Physical Closing Bal
6. Variance
The report should sum total quantity for a given item over a period that a user will enter as report parameters (e.g one month) and display as below:
Opening Bal + Purchases - Requisitions-Closing Bal =( Closing Bal)-Physical Closing Bal=Variance
10 20 5 5 20 18 2

Your input will be appreciated.