United States   Change   |   All Microsoft Sites

Home - SQL Server 2005

Microsoft Home  |  Servers and Tools

Reporting Services Feature Matrix

On February 24, 2005, Microsoft announced pricing and licensing information for SQL Server 2005. In that announcement, only the Standard and Enterprise editions of SQL Server 2005 encompassed any reporting features provided by SQL Server 2005 Reporting Services. Furthermore, only the Enterprise version of SQL Server 2005 had Report Builder (ad hoc, self-service reporting). Since that time, SQL Server product management has sought and received significant feedback from both partners and customers on this decision. Because of these conversations, Microsoft is making the following modifications to its SQL Server product lineup relative to reporting.

New for SQL Server 2005 will be the inclusion of Reporting Services into editions beyond Standard and Enterprise editions.

Report Server

The following is a new feature comparison for SQL Server 2005 Reporting Services:

Feature

Express

Workgroup

Standard

Enterprise

Comments

Data Source(s)

Express  1, 2

Workgroup  1, 2

SE and EE support all data sources (OLAP and Relational)

Rendering

Excel, PDF, Image (RGDI, Print), DHTML

Excel, PDF, Image (RGDI, Print), DHTML

Standard and Enterprise editions support all output formats

Management

Report Manager

Workgroup, Standard, and Enterprise editions support SQL Server Management Studio and Report Manager

Caching

History

Delivery

Scheduling

Extensibility

Can add/remove renderers, data sources, and delivery

Custom Authentication

SharePoint Integration

Scale-out Report Servers

Subscription

Data Driven Subscription

Role Based Security

Fixed Roles

Fixed Roles

Standard and Enterprise editions can add roles

Report Builder

Report Builder Data Sources

Workgroup 1, 2

Model Level Security

Infinite Clickthrough


Notes:

  • Reporting Services features are not yet available in SQL Server 2005 Express Edition.

  • 1 = Local Server Only; 2 = Relational Only

Benefits to Customers in Recent Changes

  • Basic reporting in Express and Workgroup editions of SQL Server 2005

  • Flexibility in rendering formats in Express and Workgroup editions

  • Reporting management capabilities in all editions

  • Ad hoc, self-service reporting in Workgroup, Standard, and Enterprise editions

Benefits to Independent Software Vendors in Recent Changes

  • The ability to add value-add managed reporting to applications built on SQL Server 2005

  • Custom authentication in Reporting Services for lower SKUs

  • The ability to easily add ad hoc, self-service reporting capabilities to applications built on SQL Server 2005

  • Upgrade paths for reporting in applications built on SQL Server 2005

Technologies