null values

[steverdan]

How can I pull data that is not null values?

[abhilash_kumar · Accepted solution]

Hi Steve,

If you're reporting directly against Tables/Views, you can go to the Report Menu > Selection Formulas > Record and use this code:

(Not(IsNull({database_field}))

-Abhilash

[Former Member]

Hello Steve,

In addition to what Abhilash suggested I would recommend to use

(Not(IsNull({database_field})) or {database_field}<>""

In Report record Selection.

Regards

Niraj