0

In a multi-select Parameter for SSRS (2008), I want the default state of an input parameter to be such that one option is unchecked while all others are checked. Like in the image that follows:

enter image description here

Is there any way in SSRS that this can be accomplished? I guess there is no way to refer to a "checked" state so this can be handled?

1

In the parameter preference pane, there's one tab for available, and one tab for default. You can pick completely different details for each set, including different datasets, one with the available options, and one selecting just the ones you want set as defaults.

  • Wouldn't manual addition in defaults be like hardcoding? I want it to populate from a query but leave one unchecked so we don't have to change or add to defaults manually. – Ravi Apr 26 '16 at 13:16
  • Then you use two data sets. One that pulls back all the possible values, and one that pulls the same ones back minus the one you don't want selected. – Cody Konior Apr 26 '16 at 13:57
  • How can we point it to two datasets? I thought Default or Available values could only be associated with one dataset. – Ravi Apr 27 '16 at 4:32
  • In the parameter preference pane, there's one tab for available, and one tab for default. You can pick completely different details for each set, including data set. – Cody Konior Apr 27 '16 at 4:36
  • Ah yes! Yes you're right, I did it just now, NOW I know what you mean. Can you post this as answer so I can choose it as such. Thank you very much for this. – Ravi Apr 27 '16 at 5:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.