Tutorial by Examples

This line of code demonstrate how to check if a specific field is NULL or has blank value =IIF(IsNothing(Fields!UserEmail.Value) OR Fields!UserEmail.Value = "", "Empty", "Not Empty") This line of code checks if the field is NULL IsNothing(Fields!UserEmail.Value) ...

To get a shorter version of the Null or Empty check, use an "= Nothing" comparison. Iif(Fields!UserEmail.Value = Nothing, "Null or Empty", "Not Null or Empty") The "= Nothing" will check simultaneously against Null or Empty, giving a more compact expressio...