thank you for reply and advice .

>>hi all,
>>
>>i have table as..
>>

>>empno telno name val 
>>1     123       a     10
>>1     223      a     15.30
>>2     432       b     30
>>2     567       b     10.50
>>.
>>.
>>

>>**************************i need result as
>>

>>
>>       1     123       a     10
>>             223       a     15.30
>>tot                         25.30
>>       2     432       b     30
>>             567       b     10.50
>>tot                          40.50
>>
>>

>
>Assuming this is for a report, set up a group in the report on empno, and in the group footer, put an expression that sums val.
>
>Tamar