Add, change, or delete default values for a paginated report parameter (Report Builder)

Applies to:  Microsoft Report Builder (SSRS)  Power BI Report Builder  Report Designer in SQL Server Data Tools

After you create a paginated report parameter, you can provide a list of default values. If all parameters have a valid default value, the report runs automatically when you first view or preview it.

Report parameters can represent one value or multiple values. For single values, you can provide a literal or expression. For multiple values, you can provide a static list or a list from a report dataset.

Note

You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.

After you publish a report, you can override the default values that you define in the report authoring tool, by setting parameter property values on the report server. You can also provide multiple sets of default parameter values by creating linked reports. For more information, see Report parameters (Report Builder and Report Designer).

Add or change the default values for a report parameter

1. In the Report Data pane, expand the Parameters node. Right-click the parameter and select Edit. The Report Parameter Properties dialog opens.

   Note

   If the Report Data pane is not visible, select View and then choose Report Data.

2. Select Default Values.

3. Select a default option:

   • To manually provide a value or list of values, select Specify values. Select Add and then enter the value in the Value text box. You can write an expression for a value. The data type must match the data type of the parameter. Field names can't be used in an expression for a parameter.

     For multivalue parameters, repeat this step for as many values as you want to provide. The order of items you see in this list determines the order that the user sees them in the list. To change the order of an item in the list, select the Value text box to choose the item, and then use the up and down arrow buttons to move the item higher or lower in the list.

   • To provide the name of an existing dataset that retrieves the values, select Get values from a query. In Dataset, choose the name of the dataset.

     In Value field, choose the name of the field that provides parameter values.

4. Select OK.

Remove the default values for a report parameter

1. In the Report Data pane, expand the Parameters node. Right-click the parameter and select Edit. The Report Parameter Properties dialog opens.

2. Select Default Values.

3. In Select from one of the following options, select No default value.

4. Select OK.

Related content

• Report parameters (Report Builder and Report Designer)
• Add cascading parameters to a report (Report Builder)
• Tutorial: Add a parameter to your report (Report Builder)
• Add dataset filters, data region filters, and group filters (Report Builder)
• Parameters collection references (Report Builder)
• Change the order of a report parameter (Report Builder)
• Add, change, or delete a report parameter (Report Builder)
• Expressions (Report Builder)