tailieunhanh - Microsoft SQL Server 2005 Developer’s Guide- P37

Microsoft SQL Server 2005 Developer’s Guide- P37:SQL Server 2005 is a feature-rich release that provides a host of new tools and technologies for the database developer. This book is written to help database developers and DBAs become productive immediately with the new features and capabilities found in SQL Server 2005. | Chapter 9 Reporting Services 339 Extensions be deployed. You can create additional Extensions that perform operations specific to your own needs and business practices. The required Extension types are Security Extensions Data Processing Extensions Rendering Extensions Report Processing Extensions and Delivery Extensions. Security Extensions It is the Security Extension s function to authenticate users and groups to a Report Server. You can create a custom Security Extension to replace the default Security Extension but only one Security Extension can be used in each installation of Reporting Services. Windows authentication is used in the default Security Extension. Data Processing Extensions Data Processing Extensions query a data source and return a tabular result set. Reporting Services provides Data Processing Extensions for SQL Server Oracle Analysis Services OLE DB and ODBC data sources. You can also develop your own Data Processing Extensions. Reporting Services can also use any data provider. Query requests from the Report Processor are processed with the Data Processing Extensions and perform tasks such as opening a connection analyzing or running a query returning a list of field names or a rowset iterating through rows or rowsets passing parameters to a query and retrieving metadata information. Rendering Extensions Rendering Extensions do the work of transforming the retrieved data and layout information from the Report Processor into a device-specific format. Reporting Services includes seven rendering extensions HTML Rendering Extension The Report Server uses the HTML Rendering Extension to render the report when a report is requested through a Web browser. Excel Rendering Extension The Excel Rendering Extension is used to render reports that can be viewed and changed in Microsoft Excel 2000 or later. CSV Rendering Extension The Comma-Separated Value CSV Rendering Extension is used to render reports in comma-delimited plain text files. XML .