Module 1: Introduction to Microsoft SQL Server Reporting Services
- Overview of SQL Server Reporting Services
- Installing Reporting Services
- Reporting Services Tools
Module 2: Authoring Basic Reports
- Creating a Basic Table Report
- Formatting Report Pages
- Calculating Values
Module 3: Enhancing Basic Reports
- Interactive Navigation
- Displaying Data
Module 4: Manipulating Data Sets
- Defining Report Data
- Using Parameters and Filters
- Using Parameter Lists
Module 5: Using Report Models
- Creating Report Models
- Using Report Builder
Module 6: Publishing and Executing Reports
- Publishing Reports
- Executing Reports
- Creating Cached Instances
- Creating Snapshots and Report History
Module 7: Using Subscriptions to Distribute Reports
- Introduction to Report Subscriptions
- Creating Report Subscriptions
- Managing Report Subscriptions
Module 8: Administering Reporting Services
- Reporting Server Administration
- Performance and Reliability Monitoring
- Administering Report Server Databases
- Security Administration
- Upgrading to Reporting Services 2008
Module 9: Programming Reporting Services
- Querying for Server Information Using a Web Service
- Automating Report Management
- Rendering Reports
- Creating Custom Code
Labs
- Lab 1: Introduction to Microsoft SQL Server Reporting Services
- Lab 2: Authoring Basic Reports
- Lab 3: Enhancing Basic Reports
- Lab 4: Manipulating Data Sets
- Lab 5: Using Report Models
- Lab 6: Publishing and Executing Reports
- Lab 7: Using Subscriptions to Distribute Reports
- Lab 8: Administering Reporting Services
- Lab 9: Programming Reporting Services