Hi,
I want to check Null value in textbox field,if it 's Null,then print something.I tried Is Nothing but still getting the #ERROR display.
=IIF(Fields!NonTechHours.Value is Nothing,"Null",IIF(Right(Fields!NonTechHours.Value,InStr(Fields!NonTechHours.Value,"."))>0,Fields!NonTechHours.Value,Left(Fields!NonTechHours.Value,InStr(Fields!NonTechHours.Value,".")-1)))