Thanks for the reply ,

problem has moved a bit forward , But strucked over a little change

=iif(Cint(ReportItems!Sales38.Value)>99999,ReportItems!Sales38.Value,FormatNumber(CDbl(ReportItems!Sales38.Value),"N2"))

this is the expression i have written. with help of this am getting values with decimal values

like 76585.23 for some rows 89096.2

Problem is: i need to get 2 decimal points after " . "

can anybody suggest something.

Thanks in advance,

Niharika