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
View Complete Post