I am wanting to restrict my data based on simple logic.  Only show me data  if {table.field} is empty.  So I tired using the following record selection formula

isnull({table.field})


The field is a string.  When I refresh my data i return zero records.  If I use the opposite  not isnull({table.filed})  then the report returns records. 

I have tried using default values and exceptions for null values with no luck. 




Edited by bremen - 07 Jul 2015 at 12:31am

where would I put that?

So how would I use either of these functions to limit the records returned by my report? 

Now I got cha. 

Thank you very much for the help.