Share via


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