In SSRS, is there a way to setup a parameter to have a list of values as well as one option for ALL values?

In SSRS, is there a way to setup a parameter to have a list of values as well as one option for ALL values?
thomaszhwangAsked:
Who is Participating?
 
Srm74Commented:
Yes..

Rightclick on parameter -> select Properties
Here you can set available values as well as Default values.

The values can either come from a specified range or from a query.

NB. Remember to set the type of parameter.. i.e. (Text, Date/Time,float etc.) under "General"

Hope it helps

0
 
Simone BSenior E-Commerce AnalystCommented:
In the properties of the parameter, if you make the parameter a mulit-select, then the "All" or "Select All" will show by default.
0
 
thomaszhwangAuthor Commented:
Thanks.  This works.

One more thing is how can I set the default value to "SELECT ALL"?  Thanks.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Simone BSenior E-Commerce AnalystCommented:
In the report parameter properties, try something like this under the Default Values section:
 Default to ALL
0
 
thomaszhwangAuthor Commented:
Actually the available values come from a query, not a dimension.  Thanks.
0
 
Simone BSenior E-Commerce AnalystCommented:
I haven't tried this myself, but found this information, which may be helpful:

 If you populate your parameter list with a dataset, just use the same dataset to set your default values. This technique will work regardless of whether you’re dealing with SQL or SSAS.

The URL below also includes an example.

http://blogs.msdn.com/b/bimusings/archive/2007/05/07/how-do-you-set-select-all-as-the-default-for-multi-value-parameters-in-reporting-services.aspx
0
 
thomaszhwangAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.