Microsoft SQL Server Reporting Services (SSRS) Course

Introducing SQL Server Reporting Services

• Tour of Features

• Reporting Services Architecture

• Reporting Services Terminology

• Reporting Services Editions

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 Report

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

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