Programming Features for Reporting Services Editions
Microsoft Reporting Services ships in several different editions. This topic discusses the programmability features that are available in different editions of Reporting Services.
Error Messages for Unavailable Features
Reporting Services will return an RSNotSupported error if a call is made to a SOAP 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 sedition of Microsoft SQL Server Reporting Services.
Reporting Services will return an RSEvaluationPeriodExpired error message when an attempt is made to access 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.
Feature Restrictions by Edition
The table below lists programmability feature area support by edition.
Feature/Edition |
Express |
Workgroup |
Standard |
Enterprise |
Data Source(s) |
Express |
Workgroup |
Y |
Y |
Rendering Formats |
Excel, PDF, Image (RGDI, Print), HTML |
Excel, PDF, Image (RGDI, Print), HTML |
Y |
Y |
Management |
Report Manager |
Y |
Y |
Y |
Caching |
N |
N |
Y |
Y |
History |
N |
N |
Y |
Y |
Delivery |
N |
N |
Y |
Y |
Scheduling |
N |
N |
Y |
Y |
Extensibility |
N |
N |
Y |
Y |
Custom Authentication |
N |
Y |
Y |
Y |
Scale-out Report Servers |
N |
N |
N |
Y |
Subscriptions |
N |
N |
Y |
Y |
Data Driven Subscriptions |
N |
N |
N |
Y |
Role Based Security |
Fixed Roles |
Fixed Roles |
Y |
Y |
Report Builder |
N |
Y |
Y |
Y |
Report Models |
N |
Workgroup |
Y |
Y |
Model Level Security |
N |
N |
Y |
Y |
Infinite Clickthrough |
N |
N |
N |
Y |
Notes:
1 Local SQL Server instance only.
2 SQL Server and Analysis Services only.
Web Service API Method Availability by Edition
The following table shows the ReportExecution Web service endpoint method calls that are not available for SQL Server Express.
Method |
Restriction |
History. An exception is thrown if the HistoryID parameter is not null. |
The following table shows the Management Web service endpoint method calls that are not available in SQL Server Express.
Method |
Restriction Reason |
DataDrivenSubscriptions |
|
History |
|
CustomRolesSecurity |
|
Scheduling |
|
Subscriptions |
|
History |
|
CustomRolesSecurity |
|
Scheduling |
|
Subscriptions |
|
GetDataDrivenSubscriptionProperties |
DataDrivenSubscriptions |
ExecutionSnapshots and Scheduling. An exception is thrown if the ExecutionSetting parameter is not equal to ExecutionSettingEnum.Live, and if the Schedule parameter is not null. |
|
History |
|
History and Scheduling. An exception is thrown if the Schedule parameter is not null. |
|
History An exception is thrown if the HistoryID parameter is not null. |
|
Scheduling |
|
Subscriptions |
|
History |
|
Scheduling |
|
Scheduling |
|
Subscriptions |
|
ListSubscriptionsUsingDataSource |
|
Scheduling |
|
Scheduling |
|
Caching |
|
DataDrivenSubscriptions |
|
ExecutionSnapshots and Scheduling. An exception is thrown if the ExecutionSetting parameter is not equal to ExecutionSettingEnum.Live, and if the Schedule parameter is not null. |
|
History |
|
History and Scheduling. An exception is thrown if the Schedule parameter is not null. |
|
CustomRolesSecurity |
|
Scheduling |
|
Subscriptions |
|
ExecutionSnapshots |
Vedere anche
Altre risorse
Reporting Services in SQL Server 2005 Express Edition with Advanced Services
Funzionalità supportate dalle edizioni di SQL Server 2005
Funzionalità di Reporting Services
Report Server Web Service Features