10e5x (1/14/2013)
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)
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,",")".
--Divya