Working with Parameters (Report Model Query Designer)

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.

Important noteImportant

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 Parameters (Report Builder 3.0 and SSRS). To learn how to work with parameters in Report Designer, see Tutorial: Adding Parameters to a Report (SSRS).

For more information, see "Report Builder 1.0 Tutorials" in the in the Reporting Services documentation in SQL Server Books Online on

Community Additions