Friday, September 30, 2005

Filter table on NULL value in Reporting Services

I was trying to find the correct filter statement for a NULL value in Reporting Services but I always seemed to fail.

So what's the trick?

Filter: =IsNothing(Fields!YourField.Value)
Operator: =
Value: =True

Notice the = before True as this really makes a difference!

2 comments:

Anonymous said...

Filter: =IsNothing(Fields!YourField.Value)
Operator: !=
Value: =(1=1) (para el, true)

Anonymous said...

THANK YOU!!!