How to enter multiple values in input field

[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 ?

[abhilash_kumar]

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.

-Abhilash