Skip to Content
author's profile photo Former Member
Former Member

How to enter multiple values in input field

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 ?

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on 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.


    Add comment
    10|10000 characters needed characters exceeded