Please ignore previous mail a bit modification.

 

I am new to crystal report,

 

in my design i have 5 fields.

 

1.date  2.receivedfiles(int)3.issues(int) 4.openbalance(int)5.closing balance(int),sharevariable1(sharevalobc).

 

date, receivedfiles,issues,openbalance coming fromdatabase.

closing balance(cb):(openbalance +receivedfiles)-issues.

 

i have taken one shared variable for closing balance(cb).

 

Shared numberVar  sharevalobc:={@cb};

 

now my table values are:

 

date                receivedfiles   issues    closing balance(cb)  sharevalobc

01-Apr-2010   4                    0            24 (cb1)                     24(obc1)

02-Apr-2010   10                 9             25  (cb2)                   25(obc2) 

 

now what i want to do is :obc2=(cb1+receivedfiles )-issues  

 

but now it was taking corresponding row cb value(i.e cb2) instead of takig cb1.(ex:obc2=(cb2+receivedfiles )-issues )

 

i am using this formula:

 

Shared numberVar  sharevalobc:=({@cb}+{receivedfiles})-{issues};

 

how to do

 

if any body know please tell me.