>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
Hi Saifuddin,
Aldough it might be possible to achieve above statement report
applying some frx tips & tricks, on the long run u will be better of
with preprocessing data into temporary cursor suitable for output via frx.
In that tmp cursor this running balance can be PRE-calculated so
all you need to do in frx - is show value.
Since this looks like an ordinary account statement, that means that you might also need to apply some criteria from/to entered by user and then based on their input produce apropriate statement(s).
Common scenario for this is;
FORM is accepting user criteria, then calls procedure processing original table, and inserting results into tmp cursor suitable for reporting.
After that results are easily reported using frx.
Rgds++