Add parameters to a mobile report

Note

SQL Server Mobile Report Publisher is deprecated for all releases of SQL Server Reporting Services after SQL Server Reporting Services 2019. It is discontinued starting in SQL Server Reporting Services 2022 and Power BI Report Server.

You can create a Reporting Services mobile report with parameters, so you and your report readers can filter your reports. A report with parameters can also be the target of a drillthrough from a source report.

To create a mobile report with parameters, you start with a shared dataset with at least one parameter. Read about creating parameters in a shared dataset. Mobile reports don't support null value(s) for default parameters, so make sure your parameters have default values other than null.

After you add parameters to a mobile report, you create a URL to open the report with query string parameters.

1. In the top bar of the Reporting Services web portal, select New > Mobile Report.

   

2. Select the Data tab.

3. Select Add Data.

4. Select Report Server, then select a server.

5. Navigate to the shared datasets on the server and select one that has parameters.

   In the grid, you see the data in the dataset. The green circle with brackets { } marks a dataset with a parameter.

   

6. Select the cog on the tab, then select Param {}.

   

7. Select the report element that passes values to the parameter.

   

8. Select Preview to see how the report looks. In this report, the selection list is using the Category parameter.

   

9. When you select a value in the selection list, the report is filtered to that value, in this case, Accessories.

   

Related content

• Open a mobile report with specific query string parameters
• Add drillthrough from a mobile report to other mobile reports or URLs
• Create a shared or embedded dataset
• Create and publish mobile reports with SQL Server Mobile Report Publisher