Hi All I have the report that should use multi value parameter to filter the report.I have a main dataset and a dataset to get the multi values.the database is oracle and I tried a lot with different ways and it says it doesn't support data extension.where in (:Area),where in ?,where in (@Area) didn't work where area parameter is set to multi value and the data available to the parameter is through the dataset dstArea.I have a main dataset where the where clause for area is set.Any help is appreciable.. Thanks in Advance..

just checking are you using where clause like ths where myareafield in @myareaparameter mark it as answer if it answered your question :)

Hi chebrolu, By default, writing Queries that Map to Multivalued Report Parameters is enable in Oracle data processing extension. Multi-valued parameters are only supported for SQL Server, Oracle, or Analysis Services. In this case, I suppose the cause is we are using ODBC(or OLEDB) to connect to oracle database, not using Oracle data processing extension directlly. So, to solve the issue, please use Oracle data processing extension instead of ODBC. Or, please use a combined query string like this to solve the issue:="SELECT customer_name, telephone_number, address1, address2, city from MyTable WHERE city IN '" + Join(Parameters!City.Value,"', '") + "'" If you have any more questions, please feel free to ask. Thanks,Jin Chen Jin Chen - MSFT

Hello Jin Chen, The Combined query string resolved the issue for me too. I would like to understand this issue better. I mean the query doesn't work properly while use the dataset query string in the query designer with multi value parameter. You may share this if time permits. Thanks, Jey

How do you use combined query string in SSRS? Is there any documentation I can look at. Thanks a lot!Sachin Agarwal