I have created a report and in that report inserted a text box called 'Variance".

Variance will display data of type decimal.

Is there a data type which supports both numbers and text such that, if variance = 0, it should display, ‘N/A’ ?


in report use an expression in a textbox: =iif(Fields!Variance.Value=0,“N/A”,Fields!Variance.Value)


Thank you for your response.

I tried using the following expression(=iif(Fields!Variance.Value=0,“N/A”,Fields!Variance.Value)) in the text-box, but i i get an error saying ," A value or expression was expected.

Is it possible to use an if statement in a text-box expression ?