Microsoft SQL Server 2008 Reporting Services

3 days

Course Overview

This 3 day 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 and author reports, and 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. The course can be delivered on either a SQL Server 2008 or SQL Server 2008R2 database platform.

Course Objective

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

  • Understand the Reporting Services architecture
  • Create reports
  • Enhance reports
  • Use Charts and Gauges
  • Work with Data Sources and Data Sets
  • Set up report publishing and execution settings
  • Manage Report Server content with Report Manager
  • Distribute reports with subcriptions
  • Secure Report Server resources
  • Adminster Reporting Services
  • Understand some of the programming capabilities of Reporting Services

Prerequisites

  • Understanding of working in a Microsoft Windows operating system environment
  • Experience working with relational databases
  • Knowledge gained from taking the course SQL Introduction to Querying or equivalent
    SQL language experience

Course Outline

Introduction to SQL Server 2008 Reporting Services

  • Overview of Reporting Services
  • The Reporting Life Cycle
  • Reporting Services Architecture
  • Reporting Services Tools
  • Configuring Reporting Services

Authoring Reports – Getting Started

  • Introduction to Report Designer and BIDS
  • Table Reports
  • Grouping and Sorting Data
  • Using a Matrix
  • Using a List
  • Formatting Report Pages
  • Using Other Report Items
  • Expressions
  • Variables

Enhancing Reports

  • Interactive Sorting
  • Drill-Down Reports
  • Parameters
  • Document Maps
  • Actions
  • Drill-Through Reports

Visualizing Data

  • Charts
  • Gauges

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

Publishing and Executing Reports

  • Publishing Reports
  • Managing Content
  • Linked Reports
  • Data Source Properties
  • Executing Reports
  • Caching Reports
  • Report Snapshots
  • Report History
  • The My Reports Folder

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
  • Securing Content

Programming Reporting Services

  • Using URL Access to Display a Report
  • Automating Report Management
  • Rendering Reports to Different Formats