User Support Forum

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

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

The Print When for field 1 would be:
Where needle is the string you are searching for and haystack is field 2.

Easy! Thank you.