SSRS: SQL Server Reporting Services Course Content
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
