>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

You should create a variable in the report designer(Reports -> Variables) let say MBALANCE
initial value : party.obal
Value to store: debit-credit
calculate: Sum

The source in the balance column should be MBALANCE

Hope it helps