Pro SQL Server 2005 Reporting Services (Paperback)

SQL Server Reporting Services (SSRS) 2005 is the latest version of the reporting technology from Microsoft. This book examines all of the technology that SSRS provides to design, author, render and deploy professional business reports to the Web or to the company intranet (in a variety of formats, from HTML to XML, PDF, or TIFF), with detailed examples at every step.

It covers all of the new functionality present in the 2005 version, including the new management and BI development studios as well as the new report viewer controls and end-user reporting tools. It also contains significantly expanded chapters on Business Intelligence along with a wealth of tips and workarounds for effective development with SSRS.

The authors are both highly experienced with SQL Server and with business reporting in the medical industry, which is subject to rigorous HIPAA regulations and strict security. It is not their intention to evangelize the product or present "idealized" examples based on the simple built-in schemas. Instead, they take a hard, critical look at the technology and provide exactly what the reader needs to know to deliver effective reports. Their code examples are based on real, complex schemas and the need to deliver versatile, dynamic reports, as well as on strict security and performance requirements.

In summary, this book will provide you with step-by-step guides, best practices, and real code examples covering all of the common Reporting Services tasks, including:

• A detailed overview of the reporting architecture and tools
• The new Report Definition Language Standard, which is XML-based and allows you to define reports in VS.NET
• Building effective queries for high-performance reporting
• Building custom .NET applications with SSRS
• Rendering reports to HTML, XML, PDF and Excel
• Deploying secure reports, using Windows authentication through Active directory
• Business Intelligence reporting using SQL Server Analysis Services

描述

SQL Server Reporting Services (SSRS) 2005是微軟最新版本的報表技術。本書詳細介紹了SSRS提供的所有技術，包括設計、編寫、呈現和部署專業商業報表到網頁或公司內部網（以各種格式，從HTML到XML、PDF或TIFF），並提供了詳細的實例。

本書涵蓋了2005版本中的所有新功能，包括新的管理和BI開發工具，以及新的報表查看器控件和最終用戶報表工具。它還包含了大量擴展的商業智能章節，以及關於使用SSRS進行有效開發的許多技巧和解決方法。

作者們在SQL Server和醫療行業的商業報表方面都具有豐富的經驗，該行業受到嚴格的HIPAA法規和嚴格的安全性要求。他們的目標不是宣傳產品或基於簡單內置模式的“理想化”示例，而是對技術進行嚴格的批判性分析，並提供讀者所需的確切信息，以提供有效的報表。他們的代碼示例基於真實的複雜模式和交付多功能、動態報表的需求，以及嚴格的安全性和性能要求。

總之，本書將為您提供逐步指南、最佳實踐和真實代碼示例，涵蓋所有常見的報表服務任務，包括：

- 報表架構和工具的詳細概述
- 基於XML的新報表定義語言標準，允許您在VS.NET中定義報表
- 構建高性能報表的有效查詢
- 使用SSRS構建自定義.NET應用程序
- 將報表呈現為HTML、XML、PDF和Excel
- 通過Active Directory使用Windows身份驗證部署安全報表
- 使用SQL Server Analysis Services進行商業智能報表