Crystal Reports Running Totals problem.

265 Views

I am designing a report in which a Running Balance column adds itself to Debit and subtracts the answer from Credit column on every row. Here in this example I have started calculating from 1st of January. In this case, my Running Balance column will have zero.

Now my client wants to have a look at records from 17 January to the end. In that case, my cumulative balance will NOT be zero at first but instead it will calculate cumulative balance for all the dates before 17 January, and present it as the starting balance for 17th of January. I am stuck at this point. How to add all the record before 17th of January and show their Total in a single row. I will be grateful for any help. I am attaching a tabular description below.

Sr No. Date Credit Debit Running Balance 1 01-01-12 0 10000 10000 2 01-01-12 5000 0 5000 3 01-01-12 0 10000 25000 4 01-01-12 2500 5000 28500 5 05-01-12 2000 10000 36500 6 05-01-12 5000 0 31500 7 17-01-12 2000 4000 33500 8 17-01-12 1000 0 32500 9 18-01-12 0 5000 37500 10 19-01-12 0 5000 42500 Cumulative 42500