If the parameter can contain a null value, select Allow null value. If the parameter can contain a blank value, select Allow blank value. In Data type, select the data type for the parameter value. In Prompt, type the text that appears next to the parameter text box when the user runs the report. In Name, type the name of the parameter or accept the default name.

The Report Parameter Properties dialog box opens. In Report Builder or Report Designer in SQL Server Data Tools (SSDT), in the Report Data pane, right-click the Parameters node and click Add Parameter. 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. See Create mobile reports with SQL Server Mobile Report Publisher for more information.

You can also add report parameters to mobile reports in SQL Server Mobile Report Publisher. This article is about adding report parameters to a paginated report in Report Builder or Report Designer in SQL Server Data Tools (SSDT). For more information, see Report Parameters (Report Builder). You can provide multiple sets of default parameter values by creating linked reports. You can provide a default value and a list of available values, and the user can change the selection.ДЄfter you publish a report, you can change the default values, the available values, and other properties for a report parameter on the report server. APPLIES TO: вњ”пёЏВ MicrosoftВ ReportВ BuilderВ (SSRS) вњ”пёЏВ PowerВ BIВ ReportВ Builder вњ”пёЏВ ReportВ DesignerВ inВ SQLВ ServerВ DataВ ToolsДЄ paginated report parameter provides a way to choose report data, connect related reports together, and vary the report presentation.

Report builder parameters