Formula Help

[Sonya Dhand]

Using Crystal Reports 10 - How do I say that if a {fieldname} includes (not equal to) "xyz" then true else false

 

[Kafrin]

I don't know what Crystal Reports 10 is (I'm still fairly new here), but it seems like you want something like:

Iif([Fieldname] Like "*xyz*", True, False)

For "not included" you can either use: Iif(Not [Fieldname] Like ...
or you can just swap over the True and False, so if it includes xyz then false, otherwise true.

 

[Rabbie]

Using Crystal Reports 10 - How do I say that if a {fieldname} includes (not equal to) "xyz" then true else false

This is the Access reports thread. You will have a better chance of getting help if you post in the Chrystal Reports thread.

 

[boblarson]

Using Crystal Reports 10 - How do I say that if a {fieldname} includes (not equal to) "xyz" then true else false

Kafrin was close, but the CR syntax should be (if I remember correctly):

If {tableName}.{FieldName} Like "*xyz*" Then True
Else
False

 

[boblarson]

This is the Access reports thread. You will have a better chance of getting help if you post in the Chrystal Reports thread.

And that is a good point as well.