Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Total - Current Balance Issue 1

Status
Not open for further replies.

Scamp123

IS-IT--Management
Jun 5, 2008
3
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
 
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
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top