What is SQL Server Reporting Services (SSRS)

In this article, you will learn about SQL Server Reporting Services statements in SQL

Introduction

 
What is SQL Server Reporting Services (SSRS)? The SQL Server Reporting Services(SSRS) allows you to produce formatted reports with tables in the form of data, graphs, images, and charts. These reports are hosted on a Server that can be executed at any time using parameters defined by the users. The tool comes free with SQL Server. SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services that create, deploy and manage mobile and paginated reports in the Server
 

Create, deploy, and manage mobile and paginated reports in SQL Server Reporting Services

 
SQL Server Reporting Services(SSRS) solution flexibly delivers the right information to the right users. The users can consume reports via a web browser, on their mobile device, or via email in SQL server reporting services.
 
SQL Server Reporting Services offers an updated suite of products
  • Traditional paginated reports brought up to date, so you can create modern-looking reports with updated tools and new features for creating them.
  • New mobile reports with a responsive layout that adapts to different devices and the different ways you hold them.
  • A modern web portal you can view in any modernbrowser. In the new portal, you can organize and display mobile and paginated Reporting Services reports and KPIs. You can also store Excelworkbooks on the portal in SQL Server 
Read on for more about each.
 

What's new in Reporting Services

 
 These sources will keep you up to date on new features in SQL Server Reporting Services.
  • What's New in Reporting Services in SQL Server 
  • SQL Server Reporting Services Team Blog  

SQL Paginated reports

 
SQL Reporting Services is associated with traditional paginated reports, ideal for fixed-layout documents optimized for printing, such as PDF and Word files.
 
SQL Reporting Services core BI workload still exists today, so we've modernized it. Now you can create modern-looking reports with updated new features, using Report Builder, or Report Designer in SQL Server Data Tools (SSDT).
  • We updated all the default styles and color palettes, so by default you create reports with a new minimalist modern style in SQL.
  • We updated the Parameter pane, so you can arrange parameters however you want in SQL.
  • You can export to new formats such as PowerPoint. Reporting Servicesvisualizations in PowerPoint are live and editable, not justscreenshots.
  • You can create a hybrid Power BI/Reporting Services experience Rather than recreating your on-premises Reporting Services reports inPower BI, you can pin visuals from those reports to your Power BIdashboards. Then you can monitor everything in one place on your PowerBI dashboard.   

Mobile reports

 
The Mobile reports computing has shifted the devices we need to work, meaning people today have a different reporting need. The fixed-layout report experience doesn't work well when you introduce tablets and phones. Something designed for a wide PC screen isn't the optimal experience on a phone screen that's not just smaller but a portrait or landscape orientation.
 
Then you need these widely different screen form factors in a responsive layout that adapts to different screen sizes and orientations. For that, we've added a new report type: mobile reports, based on the Datazen technology we acquired about a year ago and integrated into the product. You can migrate your existing Datazen reports to Reporting Services with the SQL Server Migration Assistant for Datazen.
 
You create these mobile reports in the new Mobile Report Publisher app. Then, in the native Power BI apps for mobile devices for Windows 10, iOS, Android, and HTML5, you can access the data you have in Power BI, the cloud, or SSRS.
 
As you create visualizations, Mobile Report Publisher automatically generates sample data. This feature allows you to see how the visualization will look with your data, and what kind of data works well in each visualization.
 

Web portal

 
For end-users of native-mode Reporting Services, the front door is a modern web portal you can view in most browsers. You can access all your Reporting Services mobile, paginated reports, and KPIs in the new portal. KPIs can surface key business metrics at a glance in the browser, without having to open a report.
 
The new web portal is a complete rewrite of the Report Manager. Now it's a single-page, standards-based HTML5 app, which modern browsers are optimized for: Microsoft Edge, Internet Explorer 10 and 11, Chrome, Firefox, Safari, and all the major browsers.
 
The content on the web portal is organized by type:
  • Paginated reports
  • Mobile reports
  • KPIs
  • Excel workbooks
  • Shared datasets
  • Shared data sources
You can store and manage them securely here, in the traditional folder hierarchy. Tag your favorites reports for quick access. Those with appropriate permissions are able to manage and administer SSRS content.
 
Furthermore, you can still schedule report processing, access reports on demand, and subscribe to published reports in the new web portal.
 
More about the Web portal.
 

Reporting Services programming features

 
Take advantage of Reporting Services programming features so you can extend and customize your reporting functionality. Use the SSRS APIs to integrate or extend data and report processing in custom applications. 
 

Summary

 
In this article, you learned how to use a SQL Reporting Service statement with various options.