O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft SQL Server 2005 Reporting Services, 2nd Edition

Book Description

Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.

Table of Contents

  1. Copyright
  2. Dedication
  3. About the Author
  4. Foreword
  5. Acknowledgments
  6. Introduction
  7. Getting Started
    1. Let's Start at the Very Beginning
      1. Sharing Business Intelligence
      2. Report Authoring Architecture
      3. Report Serving Architecture
      4. Diving In
    2. Putting the Pieces in Place: Installing Reporting Services
      1. Preparing for the Installation
      2. The Installation Process
      3. Common Installation Issues
      4. Spending Some Time in Basic Training
  8. Report Authoring
    1. DB 101: Database Basics
      1. Database Structure
      2. Galactic Delivery Services
      3. Querying Data
      4. On to the Reports
    2. A Visit to Emerald City: The Report Wizard
      1. Your First Report
      2. An Interactive Table Report
      3. Creating Matrix Reports
      4. Report Parameters
      5. Flying Solo
    3. Removing the Training Wheels: Building Basic Reports
      1. Riding Down Familiar Roads
      2. Data Regions
      3. New Territory
      4. Getting Graphical
    4. Graphic Expression: Using Charts and Images in Reports
      1. Chart Your Course
      2. Image Is Everything
      3. Building Higher
    5. Kicking It Up a Notch: Intermediate Reporting
      1. Never Having to Say "I'm Sorry"
      2. Handling Errors in Reports
      3. Data Caching During Preview
      4. Under the Hood
      5. Practicing Safe Source
      6. Advance, Never Retreat
    6. Beyond Wow: Advanced Reporting
      1. Speaking in Code
      2. Reports Within Reports
      3. Interacting with Reports
      4. A Conversion Experience
      5. What's Next
    7. A Leading Exporter: Exporting Reports to Other Rendering Formats
      1. A Report in Any Other Format Would Look as Good
      2. Presentation Formats
      3. Data Exchange Formats
      4. Call the Manager
  9. Report Serving
    1. How Did We Ever Manage Without You? The Report Manager
      1. Folders
      2. Moving Reports and Supporting Files to the Report Server
      3. Managing Items in Folders
      4. Seek and Ye Shall Find: Search and Find Functions
      5. Printing from Report Manager
      6. Managing Reports on the Report Server
      7. Linked Reports
      8. Delivering the Goods
    2. Delivering the Goods: Report Delivery
      1. Caching In
      2. Execution Snapshots
      3. Report History
      4. Subscriptions
      5. Site Settings
      6. A Sense of Style
      7. Building On
    3. Extending Outside the Box: Customizing Reporting Services
      1. Using Reporting Services Without the Report Manager
      2. Custom Security
      3. Best Practices
      4. Where Do We Go from Here?
  10. Appendixes
    1. Report Item Reference
      1. Report Objects
      2. Property Reference
    2. Web Service Interface Reference
      1. Reporting Services Web Service
    3. Report Definition Language Reference
      1. Report Definition Language
    4. Ad Hoc Reporting
      1. The Report Model
      2. Creating Reports with the Report Builder
      3. Give It a Try