Classes Data & Analytics
55123 Microsoft Technical Partner Delivered
55123 Writing Reports with Report Builder and SSRS Level 1
- 2 days
- 0 upcoming dates
- May qualify for CEU/PDU credit
Upcoming dates
No public dates scheduled right now
This class runs as a private cohort on dates that suit your team, at your site or delivered live online. Tell us roughly when and how many people, and we'll come back with dates and a total.
Private delivery is usually faster and works out better per seat once you're past four or five people.
Request private datesOr leave your details and we will email you the moment a public date is scheduled.
One email when a date is set. Nothing else, and no list.
About this class
55123 Writing Reports with Report Builder and SSRS Level 1 is not on the public schedule at the moment, and runs as a private cohort on dates you choose. Seats are $1,295 each over 2 days, courseware included. Tell us your dates and headcount and a quote comes back the same business day. Purchase orders welcome.
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.
What you'll be able to do
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
Course outline
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
Before you attend
- Familiarity with Windows.
- Creating and navigating folders.
- Opening programs.
- Manipulating windows.
- Copying and pasting objects.
- Formatting text.
- Saving files.
Who this is for
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.
How reserving works. Your card is authorized, not charged. We confirm the seat with the training center, usually within one business day, and take payment only once it is held. If the class turns out to be full we release the authorization and you are not charged.
Request a quote
Tell us how many people and roughly when. We'll come back with dates, seat price, and a total by the end of the next business day.