Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

tcbc

Technical User
Feb 7, 2009
33
US
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
 
Did you try trim({table.field})? This will remove any blank spaces the field may contain.
 
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
 
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:
 
(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
 
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

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top