Multi Select Parameters in SSRS with default selection set to "Select All
In the case of Multi Select Parameters in SSRS, How to set the default valueto "Select All". I.e., by default, the Parameter value should besetto "SELECT ALL".For example, if we have a @Region as a MultiSelect Parameter with Values, "EA","SW",NW" and "HQ" SSRS adds "Select ALL" check box to the Parameter list. So We have Select All, EA,SW,NW,HQ check boxes appear in the Parameter List Box for the user to pick the Parameter Values for Region. To start with, the "Select ALL" check box should be checked(default selection)How to achieve this ?
July 8th, 2009 1:11pm
There might be more than one way to achieve this, but one way would be to use the same query for your list of available value as your list of default values. This might not actually select the "select All" option, but the effect will be much the same.Hope that helps,PaulThis posting is provided "AS IS" with no warranties, and confers no rights.
July 8th, 2009 1:17pm
Thanks..That has worked..However, I realized my problem is to have a Multi Select List Box that does not show "Select All" Check Box at alli.e., How to remove the "SELECT ALL" check box from the Parameter List items..
July 8th, 2009 2:30pm
Hi,The current release of Report Builder/Report Designer does not have the ability to disable the 'select all' check box for multi-value parameters. PaulThis posting is provided "AS IS" with no warranties, and confers no rights.
July 9th, 2009 2:30pm
Thanks for the note.. I hope thatReporting Services Group should feel the need for including this feature as well as allowing Null as default for Multi Select Parameters in the next release.
July 9th, 2009 2:56pm
Thankyou for your comments. We are looking into various improvements around parameters.Your note about Null and Multi-Select is a common one, and one that does not have a simple solution. If you are looking to do this, my blog post might offer some ideas:http://blogs.msdn.com/paul_van_der_eerden/archive/2009/05/12/parameter-tips-and-tricks-volume-2.aspxPaulThis posting is provided "AS IS" with no warranties, and confers no rights.
July 10th, 2009 10:30am
Hi can you please let me know how to do this one?ThanksKK
August 11th, 2009 5:55pm
Hi, Try setting the parameters "Default Values" to use the same query as the "Available Values". In effect it provides every single available value as a default value and the "Select All" option is automatically checked. Regards, Bader
September 21st, 2012 12:42pm
I found how to set the default to (Select All) with all items checked. In the Parameter Properties of the Parameter you want set to (Select All) go to the Default Values tab. Select "Get Values from a query" Set Dataset to the same dataset your values will be populated from. Set Value Field to the same value field your values will be populated from. It will now select all by default. I thought it would hang up since there is a parameter in the dataset but it doesn't, it selects everything in the list. I hope this helps any one else with this issue.
November 3rd, 2012 11:07am