O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Populating a drop-down parameter with a dataset

Normally, we don't want to type in values in the parameter field. So, we want to populate that field with the available data from our backend table.

Another reason is we want to give the report consumers only the available values from our dataset.

For example, with the category parameter, we may want to provide all the category values from our dataset. We don't want to leave them guessing what categories are out there to choose from.

To populate our @Category parameter, we need to create a new dataset for our report.

Since we might only need this for this particular report, we'll create a report dataset (in contrast to a shared dataset).

  1. Right-click on the Datasets folder in the Report Data window, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required