不同版本支持的 SQL Server Reporting Services 功能SQL Server Reporting Services features supported by editions

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

本主题介绍 SQL Server 各个版本支持的 SQL Server Reporting Services (SSRS) 功能。This topic explains the SQL Server Reporting Services (SSRS) features supported by the different editions of SQL Server. 可在 180 天的试用期内使用 SQL Server 评估版。SQL Server Evaluation edition is available for a 180-day trial period.

SQL Server Reporting ServicesSQL Server Reporting Services

有关 Evaluation 和 Developer 版本支持的功能,请参阅下表中列出的 SQL Server Enterprise Edition 列。For features supported by the Evaluation and Developer editions, see the SQL Server Enterprise edition column in the following table.

功能名称Feature name EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services 开发人员Developer
Power BI 报表和 Excel 工作簿Power BI reports and Excel workbooks 是,有软件保障Yes, with Software Assurance Yes
移动报表和分析Mobile reports and analytics Yes Yes
支持的目录数据库 SQL ServerSQL Server 版本Supported catalog database SQL ServerSQL Server edition Standard 或更高版本Standard or higher Standard 或更高版本Standard or higher WebWeb ExpressExpress Standard 或更高版本Standard or higher
支持的数据源 SQL ServerSQL Server 版本Supported data source SQL ServerSQL Server edition 所有 SQL ServerSQL Server 版本All SQL ServerSQL Server editions 所有 SQL ServerSQL Server 版本All SQL ServerSQL Server editions WebWeb ExpressExpress 所有 SQL ServerSQL Server 版本All SQL ServerSQL Server editions
报表服务器Report server Yes Yes Yes Yes Yes
报表设计器Report designer Yes Yes Yes Yes Yes
报表设计器的 Web 门户Report designer web portal Yes Yes Yes Yes Yes
基于角色的安全性Role-based security Yes Yes Yes Yes Yes
导出到 Excel、PowerPoint、Word、PDF 和图像Export to Excel, PowerPoint, Word, PDF, and images Yes Yes Yes Yes Yes
增强的仪表和图表Enhanced gauges and charting Yes Yes Yes Yes Yes
将报表项固定到 Power BIPower BI 仪表板Pin report items to Power BIPower BI dashboards Yes Yes Yes Yes Yes
自定义身份验证Custom authentication Yes Yes Yes Yes
作为数据馈送的报表Report as data feeds Yes Yes Yes Yes Yes
模型支持Model support Yes Yes Yes Yes
为基于角色的安全性创建自定义角色Create custom roles for role-based security Yes Yes Yes
模型项安全性Model item security Yes Yes Yes
无限制链接点击Infinite click through Yes Yes Yes
共享组件库Shared-component library Yes Yes Yes
电子邮件和文件共享订阅和计划Email and file share subscriptions and scheduling Yes Yes Yes
报表历史记录、执行快照和缓存Report history, execution snapshots, and caching Yes Yes Yes
SharePoint 集成2SharePoint integration2 Yes Yes Yes
远程和非 SQL 数据源支持1Remote and non-SQL data source support1 Yes Yes Yes
数据源、传递和呈现以及 RDCE 扩展性Data source, delivery, and rendering and RDCE extensibility Yes Yes Yes
自定义品牌Custom branding Yes Yes
数据驱动报表订阅Data-driven report subscription Yes Yes
扩展部署(Web 场)Scale-out deployment (web farms) Yes Yes
警报2 (SSRS 2016)Alerting2 (SSRS 2016) Yes Yes
Power View2 (SSRS 2016)Power view2 (SSRS 2016) Yes Yes
注释3Comments3 Yes Yes Yes Yes Yes

1 有关 SQL Server Reporting Services (SSRS) 支持的数据源详细信息,请参阅 Reporting Services (SSRS) 支持的数据源1 For more information on supported data sources in SQL Server Reporting Services (SSRS), see Data sources supported by Reporting Services (SSRS).

2 在 SharePoint 模式下需要 SQL Server 2016 Reporting Services。2 Requires SQL Server 2016 Reporting Services in SharePoint mode. 有关详细信息,请参阅 安装 SQL Server Reporting Services SharePoint 模式For more information, see Install SQL Server Reporting Services in SharePoint mode. 自 SQL Server 2017 Reporting Services 之后,不再提供与 SharePoint 的集成这一功能。Starting in SQL Server 2017 Reporting Services, integration with SharePoint is no longer available.

3 仅在 Power BI 报表服务器和 SQL Server 2017 Reporting Services 及更高版本中。3 Only in Power BI Report Server and SQL Server 2017 Reporting Services and later.

备注

