Writing Reports with Report Builder and SSRS Level 1

Writing Reports with Report Builder and SSRS Level 1 (55123)

Course Length: 2 days
Delivery Methods: Multiple delivery options
Course Overview

In this course, participants will advance their skills in report writing using Microsoft® SQL Server® Report Builder and SSRS. This course is designed for individuals new to reporting with Microsoft® SQL Server® Report Builder and SSRS, those transitioning from another reporting software application, and current Report Builder and SSRS report authors seeking to enhance their knowledge.

Course Benefits
  • Learn to navigate the Report Builder environment.
  • Learn to create table reports.
  • Learn to format reports.
  • Learn to create basic and complex expressions.
  • Learn to group report data.
  • Learn to create matrix reports.
  • Learn to sort and filter data.
  • Learn to summarize data with charts.
  • Learn to print and export reports.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Course Outline
  1. Exploring the Report Builder Environment
    1. Introducing the Report Builder Environment
    2. Working with Existing Reports
    3. Lab 1: Exploring the Report Builder Application
  2. Adding Data to Table Reports
    1. Create Report Data Sources
    2. Create Report Datasets
    3. Work with the Tablix Data Region
    4. Create a Table Report
    5. Lab 1: Creating Table Reports
  3. Formatting Data and Creating Expressions in Reports
    1. Formatting Reports
    2. Sorting and Filtering Report Data
    3. Adding Data to a Dataset
    4. Creating Simple Expressions
    5. Creating Complex Expressions
    6. Lab 1: Formatting Reports
  4. Grouping Report Data
    1. Group Data in Reports
    2. Group Data Using an Expression
    3. Creating Subgroups and Group Aggregates
    4. Lab 1: Creating Reports with Groups and Aggregates
  5. Matrix Reports
    1. Creating and Modifying Matrix Data Regions
    2. Creating and Modifying Column Groups
    3. Lab 1: Creating Matrix Reports
  6. Charts
    1. Create and Modify Chart Wizard Reports
    2. Add Charts to Existing Reports
    3. Modify Charts in Reports
    4. Lab 1: Creating Charts and Chart Reports
  7. Printing and Exporting Reports
    1. Print Features and Print Options
    2. Export Reports
    3. Lab 1: Printing and Exporting Reports
Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Microsoft SQL Server class:

  • Familiarity with Windows.
  • Creating and navigating folders.
  • Opening programs.
  • Manipulating windows.
  • Copying and pasting objects.
  • Formatting text.
  • Saving files.
Follow-on Courses
Live Public Class
$1,269.10 / student
Please select a class.
Live Private Class
  • Private Class for your Team
  • Live training
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Proposal