InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 00:38:27 GMT20http://www.sqlservercentral.com/Forums/Topic1409095-150-1.aspx[quote][b]sqldba_newbie (1/18/2013)[/b][hr]I am experiencing this exact issue as mentioned here [url=http://blogs.msdn.com/b/sql_pfe_blog/archive/2009/06/17/possible-performance-implications-when-using-string-parameters-in-reporting-services.aspx][/url]. I do have a work around. I was wondering is there a setting on the report server or some type of setting on the report server so that we can avoid this conversion?[/quote]I've always considered the implementation of multi-value parameters in SSRS to be sub-optimal for this very reason. The most effective workaround, in my view, is to use a stored procedure that accepts the comma-delimited string that SSRS creates from the multi-value parameter and calls a string-splitter function like this one:[url]http://www.sqlservercentral.com/articles/Tally+Table/72993/[/url]to split the values into a rowset that you can use with an IN condition in the WHERE clause. This way, you can convert the individual parameter values to the same datatype as the column on the other side of the IN, making a SARGable condition that can make use of an appropriate index, if one exists.Wed, 23 Jan 2013 11:47:33 GMTwolfkilljhttp://www.sqlservercentral.com/Forums/Topic1409095-150-1.aspxThere is no report server setting to change the parameters in SSRS from Unicode to Non-Unicode.Tue, 22 Jan 2013 01:48:50 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409095-150-1.aspxAnyone?Mon, 21 Jan 2013 14:05:42 GMTcurious_sqldbahttp://www.sqlservercentral.com/Forums/Topic1409095-150-1.aspxI am experiencing this exact issue as mentioned here [url=http://blogs.msdn.com/b/sql_pfe_blog/archive/2009/06/17/possible-performance-implications-when-using-string-parameters-in-reporting-services.aspx][/url]. I do have a work around. I was wondering is there a setting on the report server or some type of setting on the report server so that we can avoid this conversion?Fri, 18 Jan 2013 13:55:32 GMTcurious_sqldba