SQL Server Express with Tools 和 SQL Server Express 不支持 Reporting Services。SQL Server Express with Tools and SQL Server Express don't support SQL Server Reporting Services.

报表服务器数据库的版本要求Edition requirements for the report server database

创建报表服务器数据库时,并非所有版本的 SQL Server SQL ServerSQL Server 都可以用来承载数据库。When you create a report server database, not all editions of SQL Server SQL ServerSQL Server can be used to host the database. 下表显示了可用于特定 SQL Server Reporting ServicesReporting Services 版本的 数据库引擎Database Engine 版本。The following table shows you which editions of the 数据库引擎Database Engine you can use for specific editions of SQL Server Reporting ServicesReporting Services.

对于此 SQL ServerSQL Server Reporting Services 版本,For this edition of SQL ServerSQL Server Reporting Services, 使用此版本的数据库引擎实例来承载数据库。Use this edition of the Database Engine instance to host the database.
EnterpriseEnterprise Standard Edition 或 Enterprise Edition(本地或远程)Enterprise or Standard editions (local or remote)
StandardStandard Standard Edition 或 Enterprise Edition(本地或远程)Enterprise or Standard editions (local or remote)
WebWeb Web Edition(仅用于本地)Web edition (local only)
Express with Advanced ServicesExpress with Advanced Services 具有高级服务的 Express(仅本地)Express with Advanced Services (local only)
计算Evaluation 计算Evaluation

商业智能客户端Business intelligence clients

Microsoft 下载中心提供以下软件客户端应用程序。The following software client applications are available on the Microsoft Download Center. 它们有助于创建在 SQL ServerSQL Server 实例上运行的商业智能文档。They help you create business intelligence documents that run on a SQL ServerSQL Server instance. 当你在某一服务器环境中托管这些文档时,请使用支持该文档类型的 SQL ServerSQL Server 版本。When you host these documents in a server environment, use an edition of SQL ServerSQL Server that supports that document type. 下表标识哪一 SQL ServerSQL Server 版本包含承载在这些客户端应用程序中创建的文档所需的服务器功能。The following table identifies which SQL ServerSQL Server edition contains the server features required to host the documents created in these client applications.

工具名称Tool name EnterpriseEnterprise StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services 开发人员Developer
更适用于 Power BI 报表服务器的 Power BI Desktop (.pbix) Power BI Desktop optimized for Power BI Report Server, .pbix 是,有软件保障Yes, with Software Assurance Yes
报表生成器Report Builder (.rdl 和 .rds ), .rdl and .rds Yes Yes Yes Yes Yes
SQL Server 移动报表发布服务器SQL Server Mobile Report Publisher (.rsmobile ), .rsmobile Yes Yes
用于移动设备的 Power BI 应用(iOS、Windows 10 和 Android)(.rsmobile )Power BI apps for mobile devices (iOS, Windows 10, and Android), .rsmobile Yes Yes

备注

  • 上表标识启用这些客户端工具所需的 SQL ServerSQL Server 版本。The preceding table identifies the SQL ServerSQL Server editions that are required to enable these client tools. 但是,这些工具可以访问任何 SQL ServerSQL Server 版本上承载的数据。However, these tools can access data hosted on any edition of SQL ServerSQL Server.
  • SQL Server 移动报表发布服务器SQL Server Mobile Report Publisher 是创建移动报表的单一点。is the single point for creation of mobile reports. 连接到 SSRS 服务器,以访问数据源并创建报表。Connect to an SSRS server to access data sources and create reports. 然后将其发布到 SSRS 服务器以供组织中其他人访问(在服务器上或在移动设备上)。Then publish them to the SSRS server for others in the organization to access, either on the server or on mobile devices. 你还可以独立于本地数据源使用 SQL Server 移动报表发布服务器SQL Server Mobile Report PublisherYou can also use SQL Server 移动报表发布服务器SQL Server Mobile Report Publisher stand alone with local data sources.
  • 无论使用本地的 SQL Server 2016 Reporting Services 或更高版本 (SSRS)SQL Server 2016 Reporting Services or later (SSRS) 和/或云中的 Power BIPower BI 作为报表传递解决方案,你都只需要一个移动应用便可访问移动设备上的仪表板和移动报表。Whether you use SQL Server 2016 Reporting Services 或更高版本 (SSRS)SQL Server 2016 Reporting Services or later (SSRS) on-premises, Power BIPower BI in the cloud, or both as your report delivery solution, you only need one mobile app to access dashboards and mobile reports on mobile devices. 可从 Windows、iOS 或 Android 应用商店下载 Power BIPower BI 应用。The Power BIPower BI apps are available for download from the Windows, iOS, or Android app stores.

后续步骤Next steps