 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / November 2006How to uncheck values in MultiValue Parameter queries
I have a parameter that does a query. The parameter is a multi-value selection. Here is the problem. The query may return 500 values. The user needs to select maybe 5 or 10 values in the dropdown. However currently they are all selected forcing the user to unselect hundreds. Is there a way to force the multiselect parameter to default to all "unchecked" as opposed to all checked/selected? Thanks. Office Web Components against Olap / Analysis Services has a Select All functionality. -aaron > I have a parameter that does a query. The parameter is a multi-value > selection. Here is the problem. The query may return 500 values. The user [quoted text clipped - 4 lines] > > Thanks. If there is a "Select All" option at the top, click it so that it is checked, and then click it again so that it is unchecked. The "select all" functionality also serves as a "deselect all". This resolves the symptom but not the problem itself. It sounds like you have the same dataset specified for both the Available and the Default values. Change it so that there isn't a default value. -Josh > I have a parameter that does a query. The parameter is a multi-value > selection. Here is the problem. The query may return 500 values. The user [quoted text clipped - 4 lines] > > Thanks. The solution in this case is quite simple. Check Null for the Default values for this parameter. When the report is loaded, nothing is checked. If you already have SQL 2005 SP1 installed, to be able to use the Select All option, you'll need to get a hot fix from Microsoft support otherwise Select All is not available to your users. HTH. > I have a parameter that does a query. The parameter is a multi-value > selection. Here is the problem. The query may return 500 values. The user [quoted text clipped - 4 lines] > > Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.