Synopses & Reviews
SQL Server Reporting Services 2005 is the latest version of the reporting technology from Microsoft, providing the means to design, author, render, and deploy business reports to users, customers, and employees, via the web or the company intranet. The reporting engine is built in to the SQL Server 2005 database (and provided as a free add-on with SQL Server 2000) and the report manager is integrated with Visual Studio 2003, providing an effective and familiar environment for all SQL Server and .NET developers.
The book was written in parallel with a migration project, moving some 200 professional healthcare reports from various reporting architectures to SQL Server Reporting Services, and so is steeped in the day-to-day challenges, discoveries, and successes involved in delivering a successful reporting solution with this technology. In this book, you will find step-by-step guides, best practices, and real code examples that cover all of the common Reporting Services tasks.
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
Table of Contents
Report Server Architecture and Overview - RL.- Report Authoring - Best Practices - RL.- The Reporting Environment - RL.- Building Report Examples - RL.- Using Custom .Net Code with Reports - JV.- Rendering Reports - JV.- Deploying Reports - JV.- Reports Management, auditing and execution - RL.- Report Security - RL.- SRS and Analysis Services.- SRS and Sharepoint.- Customizing SRS.- SRS Design and Development: Fast Answers.