Like and Like?

Printed From: Crystal Reports Book — Forum Name: Technical Questions

Posted By: jgarner — 18 Jan 2017 at 7:48am

Windows 7 / CR 11.5.3.417
Here's an example of what's in the formula editor:
{WORKORDER.DESCRIPTION} like ["*grille*"]

How do I add a variable so that only fields with both 'grille' and 'graffiti' show up?

Thanks in advance.

Posted By: kevlray — 18 Jan 2017 at 7:53am

So I think you will need something like this

{WORKORDER.DESCRIPTION} like ["*grille*"]
and {WORKORDER.DESCRIPTION} like ["*graffiti*"]

Posted By: jgarner — 18 Jan 2017 at 7:59am

Yes, that's exactly what I needed. I tried using something similar to this but I had too many parenthesis.

Thanks for your suggestion!

Posted By: Daisy22 — 23 Jan 2017 at 5:27pm

I really liked it .

Posted By: bob45 — 16 Sep 2019 at 12:30am

Thank you, I was searching for the similar stuff