Multiple Parameters Error OLEDB MS Access SSRS
Hi I have created an SSRS in BIDS 2008 with OLEDB Provider so as to access MS Access 2010 DB. My report is working fine. But the only problem is when am sending multiple parameter it raises error. I have enabled AllowMultiple Value checkbox. ERROR : "Cannot add multi value parameter '@parametername" for DataSetName because it is not supported by the data extension". My query is "SELECT * FROM tablename WHERE ([columnname] in (@parametername))" Thanks in advance
October 11th, 2010 3:23pm
You can write a SQL function(GETTABLEFROMCSV) which would take the multi-valued parameter as input and would return you a table of individual values. In this case "IN" would work correctly. So your sql would look like this SELECT * from tablename where columnname in (SELECT STRING FROM DBO.GETTABLEFROMCSV(@columnnames)) Ex: @columnnames = 'col1,col2,col3' Output of your SQL function should be (SELECT STRING FROM DBO.GETTABLEFROMCSV(@FirstName)) col1 col2 col3 Let me know if you need any help!Dinesh Behera If this post answers your question, please mark it as an Answer.
October 11th, 2010 6:06pm