Hi Friends
I want to creae formula field in crystal report
i created one report such as
----------------------------------------------------------------------------------------------------------
ID-1 Opening Amount----- 5000
--------------------------------------------------------------------------------------------------------
ID Debit Credit CurBalance
---------------------------------------------------------------------------------------------------------
0 10000 0 15000
1 0 8000 7000
1 0 5000 2000
0 15000 0 17000
----------------------------------------------------------------------------------------------------------
ID-2 Opening Amount----- 15000
--------------------------------------------------------------------------------------------------------
ID Debit Credit CurBalance
---------------------------------------------------------------------------------------------------------
0 1000 0 16000
1 0 8000 8000
1 0 5000 3000
0 15000 0 18000
All Fields are comes from the table except CurBalance
Now From above informarion u have got the idea abt how curbalance is calculated.
----
at the begining curbalance=5000
when debit it will become 5000+ 10000=15000
that means
If ID=0 then
Curbalance+Debit
& Cur balance=Curbalance+Debit
& if id =1 then
Curbalance - Debit
& Cur balance=Curbalance - Debit
so plz tell me how i create this CurBalance Field
Thanks In advance