I'm trying to create a Crystal Report to run against my HEAT Call Logging system.
What I am trying to do is create a formula that will return only call tickets that have a specific word or phrase in a certain field.
For example, I would like the formula to find all call tickets with the words Work Order in the Ticket Title.
The Formula I have come up with is as follows...
({CallLog.TicketTitle} like "?ork ?rder" or
{CallLog.TicketTitle} like "?ORK ?RDER" or
{CallLog.TicketTitle} like "WO *" or
{CallLog.TicketTitle} like "wo *")
I tried to capture other possible ways that Work Order my have been typed in.
The results I get back include everything I'm looking for, however, it also includes things I'm not looking for such as 'two' because my like statement above {CallLog.TicketTitle} like "wo *".
Any ideas on how I can get only the word or words I am wanting in my report would be greatly appreciated.
Thanks.