You are previewing Pro SQL Server 2008 Reporting Services.
O'Reilly logo
Pro SQL Server 2008 Reporting Services

Book Description

Take full advantage of everything SQL Server 2008 Reporting Services has to offer and deliver customizable, web–enabled reports across your business at a reasonable cost. Learn best–practices from professionals who use SQL Server Reporting Services daily to deliver solutions to paying clients and gain the competitive edge on using Microsoft's enterprise–level reporting platform.

  • Provides best–practices for using Reporting Services

  • Written by practicing professionals with paying clients

  • Your key to delivering business intelligence across the enterprise

Table of Contents

  1. Title Page
  2. Dedication
  3. Contents at a Glance
  4. Contents
  5. About the Authors
  6. About the Technical Reviewer
  7. Acknowledgments
  8. Introduction
    1. What This Book Covers
    2. Who This Book Is For
    3. Source Code
  9. CHAPTER 1: Introducing the Reporting Services Architecture
    1. Understanding the Benefits of SSRS
    2. Exploring the SSRS Architecture
    3. Installing and Configuring
    4. Deploying SSRS Securely
    5. Summary
  10. CHAPTER 2: Report Authoring: Designing Efficient Queries
    1. Introducing the Sample Relational Database
    2. Introducing Query Design Basics
    3. Using a Parameterized Stored Procedure
    4. Summary
  11. CHAPTER 3: Introduction to Reporting Services Design
    1. Exploring the Elements of BIDS
    2. Laying Out a Report
    3. Summary
  12. CHAPTER 4: Building Reports
    1. Creating a Report with the Report Wizard
    2. Building Reports from Scratch
    3. Setting Report Parameters with Stored Procedures
    4. Working with Multivalued Parameters
    5. Adding Tablix Elements
    6. Report and Group Variables
    7. Adding the New Gauge Control
    8. Adding the Final Touches
    9. Summary
  13. CHAPTER 5: Using Custom .NET Code with Reports
    1. Using Embedded Code in Your Report
    2. Using Custom Assemblies with Your Report
    3. Summary
  14. CHAPTER 6: Rendering Reports from .NET Applications
    1. Implementing URL Access
    2. Integrating SSRS 2008 with .NET Applications
    3. Summary
  15. CHAPTER 7: Deploying Reports
    1. Using Report Manager
    2. Using Report Builder 2.0
    3. Using BIDS and Visual Studio 2008
    4. Using the rs.exe Utility
    5. Using the Report Server Web Service
    6. Summary
  16. CHAPTER 8: Managing Reports
    1. Exploring Management Roles in SSRS Deployment
    2. Managing Content
    3. Performing Execution Auditing and Performance Analysis
    4. Controlling SSRS Programmatically
    5. Summary
  17. CHAPTER 9: Securing Reports
    1. Encrypting Data
    2. Setting Up Authentication and User Access to Data
    3. Auditing Reports
    4. Exploring Deployment Models
    5. Summary
  18. CHAPTER 10: Delivering Business Intelligence with SSRS
    1. Building SSRS Reports for SQL Analysis Services
    2. Incorporating SSRS with Microsoft Office SharePoint Services 2007
    3. Summary
  19. CHAPTER 11: Creating Reports Using Report Builder 1.0 and 2.0
    1. Getting User Feedback
    2. Introducing the Report Model
    3. Creating Reports with Report Builder 1.0
    4. Creating Reports with Report Builder 2.0
    5. Summary
  20. Index