You meant percent signs in the user tool, right? :-) ‘Customer Name’ LIKE "%ABC%"
On Thu, May 16, 2013 at 9:17 AM, Grooms, Frederick W < [email protected]> wrote: > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
