Published:
June 6, 2005
On February 24, 2005, Microsoft announced pricing and licensing information
for SQL Server 2005. In that announcement, only the Standard and
New for SQL Server 2005 will be the inclusion of Reporting Services into
editions beyond Standard and Enterprise editions. The following is a new
feature comparison for SQL Server 2005 Reporting Services:
Report Server |
|||||
Feature |
Express |
Workgroup |
Standard |
|
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 |
Management |
Report Manager |
|
|
|
Workgroup, Standard, and |
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 |
Report Builder |
|
|
|
|
|
Report Builder Data Sources |
|
Workgroup 1, 2 |
|
|
|
Model Level Security |
|
|
|
|
|
Infinite Clickthrough |
|
|
|
|
|
Reporting Services features are not yet available in SQL Server 2005 Express
Edition.
Notes: 1 = Local Server Only; 2 = Relational Only
• |
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 |
• |
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 |