Pro SQL Server 2005 Reporting Services

This book was written in parallel with a real SSRS deployment for a health-care application, so it covers almost every design and deployment consideration for SSRS, always from the stand-point of how to get the job done effectively. You’ll find step-by-step guides, practical tips, and best practices, along with code samples that you’ll be able to modify and use in your own SSRS applications. At its core, the process of designing reports hasn’t changed substantially in the past 15 years. The report designer lays out report objects, which contain data from a known data source, in a design application such as Crystal Reports or MS Access. He or she then tests report execution, verifies the accuracy of the results, and distributes the report to the target audience. Sure, there are enough differences between design applications to mean that the designer must become familiar with each particular environment. However, there’s enough crossover functionality to make this learning curve small. For example, the SUMfunction is the same in Crystal Reports as it is in MS Access as it is in Structured Query Language (SQL). With MS SQL Server 2005 Reporting Services (referred to as SSRS throughout the book), there is, again, only a marginal difference in the way reports are designed from one graphical report design application to another. So, if you do have previous reporting experience, your learning curve for SSRS should be relatively shallow. This is especially true if you come from a .NET environment, because the report designer application for SSRS is Visual Studio 2005 or the application included with SQL Server 2005, Business Intelligence Development Studio (BIDS). TABLE OF CONTENT: Chapter 1 Introducing the Reporting Services Architecture Chapter 2 Report Authoring - Designing Efficient Queries Chapter 3 Using Report Designer Chapter 4 Building Reports Chapter 5 Using Custom .NET Code with Reports Chapter 6 Rendering Reports from .NET Applications Chapter 7 Deploying Reports Chapter 8 Managing Reports Chapter 9 Securing Reports Chapter 10 Delivering Business Intelligence with SSRS Chapter 11 Performing Ad Hoc Reporting Using Report Builder Download Here Password: ganelon