InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 21:43:59 GMT20http://www.sqlservercentral.com/Forums/Topic1407014-147-1.aspx[quote][b]10e5x (1/14/2013)[/b][hr]Hi all,I met with a very tricky problem. I have a muti-value filter in my name whereby user are able to select the names to view the report. The parameter filter has a drop down list which is based on query, Select distinct(uName) from User. the report runs fine if user select a number of names but if the user select ALL or more names the report went haywire. Error: "operation is not valid due to the current state of the object"After diagnosis, i realize its becuz the filter text cant hold or display the names chose. what should i do? The filter is used in data source where clause as Where uName IN (@name)[/quote]Whenever you are using Multivalued parameters, pass them as comma separated to the query or stored procedure used in your dataset. To achieve this, use "join(Parameters!xx.Value,",")".Tue, 22 Jan 2013 03:59:44 GMTDivya Agrawalhttp://www.sqlservercentral.com/Forums/Topic1407014-147-1.aspxis this a stored proc?if so, extend the variable declaration to accept the additional text.Wed, 16 Jan 2013 03:14:03 GMTshanu.hoosenhttp://www.sqlservercentral.com/Forums/Topic1407014-147-1.aspxcan i trim the filter to display only up to 100 char?Mon, 14 Jan 2013 21:19:45 GMT10e5xhttp://www.sqlservercentral.com/Forums/Topic1407014-147-1.aspxHi all,I met with a very tricky problem. I have a muti-value filter in my name whereby user are able to select the names to view the report. The parameter filter has a drop down list which is based on query, Select distinct(uName) from User. the report runs fine if user select a number of names but if the user select ALL or more names the report went haywire. Error: "operation is not valid due to the current state of the object"After diagnosis, i realize its becuz the filter text cant hold or display the names chose. what should i do? The filter is used in data source where clause as Where uName IN (@name)Mon, 14 Jan 2013 21:17:43 GMT10e5x