Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help On report for Displaying Daily Opening Balance
Message
From
05/06/2013 07:02:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Help On report for Displaying Daily Opening Balance
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01575683
Message ID:
01575683
Views:
149
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.zip

Kindly Help
Harsh
Reply
Map
View

Click here to load this message in the networking platform