Microsoft SQL Server 2008 Reporting Services

by Larson, Brian

• ISBN13: 9780071548083
• ISBN10: 0071548084
• Edition: 3rd
• Format: Paperback
• Copyright: 2008-09-11
• Publisher: McGraw-Hill Education

Summary

The Definitive Guide to Microsoft SQL Server 2008 Reporting ServicesCreate and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities. Install, configure, and customize SQL Server 2008 Reporting Services Create SELECT queries to extract data Generate reports from the Report Wizard and from scratch Add charts, images, and gauges Build reusable report templates Use the new Tablix data format to create reports with any structure Export reports to Word, Excel, PDF, HTML, XML, and other formats Enable end-user access to reports via the Report Server and its Report Manager web interface

Author Biography

Brian Larson, MCSD, served as an original member of the Reporting Services development team and contributed to the code base. He is the chief of technology for Superior Consulting Services (SCS), a Microsoft Certified Partner.

Table of Contents

Getting Started

Let's Start at the Very Beginning

Putting the Pieces in Place: Installing Reporting Services

Report Authoring

DB 101: Database Basics

A Visit to Emerald City: The Report Wizard

Removing the Training Wheels: Building Basic Reports

Graphic Expression: Using Charts, Images, and Gauges

Kicking It Up a Notch: Intermediate Reporting

Beyond Wow: Advanced Reporting

A Leading Exporter: Exporting Reports to Other Rendering Formats

Report Serving

How Did We Ever Manage Without You? The Report Manager

Delivering the Goods: Report Delivery

Extending Outside the Box: Customizing Reporting Services

Appendixes

Report Item Reference

Web Service Interface Reference

Ad Hoc Reporting

Index

Table of Contents provided by Publisher. All Rights Reserved.