locked
SSRS multiple dropdown list RRS feed

  • Question

  • User954998566 posted

    Hi, 

    I have the table:  Employee(ID,Name,State)

    I want to parameter the state in a dropodownlist:

    So the dataset is :

    Select ID, Name, State from Employee where State in (@State)


    In parameters I want to select all states:

    I have set the parameter value to

    =join(Parameters!<param name>.Value,",")

    It worls for one state at at time but not for a combination of 2 or more states.

    Any solutions please.

    Tuesday, March 4, 2014 11:33 PM

Answers

  • User1140095199 posted

    Hi Salim,

                 Greetings!

    I want to parameter the state in a dropodownlist:

    As you mentioned dropdownlist is being used. Your query and parameters seems fine. But the dropdownlist cannot select multiple items at once. Check if the dropdownlist is passing multiple parameters correctly. I doubt the problem is there. Share the code where you are passing the parameters to the DataSet.

    There is another way where you can consider passing values to the RDLC Report using code.

    Use a CheckBox List and pass parameters dynamically in this way it is possible to pass multiple parameters.

    For Reference on how to pass parameters dynamically - http://forums.asp.net/t/1956391.aspx?report+with+my+own+types

    Best Regards!

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, March 6, 2014 1:38 AM