September 9, 2009 at 12:42 am
[font="Arial"]Hi,
i have 1 multi value parameter 'State'. This parameter depends on the previous parameters 'Continent' and 'Country'.
For Suppose we select parameters :-
Continent: 'Asia' (populating this from a dataset)
Country: 'India' (populating this from a dataset)
State(Multi value parameter): "a, b, c" (populating this from a dataset)
The State Parameter does not persist. On selection of "Select All" option a postback occurs and it clears off. The selected values are not shown in the textbox.
Please help!!! its urgent[/font]
December 3, 2009 at 8:42 am
I have been searching all over for someone who has also had this issue. Did you ever get it resolved? I have cascading parameters of State > City > Zip...I can 'select all' for any parameter except for City. I blanks out as if I chose nothing. It is very random because I can select a group of cities (anywhere between 3 or more) and sometimes it does the same thing, but sometimes it works.
December 7, 2009 at 5:35 am
During the course of time i observed that, this multi-value parameter selection is being wiped of due to case sensitivity. I know that Sqlserver isnt case sensitive, but i dont know why.
The solution is while populating the parameter dataset better use "Upper(Ltrim(rtrim(City))) - value and Lable fields" in the dataset query and checked all of my datasets and it worked fine for me. Hope this isn't a permanent solution, but its working fine for me till date.
Don't forget to use to the same pattern in main dataset as some spaces may be trimmed.
December 7, 2009 at 6:14 am
Thank You!
That is really odd, but I suspected that it was something like that.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply