| Day One |
| 8:30 a.m. - 10:00 a.m. |
Introducing SQL Server Reporting Services |
| |
Tour of Features |
| |
Reporting Services Architecture |
| |
Reporting Services Terminology |
| |
Reporting Services Editions |
| |
Taking Reporting Services for a Spin |
| 09:30 a.m. - 11:00 a.m. |
Creating Reports |
| |
Deconstructing Reporting Services |
| |
Shared Data Sources |
| |
Creating Reports from Scratch |
| 11:00 a.m. - 12:00 p.m. |
Calculations and Formatting |
| |
Creating Expressions |
| |
Using the Global Collections |
| |
Formatting Items |
| |
Conditional Formatting |
| 1:00 p.m. - 3:00 p.m. |
Grouping and Sorting |
| |
Creating Groups |
| |
Calculating Totals and Percentages |
| |
Interactive Sorting |
| |
Creating Drill-Down Reports |
| 3:15 p.m. - 4:15 p.m. |
Report Parameters |
| |
Creating Report Parameters |
| |
Creating Drop-Down Parameters |
| |
Multi-Valued Parameters |
| |
Debugging Parameter Issues |
| 4:15 p.m. - 5:00 p.m. |
Creating Matrix Reports and Charts |
| |
Creating a Basic Matrix Report |
| |
Matrix Subtotals |
| |
Creating a Basic Chart |
| |
Exploring the Charting Possibilities |
| Day Two |
| 8:30 a.m. - 9:30 a.m. |
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 |
| 9:30 a.m. - 11:00 a.m. |
Reporting Services Security |
| |
Two Parts to Reporting Services Security |
| |
Securing Access to Reports |
| |
Data Source Security |
| 11:00 a.m. - 12:00 p.m. |
Programming Reporting Services |
| |
The Many Reporting Services APIs |
| |
Integrating Reporting Services into Applications using URL Access |
| |
Using the Report Viewer Controls |
| 1:00 pm - 3:00 p.m. |
Advanced Reporting Services Programming |
| |
Using the Reporting Services Web Service |
| |
Working with Custom Assemblies |
| 3:15 pm - 4:00 p.m. |
Snapshots and Subscriptions |
| |
Caching and Snapshots |
| |
Creating Standard Subscriptions |
| |
Creating Data-Driven Subscriptions |
| |
Managing Subscriptions |
| 4:00 pm - 5:30 p.m. |
Ad-Hoc Reporting with Report Builder |
| |
The Report Builder Architecture |
| |
Creating Report Model Projects |
| |
Running Report Builder |
Training 
