Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to content
Permalink
live
Switch branches/tags
Go to file
 
 
Cannot retrieve contributors at this time
title description ms.date ms.prod ms.prod_service ms.technology ms.topic helpviewer_keywords ms.assetid author ms.author ms.custom
What is SQL Server Reporting Services | Microsoft Docs
Learn about tools and services for Reporting Services reports on premises.
09/16/2022
reporting-services
reporting-services-native
reporting-services
conceptual
reports [Reporting Services]
SSRS
reports [Reporting Services], about reports
Reporting Services
SQL Server Reporting Services
b8d18d3d-9db0-43e7-8286-7b46cc3a37ed
maggiesMSFT
maggies
intro-overview

What is SQL Server Reporting Services (SSRS)?

[!INCLUDE ssrs-appliesto] [!INCLUDE ssrs-appliesto-2016-and-later] [!INCLUDE ssrs-appliesto-not-pbirs]

SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services that create, deploy, and manage paginated reports. Download SQL Server 2022 Reporting Services from the Microsoft Download Center.

Screenshot showing SQL Server 2022 Reporting Services report.

Looking for Power BI Report Server? See What is Power BI Report Server?

Create, deploy, and manage reports

The SSRS solution flexibly delivers the right information to the right users. Users can consume the reports in a web browser on their computer or mobile device, or via email.

SQL Server Reporting Services offers an updated suite of products:

  • Paginated reports brought up to date, so you can create modern-looking reports, with updated tools and new features for creating them.
  • A modern web portal you can view in any modern browser. In the new portal, you can organize and display paginated Reporting Services reports and KPIs. You can also store Excel workbooks on the portal. ::: moniker range="<=sql-server-ver15"
  • New mobile reports with a responsive layout that adapts to different devices and the different ways you hold them. ::: moniker-end

Read on for more about each.

What's new in Reporting Services

See What's New in Reporting Services to keep up to date on new features in SQL Server Reporting Services.

Paginated reports

Image of paginated reports on a desktop screen and a tablet device.

Reporting Services is associated with paginated reports, ideal for fixed-layout documents optimized for printing, such as PDF and Word files.

That 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.
  • We updated the Parameter pane, so you can arrange parameters however you want.
  • You can export to new formats such as PowerPoint. Reporting Services visualizations in PowerPoint are live and editable, not just screenshots.
  • You can create a hybrid Power BI/Reporting Services experience: Rather than recreating your on-premises Reporting Services reports in Power BI, you can pin visuals from those reports to your Power BI dashboards. Then you can monitor everything in one place on your Power BI dashboard.

::: moniker range="<=sql-server-ver15"

Mobile reports

Image of mobile reports on a desktop screen and a tablet device.

Mobile 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 small phone screen that's not just smaller but a portrait or landscape orientation.

What you need with these widely different screen form factors is a responsive layout that adapts to these 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, 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. ::: moniker-end

Web portal

Screenshot showing the web portal.

For end users of Reporting Services, the front door is a modern web portal you can view in most browsers. You can access all your Reporting Services 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 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
  • KPIs
  • Excel workbooks
  • shared datasets
  • shared data sources ::: moniker range="<=sql-server-ver15"
  • Mobile reports ::: moniker-end

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.

And 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.

::: moniker range="=sql-server-2016"

Reporting Services in SharePoint integrated mode

You publish reports to Reporting Services in SharePoint integrated mode. You can schedule report processing, access reports on demand, subscribe to published reports, and export reports to other applications such as Microsoft Excel. Create data alerts on reports published to a SharePoint site and receive email messages when report data changes.

More about Reporting Services Report Server in SharePoint integrated mode.

::: moniker-end

[!INCLUDEssRSnoversion] programming features

Take advantage of [!INCLUDEssRSnoversion] 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.

More Reporting Services Developer Documentation.

Next steps