I Got error when i use FormateNumber(Field,2) in RDLC.
Note: I am using values at runtime, the field may be string sometime
Ex:
=Switch(
First(Fields!Col1.Value, "FieldType")="String",Fields!Col1.Value,
First(Fields!Col1.Value, "FieldType")="Currency",(Parameters!CurrencySymbol.Value & FormatNumber(Fields!Col1.Value,2)),
First(Fields!Col1.Value, "FieldType")="Number",Fields!Col1.Value
)
In this case it shows error Only When Fields!Col1.Value = String