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

[Former Member]

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.

[Former Member · Accepted solution]

You may need to add a space before the WO:

" " + {CallLog.TicketTitle} like " WO *" 

HTH,

Carl

[Former Member · Accepted solution]

This seemed to take care of it. Can I ask, what does the " " + in front of {CallLog.TicketTitle} like " WO *" do?

[Former Member · Accepted solution]

Checking to see if it is like " WO " to prevent "two " from matching would mean that if the description started with "WO " it would not match. Adding a space at the start of the description fixes this issue. Does that clarify it?

HTH,

Carl

[Former Member · Accepted solution]

I understand the space in front of " WO", but what does the " " + at the beginning used for?

[Former Member · Accepted solution]

if the description started with "WO " it would not match. Adding a space at the start of the description [with " " +] fixes this issue.

HTH,

Carl

Edited by: Carl Sopchak on Apr 21, 2010 12:44 PM - fixed brackets in edited quote

[Former Member · Accepted solution]

Much clearer, thanks.

[Former Member]

like "work order"

should work fine,

I do not think CR looks at the case