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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Adriaan Davel » Multi Value parameter does not persist in the...

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

Rate Topic

Display Mode

Topic Options

Author

Message

veen_computers

Posted Wednesday, September 09, 2009 12:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:04 AM
Points: 8, Visits: 135

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

geoff.balla

Posted Thursday, December 03, 2009 8:42 AM

Grasshopper

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

veen_computers

Posted Monday, December 07, 2009 5:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:04 AM
Points: 8, Visits: 135

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

geoff.balla

Posted Monday, December 07, 2009 6:14 AM

Grasshopper

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 »

Permissions