Data Private Public

Writing Reports with Report Builder and SSRS Level 2 (55128)

2 days
Microsoft SQL Server

Advance your Microsoft SQL Server Report Builder and SSRS skills by creating parameterized, interactive reports with expressions, images, and visualizations.

Talk to a Learning ConsultantRegister for a Public ClassRequest a Private Class

Register or Request Training

Price per student
$1,269.10
Guaranteed to run
Select a date
Please select a class.
Interested in a private class?
  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

Build on your foundational Microsoft SQL Server Report Builder and SQL Server Reporting Services (SSRS) skills. This course focuses on creating reports by connecting to databases, manipulating data, and adding advanced reporting features.

Designed for report authors and professionals such as business analysts, programmer analysts, data analysts, database administrators, and IT professionals, the course covers parameterized and list reports, complex expressions, images, subreports, drilldown and drillthrough functionality, and data visualizations.

Course Benefits

  • Create and configure parameterized reports.
  • Create and modify reports using list data regions.
  • Format reports with complex expressions, Top N reporting, and running values.
  • Add images and subreports to reports.
  • Add and configure drilldown and drillthrough functionality.
  • Use sparklines, data bars, and indicators to enhance reports.

Delivery Methods

Public Class
Live expert-led online training from anywhere. Guaranteed to run .
Private Class
Delivered for your team at your site or online.

Course Outline

  1. Parameter Reports
    1. Parameterized reporting
    2. Create report parameters
    3. Modify report parameters
    4. Provide default parameter values
    5. Provide available values for parameters
    6. Lab: Creating parameterized reports
  2. List Data Regions
    1. Introducing the list data region
    2. Create reports using list data regions
    3. Modify reports that use list data regions
    4. Lab: Creating list reports
  3. Enhancing Reports with Complex Expressions
    1. Formatting reports
    2. Top N reports
    3. Running values
    4. Lab: Enhancing reports with complex expressions
  4. Enhancing Reports with Images and Subreports
    1. Add images to reports
    2. Retrieve images from a database
    3. Introducing SQL Server Reporting Services Report Server
    4. Add subreports to reports
    5. Lab: Working with images and subreports
  5. Drilldown and Drillthrough Reports
    1. Add and configure drilldown reporting
    2. Add and configure drillthrough reporting
    3. Lab: Adding drilldown and drillthrough functionality to reports
  6. Sparklines, Data Bars, and Indicators
    1. Sparklines
    2. Data bars
    3. Indicators
    4. Lab: Adding sparklines, data bars, and indicators to reports

Class Materials

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

Class Prerequisites

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

  • Familiarity with Windows, including navigating folders, opening programs, managing windows, copying and pasting, formatting text, and saving files.
  • Microsoft Office Access 2013 Level 1 or equivalent knowledge of basic database concepts.
  • Completion of Course 55123: Writing Reports with Report Builder and SSRS Level 1.

Prerequisite Courses

Courses that can help you meet these prerequisites:

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant