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)