Multi Select Doing Strange Things In Reporting Services

Hi All,

I've got the following situation.

I've got a report that has 3 multiselect parameter selection dropdowns in my report.

Dropdown 3 is depending on the selected values of dropdown 2.
Dropdown 2 is depending on the selected values of dropdown 1.


For example:

In dropdown 1 the values A1 and A2 are available

when I select a value A 1 in dropdown 1 values A1_B1 and A1_B2 are available in dropdown 2

when I select A1 and A2 in dropdown1 values A1_B1, A1_B2, A2_B1 and A2_B2 are available in dropdown 2

when i select A1_B1 in dropdown 2 values A1_B1_C1,A1_B1_C2 are available in dropdown 3
when i select A1_B1 AND A1_B2 IN dropdown2 values A1_B1_C1,A1_B1_C2, A1_B2_C1,A1_B2_C2 are available in dropdown 3



dropdown 1 | dropdown 2 | dropdown 3
A1 | A1_B1 | A1_B1_C1

| | A1_B1_C2
| A1_B2 | A1_B2_C1
| | A1_B2_C2

in the "picture" above I describe the selection i make in the report

so
in dropdown 1 I select A1
in dropdown 2 I select A1_B1,A1_B2
in dropdown 3 I select A1_B1_C1,A1_B1_C2,A1_B2_C1, A1_B2_C2

then the strang happens.

When I look in profiler to see what happens, is that for dropdown 2 the second value for the parameter of dropdown 2 is
and for dropdown 3 all except the first one is missing.

The values from the dropdownboxes are passed through to a subreport. When the selected values from dropdown boxes are passed though directly to the datasets this problem doesn't occur.


Is this normal behaviour? Or do I miss something.


Thanks for your help,


Eric