Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to calculate balance in balance column
Message
From
14/12/2004 10:12:25
 
 
To
14/12/2004 09:02:56
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP
Network:
Novell 4.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00969067
Message ID:
00969102
Views:
9
I would use a report variable. Check it out in the help file

Peter


>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
Peter Cortiel
Previous
Reply
Map
View

Click here to load this message in the networking platform