什么是 SQL Server Reporting Services (SSRS)?What is SQL Server Reporting Services (SSRS)?

适用对象:APPLIES TO: SQL Server 2016 Reporting Services 及更高版本 Power BI 报表服务器适用对象:APPLIES TO: SQL Server 2016 Reporting Services 及更高版本 Power BI 报表服务器

要查找 Power BI 报表服务器?Looking for Power BI Report Server? 请参阅什么是 Power BI 报表服务器?See What is Power BI Report Server?.

SQL Server Reporting Services (SSRS) 提供了一系列本地工具和服务,用于创建、部署和管理移动和分页报表。SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services that create, deploy, and manage mobile and paginated reports.

所有 SQL Server Reporting ServicesSQL Server Reporting Services all together

创建、部署和管理移动和分页报表Create, deploy, and manage mobile and paginated reports

SSRS 解决方案灵活地将正确信息提供给正确用户。The SSRS solution flexibly delivers the right information to the right users. 用户可以通过 Web 浏览器、移动设备或电子邮件使用报表。Users can consume the reports via a web browser, on their mobile device, or via email.

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.
  • 新式 Web 门户 ,可在任何新式浏览器中查看。A modern web portal you can view in any modern browser. 在新门户中,可以组织和显示移动和分页 Reporting Services 报表及 KPI。In the new portal, you can organize and display mobile and paginated Reporting Services reports and KPIs. 还可在门户中存储 Excel 工作薄。You can also store Excel workbooks on the portal.

请继续阅读有关每项的详细信息。Read on for more about each.

Reporting Services 中的新增功能What's new in Reporting Services

这些源让你可以随时了解最新的 SQL Server Reporting Services 新增功能。These sources will keep you up to date on new features in SQL Server Reporting Services.

分页报表Paginated reports


Reporting Services 与“传统”分页报表相关联,非常适合用于为打印而优化的固定布局文档,如 PDF 和 Word 文件。Reporting Services is associated with "traditional" paginated reports, ideal for fixed-layout documents optimized for printing, such as PDF and Word files.

现在仍存在核心 BI 工作负荷,因此我们对其进行了改进。That core BI workload still exists today, so we've modernized it. 现在,可使用 SQL Server Data Tools (SSDT) 中的报表生成器或报表设计器创建具有更新后的新功能的新式报表。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.
  • 可以导出到 PowerPoint 等新格式。You can export to new formats such as PowerPoint. PowerPoint 中的 Reporting Services 可视化效果是实时且可编辑的,不仅仅是屏幕截图。Reporting Services visualizations in PowerPoint are live and editable, not just screenshots.
  • 可创建混合的 Power BI/Reporting Services 体验:可将报表中的视觉对象固定到 Power BI 仪表板,而不是在 Power BI 中重新创建本地 Reporting Services 报表。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. 然后可以在 Power BI 仪表板上同一个位置监视所有内容。Then you can monitor everything in one place on your Power BI dashboard.

移动报表Mobile reports


移动计算已经改变了工作所用的设备,这意味着现在的用户具有不同的报告需求。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. 为此,我们添加了新的报表类型:移动报表,此报表基于我们在约一年前获得并集成到产品中的 Datazen 技术。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. 使用 SQL Server Migration Assistant for Datazen可以将现有 Datazen 报表迁移到 Reporting Services。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. 然后在本机适用于 Windows 10、iOS、Android 和 HTML5 的用于移动设备的 Power BI 应用中,可访问 Power BI、云或 SSRS 中的数据。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 门户Web portal

图中显示了 Web 门户笔记本电脑。

对于本机模式 Reporting Services 的最终用户,前门是可在大多数浏览器中查看的新式 Web 门户。For end users of native-mode Reporting Services, the front door is a modern web portal you can view in most browsers. 可以在新门户中访问所有 Reporting Services 移动报表、分页报表及 KPI。You can access all your Reporting Services mobile, paginated reports, and KPIs in the new portal. KPI 可结合浏览器查看关键业务指标,而无需打开报表。KPIs can surface key business metrics at a glance in the browser, without having to open a report.

新的 Web 门户是完全重写的报表管理器。The new web portal is a complete rewrite of Report Manager. 现在,它是单页、基于标准的 HTML5 应用,新式浏览器针已针对此应用进行了优化,这些浏览器包括:Microsoft Edge、Internet Explorer 10 和 11、Chrome、Firefox、Safari 以及所有主流浏览器。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.

Web 门户内容按类型进行整理:The content on the web portal is organized by type:

  • 分页报表paginated reports
  • 移动报表mobile reports
  • Excel 工作薄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. 那些具有适当权限的用户能够管理 SSRS 内容。Those with appropriate permissions are able to manage and administer SSRS content.

在新的 Web 门户中,仍可计划报表处理、按需访问报表并订阅已发布的报表。And you can still schedule report processing, access reports on demand, and subscribe to published reports in the new web portal.

详细了解 Web 门户More about the Web portal.

SharePoint 集成模式下的 Reporting ServicesReporting Services in SharePoint integrated mode

在 SharePoint 集成模式下将报表发布到 Reporting Services。You publish reports to Reporting Services in SharePoint integrated mode. 可以计划报表处理,按需访问报表,订阅已发布的报表并将报表导出到其他应用程序,例如 Microsoft Excel。You can schedule report processing, access reports on demand, subscribe to published reports, and export reports to other applications such as Microsoft Excel. 可以在发布到 SharePoint 站点的报表上创建数据警报,并在报表数据更改时接收电子邮件。Create data alerts on reports published to a SharePoint site and receive email messages when report data changes.

了解有关 SharePoint 集成模式下的 Reporting Services 报表服务器的详细信息。More about Reporting Services Report Server in SharePoint integrated mode.

Reporting ServicesReporting Services 编程功能programming features

充分利用 Reporting ServicesReporting Services 编程功能,以便扩展和自定义报告功能。Take advantage of Reporting ServicesReporting Services programming features so you can extend and customize your reporting functionality. 使用 SSRS API 在自定义应用程序中集成或扩展数据和报表处理。Use the SSRS APIs to integrate or extend data and report processing in custom applications.

更多 Reporting Services 开发人员文档.More Reporting Services Developer Documentation.

后续步骤Next steps