January 14, 2013 at 9:17 pm
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)
January 14, 2013 at 9:19 pm
can i trim the filter to display only up to 100 char?
January 16, 2013 at 3:14 am
is this a stored proc?
if so, extend the variable declaration to accept the additional text.
January 22, 2013 at 3:59 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply