SQL Server Reporting Services

THE COURSE

The course will enable delegates to design and deploy reports using Microsoft SQL Server 2005 Reporting Services. Reports will be designed using Business Intelligence Development Studio and the new Report Builder. Other topics covered include managing security, exporting reports and delivering reports to shared folders and by email. The course is aimed at people who are new to reporting services. Exercises are included to consolidate the skills taught.

WHO SHOULD ATTEND

IT professionals who need to build and deploy reports for Microsoft SQL Server 2000 or 2005.

PRE-REQUISITES
No previous knowledge of Microsoft SQL Server 2005 Reporting Services is required. A basic knowledge of database principles, Microsoft Windows and Microsoft SQL Server is required. This could be gained from our SQL Server Essentials course or through work experience.

COURSE TOPICS

Introduction to SQL Server Reporting Services

Introduction to SQL Server Reporting Services

Reporting Services Installation and Configuration

Creating and Publishing a New Report using Wizards

Introduction to Creating and Publishing a New Report Using Reporting Services Wizards
Viewing the Published Report
Setting and Reviewing Report Details

Creating Simple Reports Using Business Intelligence Development Studio

Creating Simple Reports Using Business Intelligence Development Studio
Publishing the Report

Building Expressions for Reporting Services

Building Expressions for Reporting Services

Building Advanced Reports

Building Advanced Reports Using Reporting Services

Creating Reports with Report Builder

Creating Reports with Report Builder
Using the Report Builder

Securing SQL Server Reporting Services

Securing SQL Sever Reporting Services
Creating a New User
Creating and Assigning Roles
Managing My Reports

Deploying and Managing Reports

Deploying and Managing Reports
Exporting Data
Report History
Caching Reports and Execution Snapshots
Delivering Reports to Shared Folders and Email Recipients

Monitoring SQL Server Reporting Services

Monitoring SSRS
Reporting on Reporting Services