Learning Objectives

• 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 is helpful but not required.
• Knowledge of Visual Studio .NET/2005 is helpful but not required.
• Knowledge of C# or VB is helpful but 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 reporting 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

Working with Parameters

• Creating Report Parameters
• Creating Drop-Down Parameters
• Multi-Valued Parameters
• Debugging Parameter Issues

Creating Matrix Reports and Charts

• Creating a Matrix Report
• Accessing Your Matrix Reports
• Creating a Chart
• Exploring the Charting Possibilities

Managing Reporting Services

• Deploying Reporting Services Projects
• Exporting Reports and Printing
• Managing Reports with the Browser Based Report Manager
• Using SQL Server Management Studio-based Reporting Services Manager

Security

• Reporting Services Security
• Securing Access to Reports
• Reporting Services Virtual Directory Security
• Data Source Security

Programming Reporting Services

• The Many Reporting Services APIs
• URL Access
• Using the Report Viewer Controls
• Using the Report Viewer Control with Client Reports

Advanced Reporting Services Programming

• Using the Reporting Services Web Service
• Working with Custom Assemblies

Snapshots and Subscriptions

• Report Caching and Snapshots
• Creating Subscriptions
• Creating Data-Driven Subscriptions

Ad-Hoc Reporting with Report Builder

• The Report Builder Architecture
• Creating Report Model Projects
• Running Report Builder