When the height field is filled out the expression below works. However, when the field is left blank it returns an error.
Any help would be awesome!
This is the expression I am using in my report:
=IIF(Fields!height.Value= "", "", IIF(GetChar(Fields!height.Value, 2) = "0",Replace(Fields!height.Value, GetChar(Fields!height.Value, 2), "'") & Chr(34) & "/", Left(Fields!height.Value,1) & "'" & Right(Fields!height.Value,2) & Chr(34) & "/"))
