I am trying to design a Report (.FRX) using Table operationcash.DBF. The Table contains Daily Datewise CREDIT AND DEBIT Amount.
The Daily Closing Balance is the difference between CREDIT and DEBIT.
The CLosing balance of Day one becomes the opeing of the Next day and the next day closing is calculated based on the Opening Plus Credit- Debit.
I have tried to make a report but cant figure out that how to calculate Daily OB (DOB) and Daily CB (DCB). Can any one help me in formatiing my report.
Here is the link to my .FRX and DBF file
https://www.dropbox.com/s/2wesxey2d5x0vl9/Cashbook.zipKindly Help
Harsh