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).
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 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
- Excel workbooks
- shared datasets
- shared data sources