What else could it be. If it isnt Nul and its not a space.

[tcbc]

I made a formula to show my fields that are not Null or do not contain a space. But it is bringing up records that still appear NULL or contain a space. What other condition could exist in this field. If its not nul and its not a space what else could it be?
Thank you

 

[mbDutch]

Did you try trim({table.field})? This will remove any blank spaces the field may contain.

 

[jdemmi]

You can also create a formula to determine the length of the string. That will tell you if it is one or more spaces.

-- Jason
"It's Just Ones and Zeros

 

[dgillz]

Please post your formula. On any formula testing for nulls and other conditions, the null test MUST come first.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[tcbc]

(not isnull({group_detail.age_limit_code})or
{vip_service.code} in ["A_CLOSED", "A_EXIST_GOLD", "A_EXIST_HW", "A_EXIST_PAT", "A_NB_EXIST_PAT"])

Something is wrong with this formula because it is still bring up records that should be eliminated with the above formula where the Length of the age_limit _code is 0.00 and so therefore should not be coming up

 

[lbass]

Sounds like you might want to use "and" instead of "or":

not isnull({group_detail.age_limit_code}) and
trim({group_detail.age_limit_code}) <> "" and
{vip_service.code} in ["A_CLOSED", "A_EXIST_GOLD", "A_EXIST_HW", "A_EXIST_PAT", "A_NB_EXIST_PAT"]

If this is not your entire statement, you should show the whole thing.

-LB

 

[tcbc]

I needed to use OR because I wanted to show either this condition or that. Whatever the problem was it had to do with my Null statement. I went about a different way. I made a formula to identify string length. I then supresses that column but used selection expert to pick out only those rows where string length was greater than zero OR my other condition that I needed to pull as well.

This worked