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

Price
$1,295.00 USD

Duration
2 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Course Overview

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

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.

Course 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

Who Should Attend?

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.
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

What is Microsoft SQL Server Report Builder Level 1 training?

This 2-day course introduces the fundamentals of building reports using Microsoft SQL Server Report Builder and SSRS. It covers table and matrix layouts, expressions, grouping, and exporting reports.

Is this course part of a certification path or credential?

While not tied to a specific certification, this course is often the first step for those pursuing Microsoft data analyst or BI development skills. It prepares you for advanced SSRS and Power BI topics.

Will this course help me create professional reports from SQL Server data?

Yes. You’ll learn to build table, matrix, and chart-based reports, use expressions and filters, and format them for printing and sharing—all without writing complex SQL.

Will this course help me transition from tools like Crystal Reports or Excel?

Absolutely. The course is ideal for those switching to SSRS or looking to automate and standardize reporting directly from SQL Server sources.

Is this training worth it?

Yes—reporting skills are essential in any data-driven organization. This course gives you the foundation to create accurate, visually polished reports that support smarter decisions.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

Corporate Tech Pass: Our Corporate Tech Pass includes unlimited attendance for a single person, in the following Virtual Instructor Led course types: Microsoft Office, Microsoft Technical, CompTIA, Project Management, SharePoint, ITIL, Certified Ethical Hacker, Certified Hacking Forensics Investigator, Java, Professional Development Courses and more. The full list of eligible course titles can be found at https://www.newhorizons.com/eligible.

If you have questions about our Corporate Tech Pass, please contact your Account Manager.

Course Prerequisites

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

Agenda

Exploring the Report Builder Environment

  • Introduction to the interface
  • Working with existing reports
  • Lab: Navigating Report Builder

Adding Data to Table Reports

  • Creating data sources and datasets
  • Using the Tablix data region
  • Lab: Building table reports

Formatting Data and Using Expressions

  • Report formatting basics
  • Sorting, filtering, and adding fields
  • Writing basic and complex expressions
  • Lab: Formatting reports and expressions

Grouping Report Data

  • Grouping data manually and with expressions
  • Creating subgroups and aggregates
  • Lab: Reports with grouping and totals

Matrix Reports

  • Creating matrix layouts
  • Adding and modifying column groups
  • Lab: Designing matrix reports

Charts

  • Creating chart wizard reports
  • Adding charts to existing layouts
  • Customizing chart types and properties
  • Lab: Creating and enhancing chart reports

Printing and Exporting Reports

  • Print options and setup
  • Exporting to PDF, Excel, Word, and other formats
  • Lab: Outputting and sharing reports
 

Upcoming Class Dates and Times

Sep 11, 12
8:00 AM - 4:00 PM
ENROLL $1,295.00 USD
Dec 15, 16
8:00 AM - 4:00 PM
ENROLL $1,295.00 USD
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons