Why is it that when I set up a multi value parameter in SSRS and default the value to more than one default value, those values are not checked off when the report runs?
My parameter gets its values from a query specified in "Available Values". That works just fine. When I run the report one check box is selected by default in the drop down. But when I default the value of the parameter to two or more values, then no options are checked off.
For example, say my query returns:
A
B
C
D
E
F
Then say I default the value to B. Then A through F show in the drop down, when the report runs, and B is checked off. But if I set B and D as Default Values, then nothing is checked, just the A through F appear as options in the drop down, but none are selected. Why is this? Please help.