crystal reports text input from user

TomBalla
TomBalla used Ask the Experts™
on
Can I setup a way for the user to type in text and it looks at a field, if their text is found then it outputs any instance of that text.

For instance:  They type in tops and it looks at porOrder.stockcode and returns

Stops
55 tops
tops 34
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Yes.  You can setup a report filter based on a parameter.

Create a parameter
  Name - StockCode
   Data type - string
   Static

In the record selection
  Click REPORT --> SELECTION FORMULAS --> RECORDS
"*" & {?StockCode} & "*" LIKE {porOrder.stockcode}

mlmcc
I think you got the test backwards.

{porOrder.stockcode} LIKE "*" & {?StockCode} & "*"


 James
FWIW, if your db is case sensitive and you need the test to ignore the case, like you want "tops" to match things like "STOPS" and "55 Tops", you could change the test to something like:

UpperCase ({porOrder.stockcode}) LIKE "*" & UpperCase ({?StockCode}) & "*"


 James

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial