Search code examples
reporting-servicesssrs-2008ssrs-2012

SSRS MultiValue Parameter Default not Selecting Any

I am trying to make a multi-value parameter that's based off of a dataset to use another field for the Default values. I created a dataset for the parameter with the users and another column that substitutes an X for the username (op_user) if it's an automation account. Unfortunately, it's not selecting any of the usernames.

I have checked the data and there are no NULL values. I have ran a query to make sure that the columns are equal (the Match column).

F.U. to all the cowardly down-voters who don't comment

It works fine if I use the same op_user column for the default values but none are selected if I use the OPuser column.

enter image description here

enter image description here

Can anyone give me an idea of what else I can try in order to make this work?

Solution

  • The problem that I see is that your "Default Values" column of OPuser now contains an 'X' value that is not in your available values. No values will be selected unless all the default values actually exist in the available values column.

    I would suggest that you solve this problem with a second dataset. Just use the logic to generate the OPuser column separately and then use that dataset as your default values. That way you don't have to worry about the 'X' values that you don't actually want to be selected.