SSRS – Default Parameter Values to (Select All)

To configure the (Select All) selection for a multi-value parameter in Reporting Services simply configure your parameter’s Default settings to read the value from the same dataset as your Available Values dataset. 

Right click on your report parameter, select “Parameter Properties”, select “Default Values”, select “Get Values From a Query”, select the same dataset you configured for “Available Values” and select the Value field for this dataset.

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

1 Response

  1. Mark Bird

    Yep, that’s a useful technique. However, if you have duplicate labels with different associated values, what I observe (in 2008 R2) is that the duplicate labels (and their corresponding values) don’t get selected and therefore get lost when the parameter gets used in a subsequent SQL query, thus reducing the result set. Any ideas on how to overcome that?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s