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
LoadReport	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
CreateDataDrivenSubscription	DataDrivenSubscriptions
CreateReportHistorySnapshot	History
CreateRole	CustomRolesSecurity
CreateSchedule	Scheduling
CreateSubscription	Subscriptions
DeleteReportHistorySnapshot	History
DeleteRole	CustomRolesSecurity
DeleteSchedule	Scheduling
DeleteSubscription	Subscriptions
GetDataDrivenSubscriptionProperties	DataDrivenSubscriptions
GetExecutionOptions	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.
GetReportHistoryLimit	History
GetReportHistoryOptions	History and Scheduling. An exception is thrown if the Schedule parameter is not null.
GetReportParameters	History An exception is thrown if the HistoryID parameter is not null.
GetScheduleProperties	Scheduling
GetSubscriptionProperties	Subscriptions
ListReportHistory	History
ListScheduledReports	Scheduling
ListSchedules	Scheduling
ListSubscriptions	Subscriptions
ListSubscriptionsUsingDataSource	ListSubscriptionsUsingDataSource
PauseSchedule	Scheduling
ResumeSchedule	Scheduling
SetCacheOptions	Caching
SetDataDrivenSubscriptionProperties	DataDrivenSubscriptions
SetExecutionOptions	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.
SetReportHistoryLimit	History
SetReportHistoryOptions	History and Scheduling. An exception is thrown if the Schedule parameter is not null.
SetRoleProperties	CustomRolesSecurity
SetScheduleProperties	Scheduling
SetSubscriptionProperties	Subscriptions
UpdateReportExecutionSnapshot	ExecutionSnapshots

See Also

Other Resources

Reporting Services in SQL Server 2005 Express Edition with Advanced Services
Features Supported by the Editions of SQL Server 2005
Reporting Services Features
Report Server Web Service Features

Help and Information

Getting SQL Server 2005 Assistance