Skip to Content

How to enter multiple values in input field

Feb 15, 2017 at 10:34 PM


avatar image
Former Member

I have an input field in a crystal report that accepts user input. The input can be multiple values but the user has to enter each value and click ADD each time. Is there a way to just enter all the values on one line and then click ADD

Sometimes we have 3 to 400 values to add each time.

Is there an easier way to do this ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Feb 16, 2017 at 08:49 AM

Hi Satish,

You'd need to set the 'allow multiple value' option to FALSE.

You'd then need to handle the comma delimited string entered by the user in the selection formula or the Command SQL.

If you're reporting directly against Tables/Views, you can use the following syntax in the selection formula:

{Table.Field} IN split({?Parameter Name},',')

This will also push the selection formula down to the database.


10 |10000 characters needed characters left characters exceeded