Joined: 28 May 2013
Online Status: Offline
Posts: 93
Topic: Solved "Isnull" not working, but "not isnull" will Posted: 06 Jul 2015 at 6:51am
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.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 06 Jul 2015 at 8:35am
I have gotten in the habit (thanks to Ken Hamady) to check for empty strings instead of nulls (i.e., Len({field}) = 0). I also set the Default Values for Nulls in the formula editor.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum