I want to generate a report. I got a table for it. The Table contains the following fields:

1. Reference
2. Date
3. Description
4. Debit
5. Credit

The Report should be as follows:

Code: CA001 ABC International Ltd.
P.O. Box 1295, Dubai, UAE
___________________________________________________________________________
Date----------Reference--------Description---------Debit--------Credit--------Balance
___________________________________________________________________________

01/01/2004--Opening Balance--------------------------------------------------5,000 DR
10/01/2004--CR101244-------Received Cash-----------------2,000------3,000 DR
15/01/2004--SI349072-------Sales Invoice-------1,500--------------------4,500 DR
17/01/2004--BR320944-------Paid By Chq.No.---------------4,000--------500 DR

**************************************************************************

I just wanted to know, how can I calculate the balance column. Please note that the Opening balance comes from Party master file (Party.dbf) and the field name is obal.

Please help !

Thanks - Saif