651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

Microsoft SQL Server Report Builder Level 1: Write & Format Reports with SSRS - 55123

2 Days

Description

Need to turn raw SQL Server data into clear, professional reports? This beginner-friendly course teaches you how to do just that using Microsoft SQL Server Report Builder and SQL Server Reporting Services (SSRS).

In Report Builder Level 1 (Course 55123), you’ll learn how to connect to data sources, create tables and matrix reports, group and filter data, apply formatting, and add visualizations like charts. The course combines foundational theory with hands-on labs to help you produce reports that are insightful and presentation-ready.

Whether you're starting from scratch or transitioning from another reporting tool, this 2-day class equips you with the practical skills to create, polish, and share reports that support decision-making.

Objectives

After completing this course, you’ll be able to design and distribute data-driven reports using Report Builder and SSRS. You’ll learn to:

  • Navigate the Report Builder interface and tools
  • Create table and matrix reports
  • Write basic and advanced expressions
  • Sort, filter, and group report data
  • Add visual elements like charts
  • Format reports for printing and export

Audience  

The primary audience for this course are persons who are new to reporting with Microsoft® SQL Server® Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors.

Upcoming Classes

Virtual Classroom Live
September 03, 2026

$950.00
  Featured Class 2 Days    8 AM CT - 4 PM CT
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

1 - Exploring the Report Builder Environment

  • Introducing the Report Builder Environment
  • Working with Existing Reports
  • Lab 1: Exploring the Report Builder Application

2 - Adding Data to Table Reports

  • Create Report Data Sources
  • Create Report Datasets
  • Work with the Tablix Data Region
  • Create a Table Report
  • Lab 1: Creating Table Reports

3 - Formatting Data and Creating Expressions in Reports

  • Formatting Reports
  • Sorting and Filtering Report Data
  • Adding Data to a Dataset
  • Creating Simple Expressions
  • Creating Complex Expressions
  • Lab 1: Formatting Reports

4 - Grouping Report Data

  • Group Data in Reports
  • Group Data Using an Expression
  • Creating Subgroups and Group Aggregates
  • Lab 1: Creating Reports with Groups and Aggregates

5 - Matrix Reports

  • Creating and Modifying Matrix Data Regions
  • Creating and Modifying Column Groups
  • Lab 1: Creating Matrix Reports

6 - Charts

  • Create and Modify Chart Wizard Reports
  • Add Charts to Existing Reports
  • Modify Charts in Reports
  • Lab 1: Creating Charts and Chart Reports

7 - Printing and Exporting Reports

  • Print Features and Print Options
  • Export Reports
  • Lab 1: Printing and Exporting Reports

Upcoming Classes

Virtual Classroom Live
September 03, 2026

$950.00
  Featured Class 2 Days    8 AM CT - 4 PM CT
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

  • Familiarity with Windows.
  • Creating and navigating folders.
  • Opening programs.
  • Manipulating windows.
  • Copying and pasting objects.
  • Formatting text.
  • Saving files.

Upcoming Classes

Virtual Classroom Live
September 03, 2026

$950.00
  Featured Class 2 Days    8 AM CT - 4 PM CT
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date