Hi i have created an ssrs report by using look up function
to retrieve data from second dataset
by using below expression
=IIF(IsNothing(Join(LookupSet(Fields!Fin_Indicator_Desc.Value,Fields!Fin_Indicator_Desc.Value,Code.FormattedString(Fields!Resource_Count.Value),"DataSet_ResourceCount"), Constants.VbCrLf)),0,
Join(LookupSet(Fields!Fin_Indicator_Desc.Value,Fields!Fin_Indicator_Desc.Value,Code.FormattedString(Fields!Resource_Count.Value),"DataSet_ResourceCount"), Constants.VbCrLf))
My Problem is iam getting deciaml points even i changed the textbox properties
to decimal values to zero and show values in thousands
3,345,622.00
45,677.22
like that iam getting
i don't want decimal points i want value only....i.e,. 3,345,622
can any one pls suggest me how to do this....