Running Total - Current Balance Issue 1

[Scamp123]

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!


Ron

 

[IanWaterman]

Use date parameters and then suppress the display of the detail/groups that occur prior to the date selected.

This way it will still calculate your all time balances and only display data for the month in question.

You do realise that this report will get slowerand slower to run as time goes by.

Ian

 

[Scamp123]

Thanks, Ian! Yes, I realize it will get slower, but this particular contract isn't expected to last too much longer. Thanks again for your help!