Parameter field for searching db on partial Name?

[deborahyr]

I'm trying to create a parameter that will allow the user to enter part of last name to do a search using a Crystal Report XI. How can I do this?

 

[Turkbear]

Hi,
Use the wild card for your database concatenated to the parameter entered:

{Table.LastName} LIKE "*" + {?ParameterEntered} + "*"

Some databases use % instead of * but either should work in Crystal.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[deborahyr]

Hmmm, I still seem to be missing something - this is not working or bringing back any data. Does the field itself have to be in certain type? My field is a String. This is what my sql looks like when entering stel in parameter field in running report...

WHERE "RollUpCandidates"."CandidateLastName"=N'stel'

 

[lbass]

I think you'd better show us your record selection formula by copying and pasting it into the thread.

-LB

 

[deborahyr]

Ah ha! Got it - my record selection was off. Thank you so much!!!!!