Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using the WIld Card symbol in Crystal

Status
Not open for further replies.

renee35

MIS
Jan 30, 2007
199
Is there a way to set a parameter and only type in part of the word? Below is what I currently have:

{?Recruiter} = "All" or {Command.FullName} like {?Recruiter}

I am entering Recruiter as: 'Amb%'

I am using like because one might not know the full/correct spelling of the recruiter name so I want to allow them to type part of the name? This returns back no data, can I not use like in Crystal?

Thanks!!

Thanks a bunch!!

-T
 
Here's how I do it...

{?Recruiter} = "All" or {Command.FullName} like
('*'+{?Recruiter}+'*')

Then the user can enter a whole string or part of a string and does not need to include the %.

Optionally you can leave of the leading * if you only want to allow for wilcards at the end

-- Jason
"It's Just Ones and Zeros
 
Thanks a million; that works perfectly!!

Thanks a bunch!!

-T
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top