Creating Formula Fiels In Crystal Report

[umeshpotdar]

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+Debi t
& Cur balance=Curbala nce+Debit

& if id =1 then
Curbalance - Debit
& Cur balance=Curbala nce - Debit

so plz tell me how i create this CurBalance Field

Thanks In advance

[Shashi Sadasivan]

What you are looking for is a running total field.

Unfortunately i havent tried this, you may have to search online for any examples