In the user tool the search would be ‘Customer Name’ LIKE "*ABC*"
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Clemence Lau Sent: Thursday, May 16, 2013 9:16 AM To: [email protected] Subject: Re: {Remedy ARS} Re: Crystal Report LIKE search not working in AR User ** Hi paul I have tried {?Customer Name} LIKE *ABC* And the result is the same. If i do the search in crystal report, i can get the result. But if i run the report using ar user (with crystal report ODBC), i get zero records -----Original Message----- On 2013/5/16 下午9:30, "Nguyen, Paul" wrote: ** Please use LIKE instead of = for crystal search -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of clemence Sent: Thursday, May 16, 2013 01:16 To: [email protected] Subject: Crystal Report LIKE search not working in AR User ** HI I am trying to create a crystal report serach criteria using LIKE. using Crystal Report, the search criteria is {HPD_HelpDesk.Company Name} LIKE {?Customer Name} and if i put {?Customer Name} = *ABC*, crystal will give me all ticket whose company name includes ANC. but if i run the report in AR user, it give 0 result. anyone can advise how i can use a LIKE search in AR user ? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
