In SQL Server 2005 Reporting Services, the report author can add the ability for the viewer of a published report to resort the data within their report.
SQL Server 2005 Reporting Services enables Independent Software Vendors (ISVs) and developers to extend report processing through the creation of custom report items. Custom report items are server controls that can be embedded in reports to provide additional functionality beyond the built-in Reporting Services controls (textbox, line, image, etc.). For example, a developer could add gauges, barcodes, maps, etc. In the Report Designer, these controls are added to the Visual Studio Toolbox and have their own set of property pages and dialog boxes. An example of a customer report item, “GaugeContainer,” can be seen in Figure 4.
SQL Server 2005 Reporting Services (SSRS) is a robust reporting solution that runs on Microsoft Internet Information Services (IIS) on Microsoft Windows® XP, Windows 2000, and Windows Server™ 2003. It works with data that resides on the SQL Server 2005 platform, as well as other data sources. SSRS can deliver reports in a variety of formats. The reports can be delivered on paper or through interactive Web-based reports.