I have an Oracle table with a column that has concatenated values separated by commas. In SSRS, how does it handle a multivalue parm in this scenario? On the SSRS report, the parameter field will not work with a drop-down list of values to select from. It will only work if I remove the drop-down list and just enter it this way in the box field when previewing the report:

Parameter: blue,red,orange

But it will not work if entering it this way (see below) on the report and previewing it will give an error (invalid relational error).  Like so:

Parameter: blue

                   red

                   orange

I would need the above to work as I need a drop-down selection list. Can it even be done? The SQL btw runs perfectly in Oracle, it only complains in SSRS when selecting more than one value.

​I have an Oracle table with a column that has concatenated values separated by commas. In SSRS, how does it handle a multivalue parm in this scenario? On the SSRS report, the parameter field will not work with a drop-down list of values to select from. It will only work if I remove the drop-down list and just enter it this way in the box field when previewing the report: Parameter: blue,red,orange But it will not work if entering it this way (see below) on the report and previewing it will give an error (invalid relational error).  Like so: Parameter: blue                   red                   orange I would need the above to work as I need a drop-down selection list. Can it even be done? The SQL btw runs perfectly in Oracle, it only complains in SSRS when selecting more than one value.  Read More

​