Formula to exclude empty fields in select expert

[jercisneros]

How do I make a formula to exclude null or empty fields in the select expert portion of the report. What I want to do is get the information based on {CUST_ADDR.STATE}, but sometimes this field is empty and want to exclude this on my report.

Any help would be appreciated.

 

[goranm]

Hi !

Try this in your Record selection:

(
not IsNull({CUST_ADDR.STATE})
OR {CUST_ADDR.STATE} = ''
)

/Goran

 

[adamsjw2]

Is the field truly "NULL" or is it blank? There is a difference and how CR will handle it. Goran's suggestion will work and you can also do the opposite in a Details Suppression formula but the opposite logic:
IsNull({CUST_ADDR.STATE})

 

[synapsevampire]

Gorans eliminates the rows from hitting the report, which means it's faster because the filter is applied at the database.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com