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.