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

  • Error Messages for Unavailable Features

Feature Restrictions by Edition

The table below lists programmability feature area support by edition.

Feature/Edition

Express

Workgroup

Standard

Enterprise

Data Source(s)

Express1

Workgroup12

Y

Y

Rendering Formats

Excel, PDF, Image (RGDI, Print), HTML, Word

Excel, PDF, Image (RGDI, Print), HTML, Word

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

Workgroup12

Y

Y

Model Level Security

N

N

Y

Y

Infinite Clickthrough

N

N

N

Y

Notes:

1 Local SQL Server instance only.

2SQL Server and Analysis Services only.

Web Service API Method Availability by Edition

The following table shows the execution Web service endpoint method calls that are not available for SQL Server Express.

Method

Restriction

LoadReport

LoadReport2

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

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 edition 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.