Skip to Content
0
Former Member
Apr 16, 2010 at 04:20 PM

How can I run a report by capturing a specific word or phrase

16 Views

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.