How to pass multiple values for Parameter from a list?
I have a report, in which I want to use a list in the Parameter.
I set up the list and used a SQL Query. This works fine.
I set up the Parameter to use the list and it works fine when one item is checked.
When I select more than one item from the list I get an error.
My Data Set has the parameter in it. I tried to use the column IN(:PARAMETER), but BI Publisher wont accept the Parenthesis. It says failed to load SQL. If I use equals I get an error when selecting more than one item from the list.