Tutorial: Adding a Parameter to a Report (Report Builder)

New: 17 July 2006

A parameter is a variable that allows your report readers to set the scope of the data returned when a report is run. In Report Builder, you can add an unlimited number of parameters to your report using the Prompt option within a filter clause.

This tutorial is designed to help you add a parameter to a basic tabular report based on the AdventureWorks database. In this tutorial, you will start Report Builder, create a report, add fields to the report, and then run the report. Then, you will add two parameters to the report and run the report again.

Estimated time to complete this tutorial: 30 minutes

Your computer must have the following installed to use this tutorial:

  • Microsoft .NET Framework 2.0.

The report server from which you start Report Builder must have the following:

  • The AdventureWorks database installed on a computer that is accessible to the report server. For more information about installing sample databases, see Installing Samples.
  • The AdventureWorks Sample Report Model uploaded to the report server.

Note   This tutorial assumes that you are using an unmodified version of the report model sample included with SQL Server. If you use a model that has been previously modified, the results of your tutorial might not match what is described in this tutorial.

  • Permissions for you to access the sample report model.
  • Permissions for you to use Report Builder.
  • Permissions for you to retrieve data from the AdventureWorks database.
  • Permissions for you to save reports to the report server.
For more information about publishing a report model, see the "Publishing a Report Model" topic in Books Online.

Community Additions