At least some components of SSRS are available in almost all editions of SQL Server 2005: Workgroup, Standard, Enterprise, Developer, and Evaluation. Note The Reporting Services install is now bundled with SQL Server Install. This is unlike Reporting Services 2000, which has an independent setup . At the time of writing, SQL Server Express Edition did not have a version of SSRS. SQL Server Express Edition may eventually include an Express Edition of SSRS . Whether a customer is a large enterprise or a small company, the key features of Reporting Services that are always available include the following: -
Manageability Reporting Services is easy to deploy and manage. In addition to having a convenient web-based management interface, both deployment and management of Reporting Services can be scripted. -
Security Reporting Services keeps corporate data secure. Reports and information are not accessible, unless sufficient privilege is granted to a user . -
Programmability Reporting Services allows developing of a custom functionality that can be embedded in a report, called from a report, or scripted. -
Reporting controls and wizard Windows and web-based Report Viewer controls are supplied with Visual Studio 2005. Report controls simplify adding reporting functionality to Windows and web-based applications. Additional features available in the Standard Edition of Reporting Services include the following: -
Extensibility Reporting Services allows adding new server functionality. Report Definition Language (RDL) is an XML-based language and is designed to be extensible. SSRS also allows extending data processing, rendering, and delivery extensions. Additional features available in Enterprise Edition of Reporting Services include the following: -
Scalability Reporting Services Enterprise Edition supports large workloads and high-volume reporting. Support for web farms in Enterprise Edition allows easy scale out, providing an ability to add extra capacity as needed. In addition, Enterprise Edition scales up, supporting more than two CPUs. -
Availability Web farm support of Reporting Services Enterprise Edition paired with the Reporting Services catalog installed on a SQL Server 2005 cluster enables high-availability reporting solutions. -
Data-driven subscriptions Reporting Services Enterprise Edition allows customers to dynamically change the recipient list, report parameters, and processing options. In contrast, Standard Subscription, available in Standard Edition of Reporting Services, is for a single predefined user and single predefined parameter set. To help determine the most appropriate version, you can refer to Table 4.7 to review key features of SSRS editions Table 4.7. Key Features by Reporting Services Editions Feature | Workgroup | Standard | Enterprise | Data Source(s) | Local Server and relational only | Support all data sources (OLAP and Relational) | Rendering | Excel, PDF, Image (RGDI, Print), DHTML | Support all ouput formats | Management | Support SQL Server Management Studio and Report Manager | Caching | | Supported | History | | Supported | Delivery | | Supported | Scheduling | | Supported | Extensibility | | Can add/remove renders , data sources, and delivery | Custom Authentication | | Supported | SharePoint Integration | | Supported | Scale-out Report Servers | | | Supported | Subscription | | Supported | Data-Driven Subscription | | | Supported | Role-Based Security | Fixed Roles | Can add roles | Report Builder | Supported | Report Builder Data Sources | Local server and relational only | Supported | Model level Security | Yes | Infinite Clickthrough | Yes | Source: http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx | Note Developer and Evaluation editions have the same capabilities as the Enterprise Edition of SSRS. However, the Developer Edition is only licensed and supported in the development environment and Evaluation Edition expires after 180 days . |