Working with Parameters (Report Model Query Designer)

New: 17 July 2006

When you create model-based reports using Report Model Query Designer, you can use the report, query, or dataset parameter functionality that is available to all query designers in SQL Server Business Intelligence Development Studio. You can use an unlimited number of parameters in your reports.

Parameters are not used for row-level security; they do not prevent users or groups of users from seeing specific rows of data. To apply security to the data displayed within a report, you need to use security filters or model item security. For more information about using security filters, see Tutorial: Applying Security Filters to Report Model Items.

To add parameters to your report in the Report Model Query Designer
  1. Open the Filter Data dialog box and create a filter clause.
  2. Click the entity or field that you want to use as a parameter and select the Prompt option.
    A placeholder parameter is added to the report RDL and semantic query.
  3. In Business Intelligence Development Studio, select Report Parameters from the Report menu.
    The Report Parameters dialog box opens and you can modify the placeholder parameter functionality. For more information about report parameter functionality, see Working with Parameters in Reporting Services. To learn how to work with parameters in Report Designer, see Tutorial: Adding Parameters to a Basic Tabular Report and Tutorial: Advanced Features Using Parameters.