Data Private

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

2 days
Microsoft SQL Server

Learn to create, format, visualize, print, and export professional reports with Microsoft SQL Server Report Builder and SSRS in this two-day hands-on course.

Talk to a Learning ConsultantRequest a Private Class

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

Learn to turn SQL Server data into clear, professional reports with Microsoft SQL Server Report Builder and SQL Server Reporting Services (SSRS). In this beginner-friendly, two-day course, you will connect to data sources, build table and matrix reports, group and filter data, write expressions, apply formatting, and create charts.

Designed for new report authors, users transitioning from other reporting tools, and existing Report Builder and SSRS users, the course combines foundational instruction with hands-on labs covering report creation, refinement, printing, and export.

Course Benefits

  • Navigate the Report Builder interface and work with existing reports.
  • Create data sources, datasets, table reports, and matrix reports.
  • Format reports and write basic and complex expressions.
  • Sort, filter, group, and aggregate report data.
  • Create and customize charts to visualize data.
  • Prepare reports for printing and export them to formats such as PDF, Excel, and Word.

Delivery Methods

Private Class
Delivered for your team at your site or online.

Course Outline

  1. Exploring the Report Builder Environment
    1. Introduction to the interface
    2. Working with existing reports
    3. Lab: Navigating Report Builder
  2. Adding Data to Table Reports
    1. Creating data sources and datasets
    2. Using the Tablix data region
    3. Lab: Building table reports
  3. Formatting Data and Using Expressions
    1. Report formatting basics
    2. Sorting, filtering, and adding fields
    3. Writing basic and complex expressions
    4. Lab: Formatting reports and expressions
  4. Grouping Report Data
    1. Grouping data manually and with expressions
    2. Creating subgroups and aggregates
    3. Lab: Reports with grouping and totals
  5. Matrix Reports
    1. Creating matrix layouts
    2. Adding and modifying column groups
    3. Lab: Designing matrix reports
  6. Charts
    1. Creating chart wizard reports
    2. Adding charts to existing layouts
    3. Customizing chart types and properties
    4. Lab: Creating and enhancing chart reports
  7. Printing and Exporting Reports
    1. Print options and setup
    2. Exporting to PDF, Excel, Word, and other formats
    3. Lab: Outputting and sharing 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.
  • Ability to create and navigate folders.
  • Ability to open programs and manage application windows.
  • Ability to copy and paste objects.
  • Basic experience formatting text and saving files.

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