Crystal report is null

I have an issue where my report isn't pulling data if a field is not null. I need my formula to pull data if the field is not equal to "SAP" or is not null. Any ideas? Thanks ahead of time.

Edited by DBlank - 27 Sep 2012 at 11:51am

you may want to also check if a value is ""

After reading the post title I think you meant to ask how to get <>'SAP' or null.
Either change the option in the formula editor to 'use default values for null'

Or use
Isnull(field) or field<>'SAP'

Ok guys. I'm losing my mind. I appreciate your previous replies. I'm able to get the data now based on your ideas, but depending upon where I place IsNull() or <> "SAP", other portions of my formula is ignored. Here's my complete formula. Based on this formula, it will pull employees even if my formula says otherwise. If I move the isnull lines around, different results occur.

Edited by db3712 - 28 Sep 2012 at 6:53am

Nulls are handled in an unusual way in crystal.
You must always put the isnull statement as the first instance of referencing that field.
If it is not put first and the formula hits a null it will stop evaluating the formula.
It is often easier to use the option in the formula editor to force it to evaluate nulls as the default value.
You shouldbe able to fix your statement by putting parenthesis around your two or statements with the isnull parts.