The keyword 'then' is missing

[NonTech01]

Hi,

I'm having a problem adding supression code against a section in a pre-existing crystal report template. Basically, I want to supress the appearance of some text if one of two conditions are met... here is the code I have so far:

if {Property.Price_Qualification} <> 'PRICE REDUCTION' Or {Property.Price_Qualification} is not NULL then
true
else
false

When running this code, the following error appears:
"The keyword 'then' is missing". I'm not a programmer, so I'm probably missing something obvious out, but any help is greatly appreciated. Hopefully it's self-explanatory what I'm trying to do, and a case of the code not being correct.

Thanks!

 

[Madawc]

Try

not isnull({Property.Price_Qualification})
and
{Property.Price_Qualification} <> 'PRICE REDUCTION'

You used the wrong syntax for IsNull, that caused the error. But it is also pointless having it after the first test, Crystal stops when a test hits a null, even if null is allowed for later.

You don't need to say 'true' or 'false', the formula field will have one of those values, assuming null is tested for. You could also just say @yourtest, which gets the same result as @yourtest=true.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[NonTech01]

Brilliant - works perfectly. Thanks for that.

 

[NonTech01]

Hi,

Thanks for your help yesterday. There does still appear to be a problem when running that code though - the 'Price Reduction' image that is controlled by this code will appear - when I run the template - even if the field in question is blank (i.e. null). I would only like that image to appear on the template if the field is displayed 'Price Reduction'. Do you know how I can account for this please?

Thanks.

 

[lbass]

isnull({Property.Price_Qualification}) or
trim({Property.Price_Qualification}) = "" or{Property.Price_Qualification} <> 'PRICE REDUCTION'

I think you described what you wanted incorrectly in your original post. It now sounds like you want the object to suppress if it is blank or null or there is text other than 'price reduction'.

-LB