Programming Features for Reporting Services Editions
This topic discusses the programmability features that are available in different editions of Reporting Services.
Feature Restrictions by Edition
Web Service API Method Availability
Feature Restrictions by Edition
The table below lists programmability feature area support by edition.
Feature/Edition |
Express with Advanced Services |
Workgroup |
Web |
Standard |
Standard for Small Business |
Enterprise |
Datacenter |
Developer |
Evaluation |
SQL Server Data Sources |
Express1 |
Workgroup1 |
Web1 |
All |
All |
All |
All |
All |
All |
Remote and Non-SQL Server Data Sources |
N |
N |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Rendering Formats |
HTML40, Image, RGDI, Excel, PDF, RPL, Word, ROM |
HTML40, Image, RGDI, Excel, PDF, RPL, Word, ROM |
HTML40, Image, RGDI, Excel, PDF, RPL, Word, ROM |
All |
All |
All |
All |
All |
All |
Report Manager |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
History, Snapshots, and Caching |
N |
N |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Delivery |
N |
N |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Scheduling |
N |
N |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Extensibility |
N |
N |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Subscriptions |
N |
N |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Data-driven Subscriptions |
N |
N |
N |
N |
N |
Y |
Y |
Y |
Y |
Custom Authentication |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
SharePoint Integration |
N |
N |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Scale-out Report Servers |
N |
N |
N |
N |
N |
Y |
Y |
Y |
Y |
Role Based Security |
Built-in Roles |
Built-in Roles |
Built-in Roles |
Built-in and Custom Roles |
Built-in and Custom Roles |
Built-in and Custom Roles |
Built-in and Custom Roles |
Built-in and Custom Roles |
Built-in and Custom Roles |
Reports as Data Feeds |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Report Part Gallary |
N |
N |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Shared Datasets |
N |
N |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Report Designer |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Report Models |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Y |
Model Level Security |
N |
N |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Infinite Clickthrough |
N |
N |
N |
Y |
Y |
Y |
Y |
Y |
Y |
Notes:
1 Local SQL Server instance only.
Web Service API Method Availability
Check the supported features before you use the Web service endpoints available in SQL Server Reporting Services. Whether Web service endpoints or a specific endpoint method call is available for an edition depends on whether the related feature is available in that edition. For example, since data-driven subscriptions are not supported in the Workgroup edition, calling the CreateDataDrivenSubscription endpoint method is also not supported.
Reporting Services will return an RSNotSupported error if a call is made to a Web service endpoint method that uses a feature that is not supported in the currently installed edition of Reporting Services. The text of this error message is:
This feature is unavailable in this edition of Microsoft SQL Server Reporting Services.
Reporting Services will return an RSEvaluationPeriodExpired error message if a call is made to a Web service endpoint method in an expired evaluation edition of Reporting Services. The text of this error message is:
The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired. A license is now required.