SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Multi Value parameter does not persist in the textbox when "Select All" option in selected for the...


Multi Value parameter does not persist in the textbox when "Select All" option in selected for the param

Author
Message
veen_computers
veen_computers
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 154
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

geoff.balla
geoff.balla
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 46
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.
veen_computers
veen_computers
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 154
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.
geoff.balla
geoff.balla
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 46
Thank You!

That is really odd, but I suspected that it was something like that.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search