How to create a fuser input field

[lwalker]

I am a new user of Crystal Reports, but an experienced user of SQL. I need to know if anyone knows if it is possible to create a user input field where the user could paste a list of items that they want queried against a column in a table and have the query run like this

select * from table_name where such&suchfield = "inputvalue"
or such&suchfield = "inputvalue"

and have the or statement be populated with as many items that is on the list the user pastes into the field.

Any info would be helpful

Thanks [sig][/sig]

 

[MalcolmW]

The key word to solve this is "parameter" - it is in effect an "inputvalue".
The online help will give you info specific to your product version. [sig][/sig]

 

[kenhamady]

lwalker,

If you are using version 7 or 8 you can allow the user to input multiple values. It behaves the same as the &quot;or&quot; logic you describe. [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]