SQL Server 2005 Reporting Services

In this course, you will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You'll gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. You'll also discover how to integrate reports into your ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you'll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects.

In this course, you will learn to:

• Create complex reports employing expressions, the global collections, and conditional formatting.
• Create reports with nested groups and multiple parameters.
• Manage reports using both the browser-based Report Manager and SQL Server Management Studio-based Report Manager.
• Secure reports using integrated security and SSL.
• Program reports using URL Access, the Reporting Services Web Service API, the Report Viewer controls, and custom assemblies.
• Employ report caching and create report snapshots.
• Create standard and data-driven report subscriptions.
• Empower users to create ad-hoc reports using Report Builder and the models you create using Report Model projects.

Prerequisites:

• Familiarity with databases and the SQL language.
• Knowledge of SQL Server helpful but not required.
• Knowledge of Visual Studio .NET/2005 helpful but not required.
• Knowledge of C# or VB helpful but also not required.

Introducing SQL Server Reporting Services

Tour of Features

Reporting Services Architecture

Reporting Services Terminology

Reporting Services Editions

Taking Reporting Services for a Spin

Creating Reports

Deconstructing Reporting Services

Shared Data Sources

Creating Reports from Scratch

Calculations and Formatting

Creating Expressions

Using the Global Collections

Formatting Items

Conditional Formatting

Grouping and Sorting

Creating Groups

Calculating Totals and Percentages

Interactive Sorting

Creating Drill-Down Reports

Report Parameters

Creating Report Parameters

Creating Drop-Down Parameters

Multi-Valued Parameters

Debugging Parameter Issues

Creating Matrix Reports and Charts

Creating a Basic Matrix Report

Matrix Subtotals

Creating a Basic Chart

Exploring the Charting Possibilities

Managing Reporting Services

Deploying Reports and Data Sources

Exporting Reports and Printing

Using the Web-Based Report Manager

Using SQL Server Management Studio-based Reporting Services Manager

Reporting Services Security

Two Parts to Reporting Services Security

Securing Access to Reports

Data Source Security

Programming Reporting Services

The Many Reporting Services APIs

Integrating Reporting Services into Applications using URL Access

Using the Report Viewer Controls

Advanced Reporting Services Programming

Using the Reporting Services Web Service

Working with Custom Assemblies

Snapshots and Subscriptions

Caching and Snapshots

Creating Standard Subscriptions

Creating Data-Driven Subscriptions

Managing Subscriptions

Ad-Hoc Reporting with Report Builder

The Report Builder Architecture

Creating Report Model Projects

Running Report Builder

---

Your Instructor

Paul Litwin is a developer specializing in ASP, ASP.NET, Visual Basic, C#, SQL Server, and related technologies. Paul is a programming manager with Fred Hutchinson Cancer Research Center in Seattle. He is also the owner of Deep Training, a developer owned training company specializing in .NET developer training (www.deeptraining.com). Paul has authored a number of books including ASP.NET for Developers (SAMS) and Access 2002 Enterprise Developer’s Handbook (SYBEX) and has written articles in a variety of magazines, including MSDN Magazine and PC World. Paul is the conference chair of Microsoft ASP.NET Connections, a Microsoft MVP, and a member of the INETA Speakers Bureau.