Hi all,
I am using Crystal Reports 9. I designed a customer report that starts with a cash balance based on submitted POs. As work orders are invoiced, the report calculates parts and labor costs, deducts the costs from the original balance, shows the balance per invoice in a running total, and the total current balance after invoice deductions in the report footer. I am trying to figure out a way to run this by date range - how can I show the total balance on any given start date and start deducting from there? As it is, I submit this to our customer monthly, and the report includes all previous months from the beginning of service in order to give an accurate current balance. Any help would be appreciated!