I have an Oracle table that has a column with concatenated values, separated by commas, like so:

Table A

SKU    Toy        COLOR
323    cars       black,blue
655    dolls      pink,red,orange

On my SSRS report, I added a parameter called Color, and checked “allow multiple values.” And for “Available Values,” I selected “Get values from a query,” and made sure to create the corresponding dataset for the list of color values to choose from.

Previewing the report, it works ONLY IF I select just one color from the Color parameter’s drop-down list. But if I select more than one color, SSRS would spit out an error (invalid relational operator).

I tried changing the SQL, but SSRS always find something to complain about (invalid number, missing parenthesis, etc.) even though it does run in Oracle and if selecting just one value in SSRS.

So, I put back to “None” for the “Available Values” for the Color parameter, so I can type it instead, and this is what I found. On the Color parameter field in SSRS, the report runs if I enter the values horizontally (separated by commas) like so:

 Color: blue,red

But it will not work if I enter them vertically (like a list) like so:

 Color: blue
        red

I also tried it this way, no go:

 Color: blue,
        red

Any idea on how to remedy this? As I would need to put back the “Available Values” since we need the parameter to have a drop-down selection list.