Open a mobile report with specific query string parameters | Reporting Services

If you have a Reporting Services mobile report with parameters and a SQL Server or Analysis Services data source, you can include query string parameters in the report URL so it opens automatically with values you've specified.

  1. Create a mobile report with parameters.

  2. Open the report in Mobile Report Publisher and select the Data tab.

  3. Find the name of the dataset on the tab at the bottom of the table, and the field name you want.

    mobile-report-publisher-parameter-data-view

  4. The syntax of the URL depends on your data source.

    For a SQL Server Analysis Services data source: Build a URL with a query string parameter in this format:

    https://<servername>/reports/<report-folder-name>/<report-name>?<dataset-name>.<field-name>=<parameter-value>

    For example:

    https://sampleserver/reports/adventureworks-reports/adventureworks-load-on-demand?TimeChartLoD.category=Clothing

    For a SQL Server data source: The query string parameter is almost the same, but has the @ symbol in front of the field name:

    https://<servername>/reports/<report-folder-name>/<report-name>?<dataset-name>.@<field-name>=<parameter-value>

    For example:

    https://sampleserver/reports/adventureworks-reports/adventureworks-load-on-demand?TimeChartLoD.@category=Clothing

  5. This URL will open the report on the server, automatically filtered to the parameter value you specified.

    mobile-report-publisher-parameter-web-portal-view

See also

Add parameters to a mobile report