In my SSRS reports one of the fields is using this expression, where the field is a number field. I want to see blank field if the value is 0
.
=IIf(Fields!PERIOD02_VALUE.Value <> 0,Fields!PERIOD02_VALUE.Value ,"")
the Excel exported version is having this field considered as text not number.
Is there any other way to do this from SSRS side?
Best Answer
I had this problem. Some cells would be text and others numbers - all with the same formatting string. The resolution is to multiply your cells expression by 1.000 (1 doesn't work!) - this forces SSRS to format the cell as a number. eg; (your expression here) * 1.000