Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multi Value parameter does not persist in the textbox when "Select All" option in selected for the param Expand / Collapse
Author
Message
Posted Wednesday, September 9, 2009 12:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 25, 2014 3:51 PM
Points: 12, Visits: 150
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
Post #784729
Posted Thursday, December 3, 2009 8:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 16, 2010 12:45 PM
Points: 13, 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.
Post #828249
Posted Monday, December 7, 2009 5:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 25, 2014 3:51 PM
Points: 12, Visits: 150
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.
Post #829764
Posted Monday, December 7, 2009 6:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 16, 2010 12:45 PM
Points: 13, Visits: 46
Thank You!

That is really odd, but I suspected that it was something like that.
Post #829782
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse