SQL Reporting Services Filter Select All Auto Run

Question

I am creating a report with SQL reporting services. VS 2008 SQL 2008.

I created a filter for dates and distinct values. For dates I created two filters/parameters for date ranges and was able to successfully run the report on first click.

However when creating a filter for distinct values and drop down. I am unable to figure out how to run the reports on first click. It keeps forcing me to choose a selection. I want it to run on the first click with the "Select All" option already selected.

What am I missing? The Dataset query contains the dates while I added the drop down one through the GUI.

Answer 1

Use these instructions to set default values. You'll want to use the Get values from a query option. Point the default parameter to the dataset that is being used to generate the list of distinct values.