Microsoft Sql Server 2008 Reporting Services Unleashed

by Lisin, Michael; Joseph, Jim; Goyal, Amit

• ISBN13: 9780672330261
• ISBN10: 0672330261
• Edition: 1st
• Format: Paperback
• Copyright: 2009-07-23
• Publisher: Sams Publishing

Summary

Using Microsoft SQL Server 2008 Reporting Services, organizations can quickly deliver relevant information wherever it's needed, across the entire enterprise, and through the entire reporting lifecycle.SQL Server 2008 Reporting Services Unleashedgives database professionals, managers, and users all the authoritative information they need to make the most of Microsoft's reporting platform. This book's in-depth coverage makes it an ideal reference, while its extensive collection of practical examples will help you successfully address virtually any issue in deployment, configuration, administration, or report-building. The authors, who include the lead program manager on the Reporting Services team, highlight and illuminate all of Reporting Services 2008's new features and capabilities, including the product's significant architectural changes; the flexible new Tablix data format; improved visualization through charts and gauges; deep SharePoint integration through SharePoint Integrated Mode; and much more.

Author Biography

Michael Lisin has been in the software industry for more than 17 years, with 10 of those years working with Microsoft. Most of his career, Michael has been consulting on SQL Server and business intelligence solutions for Microsoft’s enterprise customers. He has worked with SQL Server Reporting Services since the product’s first pre-beta version in 2002 and has taught Reporting Services classes and presented topics related to SQL Server at various events. Michael earned his MBA at Texas A&M University in 2006 and continues to be a dedicated scholar of Reporting Services. He is now working with business development for Microsoft.

 

Jim Joseph is an independent contractor with 10 years of experience developing custom software solutions in a variety of industries. He has worked with SQL Server Reporting Services since the first beta release in 2000. He earned his MBA from the University of St. Thomas in 2002. He has worked in a number of roles from developer to database administrator.

 

Amit Goyal is a senior lead manager for the SQL Server Reporting Services team at Microsoft. Before joining Microsoft, Amit was a director at Yahoo! and worked on development of the Panama search monetization platform. He has 14 years of industry experience at high-tech companies such as Microsoft, Yahoo!, Oracle, and Broadbase Software.He earned his bachelor of science degree from UIUC (University of Illinois at Urbana Champaign) and master’s degree from Stanford University.

Table of Contents

Introduction to Reporting Services

Introduction to SQL Server Reporting Services

Reporting Services 2008 Architecture

Getting Started with Reporting Services Tools

What's New in SSRS 2008

Reporting Services Deployment Scenarios

Installing Reporting Services

Report Authoring from Basic to Advanced

Report Wizard

Report Designer(s)

RDL

Expressions

Accessing Data

Report Parameters

Working with Report Items

Grouping, Sorting, and Aggregating Data, Working with Scope

Advanced Report Formatting

Report Navigation

Working with Multi-Dimensional Data Sources

AdHoc Reporting

Report Management

Deploying Reports

Securing Reports

Managing Reports

Report Execution and Processing

Report Caching

Report Snapshots

Report Rendering Document Formats

Subscriptions

Configuring SSRS

Key Management

Monitoring

Security (including Kerberos)

Availability

Performance

Scalability

Reporting Services Customizations

Implementing Custom Embedded Functions

How to Create and Call a Custom Assembly from a Report

How to Use URL Access

How to Use Reporting Services Web Services

Writing Custom Reporting Services Extensions

Deployment, Security

SharePoint Controls

Report Definition Customization

RDL Token Replacement

SharePoint Integration

Introduction to SharePoint Technology

SharePoint with Reports

Architecture of SharePoint Integration

Reporting Services Tools in SharePoint Mode

Installing Reporting Services in SharePoint Mode

SharePoint WebParts

URL Access Parameters

Using Report Builder in SharePoint

Reports Administration

Server Administration

Security

Programmability

Appendices

Table of Contents provided by Publisher. All Rights Reserved.