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.