How to filter rows with null values in any of its columns in SSRS

Question

I want to filter out the output without rows containing null values or blank columns. I am using SQL Server 2012 there is no option named 'Blank' as in SS2005 where I can filter the rows. I also tried following expression but it gives me error or not showing correct output

=IsNothing(Fields!ABC.Value)!= True 
=Fields!ABC.Value = ''

Please suggest the solution.

Answer 1

• Pull up the tablix or group properties
• Switch to "Filters"
• Add a new filter

• Set the expression to:

  =IsNothing(Fields!YourFieldHere.Value)

• Set the type to "Boolean" (see screenshot below) otherwise you'll get a "cannot compare data of types boolean and string" error.

• Set the value to false

This works for filtering both rows and groups.