Edit

Create a Reporting Services mobile report

  • Article

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.

With SQL Server Mobile Report Publisher, you can quickly create SQL Server Reporting Services mobile reports that scale well to any screen size. They scale on to any screen on a design surface with adjustable grid rows and columns, and flexible mobile report elements.

The first time you create a mobile report, you can install SQL Server Mobile Report Publisher, on your local machine from the Reporting Services web portal. Or you can install it from the Microsoft Download Center. After the first time, you can start it either from the web portal or locally.

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

    Screenshot of the New menu that includes the Mobile Report option.

  2. On the Layout tab in Mobile Report Publisher, select a navigator, gauge, chart, map, or datagrid and drag it to the design grid.

  3. Grab the lower-right corner of the element and drag it to the size you want.

    Screenshot of the element with the sizing control highlighted.

    This grid is the Master design grid, where you create the elements you want in your report. Later, you can lay out the report for a tablet or phone.

    In Visual Properties under the design grid, notice the various properties you can set.

  4. Select the Data tab in the upper-left corner, and you see the chart already simulated data associated with it.

    Screenshot of the chart with the simulated table highlighted.

  5. Select Add Data in the upper-right corner.

  6. Select Local Excel or Report Server.

    Tip

    If you're adding data from Excel, make sure:

  7. Select the worksheets you want, and select Import.
    You can add more than one worksheet from a workbook at a time.

    Screenshot of the screen used to add Excel data.

  8. Still on the Data tab, in the Data Properties box select the table and field you want in the chart.

    Screenshot of the Gross Property property selected.

  9. Back on the Layout tab, in the Visual Properties box you can set properties like Title, Time Unit, and Number Format.

    Screenshot of the Visual Properties box.

  10. Select Preview in the upper left to see how your report is shaping up.

  11. Time to save your report. Select the Save icon in the upper left, and either Save Locally or Save to Server.

    To save it to a server, you need access to a SQL Server Reporting Services report server.

    Related content