SSRS 2016 Mobile reports

In this post, I have provided quick walk-through on Integration of Mobile reports with SSRS 2016 

Below are the pre-requisites to play with mobile reports, Inside Azure VM – Install below software’s:

1.       Microsoft Visual C++ 2012 Redistributable (x86) - 11.0.61030
2.       Microsoft SQL Server Mobile Report Publisher
3.       Microsoft® SQL Server® 2016 Report Builder
4.       Configured a Firewall for Report Server Access
5.       AdventureWorks Databases and Scripts for SQL Server 2016 CTP3

SQL Server Mobile Report Publisher is an authoring tool for mobile reports 
for SQL Server 2016 Reporting Services.

Below are the steps to create mobile reports, publish on report server 
& view mobile reports on PowerBI app:

Step 1:  Create a Datasource connection pointing to AdventureWorks database 
             & Dataset on the report server

Step 2:  Create mobile report and save on the report server

Step 3: Download PowerBI app on mobile and connect using DNS name & VM credentials.

Below are the sample mobile report screenshots:

Created two sample reports i) Sales by Territory ii) Sales by Territory Current Vs Previous Year

Drill through to next report with filter as the selected datapoints (jump report) functionality can be achieved. You will find options to do this in the bottom of design page.

For example (as shown below) – Select Territory as ‘Europe’ in report 1 and then click on ‘Germany’ in the category chart in center to jump to report 2.

See Also:
            My posts on SSRS

                            Create mobile reports with SQL Server Mobile Report Publisher

No comments: