dianemarie
Instructor
Hello, SQL Server 2005. I am trying to conditionally hide a table row. In the Visibility properties I am trying to say "if doctype = 6 or if there is no doctype for the row (no record) then hide the row, else show it". I have tried several ways to indicate "is null" to no avail. The expression below doesn't work either. Can anyone tell me where I'm going wrong here? It keeps telling me I have an error in the expression. Thanks much.
=iif(Fields!doctype.Value = 6, true,
iif (Fields!doctype.value = "", true,
false)
=iif(Fields!doctype.Value = 6, true,
iif (Fields!doctype.value = "", true,
false)