Microsoft SQL Server 2008 Reporting Services

Audience

This course is intended for students who need to learn how to implement a Reporting Services solution. Attendees will learn how to use the Reporting Services development tools to create reports, and additionally how to use the Reporting Services management and administrative tools. Concise coverage of the subject matter is augmented with plenty of hands-on exercises to facilitate the learning process and to enable students to quickly gain confidence in using Reporting Services.

Prerequisites

Delegates should have: - An understanding of working in a Microsoft Windows operating system environment. - Some experience working with relational databases. - Knowledge gained from taking the 2 day course ‘Microsoft SQL Server 2008 Introduction to Querying’ or equivalent SQL language experience.

Duration

3 days. Hands on.

Course Objectives

Upon successful completion of this course, students will be able to:

• Understand where SQL Server Reporting Services fits in with the Business Intelligence paradigm
• Install Reporting Services
• Understand the Reporting Services architecture
• Create a Report - Enhance Reports
• Work with Data Sets
• Implement Report Models
• Use the Report Builder 2.0 application to create reports
• Set up report publishing and execution settings
• Distribute reports with subscriptions
• Administer Reporting Services
• Implement the Report Viewer control

Course Content

Introduction to SQL Server 2008 Reporting Services
Overview of Reporting Services

Installing Reporting Services
Standard Installations (Native Mode) of Reporting Services
Installation Prerequisites and Considerations

Reporting Services Architecture
The Reporting Life Cycle
Reporting Services Tools
Reporting Services Web Service
Reporting Services Windows Service
Reporting Services Processors and Extensions
Reporting Services Application Databases

Authoring Reports
Introduction to Report Designer and BIDS
Creating a Basic Table Report
Formatting Report Pages
Including Calculated Values

Enhancing Reports
Dynamic Visibility
Document Maps
Initiating Actions
Using a List Data Region
Creating a Tablix Report
Adding a Chart Subreport

Working with 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

Report Models
Creating Report Models
Using Report Builder 1.0

Using Report Builder 2.0
Introduction to Report Builder 2.0
Modifying an Existing Report
Creating Parameterised Reports
Column Groups and Document Maps
Using Subreports
Linked Reports
Drill-Through Reports
Authoring a Report from XML Data
Creating Tabular and Matrix Reports with Report Models
Creating Reports from Analysis Services Cubes

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

Distributing Reports with Subscriptions
Introduction to Report Subscriptions
Creating a Standard Subscription
Creating a Data-Driven Subscription
Managing Report Subscriptions

Reporting Services Administration
Administering the Reporting Server
Performance and Reliability Monitoring
Administering the Report Server Databases
Security Administration

Programming Reporting Services
Using URL Access to Display a Report
Automating Report Management
Rendering Reports
Using the Report Viewer Control