Post reply

Filter or search in drop-down list for multi-select parameter

  • January 21, 2014 at 10:14 am

    #282491

    Hi

    Is it possible to filter (search) in the build-in drop-down list for a paramater ?

    I have a select parameter (multi-select) with a lot of items in it and I would like to filter or search in it based on the user input.

    Thank you !

  • January 22, 2014 at 3:50 am

    #1682313

    You probably want to do multiple parameter drop downs going from higher levels to filter the next parameter. For example, parameters one says to select from the 1st letter A to Z. Then next parameters shows all values which start with for example A and B.

  • January 22, 2014 at 3:52 am

    #1682314

    Another option is to have a first parameter which is just a text field.

    Here you can enter your filter and the second parameter will be filtered using the text you entered in the first one.

    For example by using LIKE in the query that selects the values for the second parameter.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply