SSRS Visibility Option

[bwood2020]

Hi all, I am trying to hide a table in my report if all the text values are null. I am running the expression =iif(IsNothing(Fields!LoanType.Value), true, false) but this seems to hide the table no matter what. I have also tried the Len function but this doesn't work either. The Table in the database is set to allow nulls for this attribute. Here is an example of two tables I have in the report. Example dataset1: Conventional FHA VA null Expression used:=iif(IsNothing(Fields!LoanType.Value), true, false) Example Dataset2: null Expression used:=iif(IsNothing(Fields!Assumable.Value), true, false) When I apply the above functions both tables are hidden. However, the table holding example datset1 shouldn't be hidden and example dataset2 should be.

[Edbert P]

Are you using SQL Reporting Services by any chance? Use IsDBNull function instead of IsNothing. The null value returned by database is not the same as NOTHING or NULL.

"A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin Edbert Sydney, Australia