Hi,
I have a account ledger report. the report is grouped by account number..
For each account number i have derived the opening balance...
Again under the group of the account number there are detail entries of DR and CR amounts..
Now i have to derive the Closing balance along with opening balance with recursively adding DR and subtracting CR..
If Opening Balance is 100
DR CR
10 20
20 10
Closing Balance Will Be
100+10-20 = 90
90+20-10 = 100
How can i do this in Crystal reports....
can i use the formula field, but how can i write a block of code in formula field.
Thanks In Advance...