• Decrease font size
  • Default font size
  • Increase font size

Leveraging SQL Server 2008 Reporting Services: Report Development Part 1

 Print E-mail

Notify me when the Leveraging SQL Server 2008 Reporting Services Self-paced Training Course is available!Training Description

This course introduces, demonstrates and explores report authoring in SQL Server 2008 Reporting Services. The entire authoring process is covered, including data sources, basic table-based report development, report formatting, dynamic reporting features, parameters and filters. The new SQL 2008 interface for report modeling and report building is also explored.

This is part one of a two part course. In part two, report services administration is covered.

Training Objectives

As a result of this training, you will be able to:

  • Explain the process of Report Development in SQL Server Reporting Services
  • Author Basic and Dynamic Reports
  • Use Report Models and Report Builder

Prerequisites

  • SQL Server Database Administration Experience
  • Visual Studio / Business Intelligence Development Studio Experience
  • Recommended: SQL 2005 Reporting Services Experience
  • Recommended: Familiarity with Visual Basic .NET
  • Recommended: Transact-SQL Fluency

Training Outline

Module OO: Course Introduction

  • Instructor Background and experience
  • Course Overview
  • Course Objectives
  • Course Prerequisites

Module 01: Overview of Reporting Services

  • Reporting Services Overview
  • Installation of SQL Server Reporting Services
  • Reporting Services Tools

Module 02: Report Components

  • Data Sources
  • Data Source Views
  • Table-Based Reports

Module 03: Detail Rows and Groupings

  • Detail Rows
  • Groupings

Module 04: Basic Formatting

  • Page Options
  • Row and Group Formatting
  • Layout and Design Considerations
  • Conditional Formatting

Module 05: Report Items

  • Tablix
  • Table, Matrix and List
  • Independent Items

Module 06: Custom Fields and Aggregate Functions

  • Custom Fields
  • Aggregate Functions

Module 07: Dynamic Reporting

  • Dynamic Visibility
  • Report Actions

Module 08: Data Connections and Queries

  • Connecting to Data Sources
  • Using Datasets

Module 09: Parameters and Filters

  • Using Parameters
  • Using Filters

Module 10: Report Models

  • Overview of Report Model
  • Report Model Components
  • Creating a Report Model

Module 11: Report Builder

  • Overview of Report Builder
  • Creating Reports with Report Builder

Module 12: Course Summary

  • Review course objectives
  • Review content covered