Print when string not found

[sherry]

I want to create an expression in a custom report field to do this...

Print Field1 when a certain text string is NOT found in Field2.

I can't figure out how to do it! Can anybody help?

Thanks so much.
Sherry

[Zorak]

Here is something that should work in the "Print When" for you

The Print When for field 1 would be:

Code: Select all

not "needle" $ haystack

Where needle is the string you are searching for and haystack is field 2.

[sherry]

Easy! Thank you.