Updating Your Reporting Skills to Microsoft® SQL Server™ 2005 Reporting Services

Description:
In this course, you develop and deploy scalable and secure reporting solutions for an enterprise environment by using Microsoft SQL Server Reporting Services (SSRS). You author, publish, and manage reports by using SSRS. This course is intended for database developers, database administrators, and business intelligence developers, who are experienced in Microsoft SQL SIn this course, you develop and deploy scalable and secure reporting solutions for an enterprise environment by using Microsoft SQL Server Reporting Services (SSRS). You author, publish, and manage reports by using SSRS. This course is intended for database developers, database administrators, and business intelligence developers, who are experienced in Microsoft SQL Server. This course also helps prepare you for certification exam 70-445. erver. This course also helps prepare you for certification exam 70-445. 

Objectives:
At the end of the course, students will be able to:

• Understand the features and core concepts of SSRS.
• Design a report by using Report Designer.
• Deploy and manage reports in SSRS.
• Create and work with ad hoc reports.

Modules & Lessons
Course Overview
Module Introduction
How to Use This Course
Course Information

Exploring the Features and Core Concepts of SSRS
Module Introduction

Features of SSRS
Lesson Introduction
An Overview of SSRS
Authoring Reports
Publishing and Managing Reports
Accessing Reports
Designing Ad Hoc Report Models
Building Ad Hoc Reports
Self Test

SSRS Core Concepts
Lesson Introduction
Data Sources, Datasets, Fields, and Filters
Report Items
Data Regions
Parameters
Document Maps
Self Test
Module Summary

Designing Reports Using Report Designer
Module Introduction

Designing Reports Using the Report Wizard
Lesson Introduction
Creating a Data Source
Creating a Report Using the Report Wizard
Designing a Table Report
Designing a Matrix Report
Self Test

Working with Data Regions
Lesson Introduction
Creating a Dataset
Creating a Chart Data Region
Creating a List Data Region
Interactive Sorting
Nested Data Regions and Subreports
The NoRows Property
Self Test

Lab: Designing a Report
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Deploying and Managing Reports
Module Introduction

Deploying Reports
Lesson Introduction
Deploying a Report from Visual Studio
Deploying a Report Using Scripts
Deploying a Report Using Report Manager
Self Test

Managing Reports
Lesson Introduction
Configuring Shared Data Sources
Configuring Report Properties
Configuring Subscriptions
Scheduling Report Subscriptions and Processing
Configuring Security Settings
Rendering and Viewing Reports
Self Test

Lab: Deploying and Managing a Report
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Working with Ad Hoc Reports
Module Introduction

Using Report Model Designer
Lesson Introduction
An Overview of Report Models
Creating a Report Model Project
Entities, Source Fields, and Expressions
Roles, Folders, and Perspectives
Creating a Report Model
Publishing a Report Model
Self Test

Using Report Builder
Lesson Introduction
An Overview of Report Builder
Creating an Ad Hoc Report Using Report Builder
Self Test

Lab: Creating an Ad Hoc Report
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary