SSRS Diagram

What is SQL Reporting Services (SSRS) ?

SSRS provides a set of on-premises tools and services that create, deploy, and manage mobile and paginated reports. Users can consume the reports via a web browser, on their mobile device, or via email.

The product suite has the below offering:

  • Taditional paginated reports
  • Mobile reports with responsive layout
  • Web portal to organize the deliveries

 

Traditional Paginated Report

Reporting Services is associated with "traditional" paginated reports, ideal for fixed-layout documents optimized for printing, such as PDF and Word files. Now you can create modern-looking reports with using Report Builder, or Report Designer in SQL Server Data Tools (SSDT).

SSRS paginated

 

Mobile Reports

Something designed for a wide PC screen isn't the optimal experience on a small phone screen that's not just smaller but a portrait or landscape orientation. You create responsive mobile reports in the Mobile Report Publisher app. Then use the native Power BI apps for mobile devices to consume or view the reports.

SSRS mobile reports 

 

Web Portal

SSRS provides Report Manager platform to access all your Reporting Services mobile, paginated reports, and KPIs in the new portal.

The content on the web portal is organized by type:

  • paginated reports
  • mobile reports
  • KPIs
  • Excel workbooks
  • shared datasets
  • shared data sources

SSRS web portal 

 

Microsoft BI Overview