Course Description | Outline | SQL Server Training | IT Training

Module 1: Introduction to Microsoft SQL Server Reporting Services

* Overview of SQL Server Reporting Services
* Installing Reporting Services
* Reporting Services Tools

Lab : Introduction to Microsoft SQL Server Reporting Services

* Exploring Report Designer
* Exploring Report Manager

Module 2: Authoring Basic Reports

* Creating a Basic Table Report
* Formatting Report Pages
* Calculating Values

Lab : Authoring Basic Reports

* Creating a Basic Table Report
* Formatting Report Pages
* Adding Calculated Values

Module 3: Enhancing Basic Reports

* Interactive Navigation
* Displaying Data

Lab : Enhancing Basic Reports

* Using Dynamic Visibility
* Using Document Maps
* Initiating Actions
* Using a List Data Region
* Creating a Tablix Report
* Adding Chart Subreport to Parent Report

Module 4: Manipulating Data Sets

* Defining Report Data
* Using Parameters and Filters
* Using Parameter Lists

Lab : Manipulating Data Sets

* Using Parameters to Restrict Query Results
* Using Parameters to Filter Report Data
* Creating Dynamic Parameter Lists
* Using Parameters with a Stored Procedure
* Displaying All Categories in a Parameter List

Module 5: Using Report Models

* Creating Report Models
* Using Report Builder

Lab : Using Report Models

* Creating a Report Model
* Using Report Builder to Create a Report

Module 6: Publishing and Executing Reports

* Publishing Reports
* Executing Reports
* Creating Cached Instances
* Creating Snapshots and Report History

Lab : Publishing and Executing Reports

* Publishing Reports
* Executing Reports
* Configuring and Viewing a Cached Report
* Configuring and Viewing a Snapshot Report

Module 7: Using Subscriptions to Distribute Reports

* Introduction to Report Subscriptions
* Creating Report Subscriptions
* Managing Report Subscriptions

Lab : Using Subscriptions to Distribute Reports

* Creating a Standard Subscription
* Creating a Data-Driven Subscription

Module 8: Administering Reporting Services

* Reporting Server Administration
* Performance and Reliability Monitoring
* Administering Report Server Databases
* Security Administration
* Upgrading to Reporting Services 2008

Lab : Administering Reporting Services

* Using Reporting Services Configuration Manager
* Securing a Reporting Services Site
* Securing Items

Module 9: Programming Reporting Services

* Querying for Server Information Using a Web Service
* Automating Report Management
* Rendering Reports
* Creating Custom Code

Lab : Programming Reporting Services

* Using URL Access to Display a Report
* Building a Reporting Services Web Service Client
* Using the Report Viewer Control