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