55123 Writing Reports with Report Builder and SSRS Level 1
5 Based on 213 reviews- 240,157 Learners
- 287 Courses
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).
Request More InfoIn 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.
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 55123 Writing Reports with Report Builder and SSRS Level 1 Course
Prerequisites for 55123 Writing Reports with Report Builder and SSRS Level 1 Course
55123 Writing Reports with Report Builder and SSRS Level 1 Course Outline
- Introduction to the interface
- Working with existing reports
- Lab: Navigating Report Builder
- Creating data sources and datasets
- Using the Tablix data region
- Lab: Building table reports
- Report formatting basics
- Sorting, filtering, and adding fields
- Writing basic and complex expressions
- Lab: Formatting reports and expressions
- Grouping data manually and with expressions
- Creating subgroups and aggregates
- Lab: Reports with grouping and totals
- Creating matrix layouts
- Adding and modifying column groups
- Lab: Designing matrix reports
- Creating chart wizard reports
- Adding charts to existing layouts
- Customizing chart types and properties
- Lab: Creating and enhancing chart reports
- Print options and setup
- Exporting to PDF, Excel, Word, and other formats
- Lab: Outputting and sharing reports
Resources
FAQs on 55123 Writing Reports with Report Builder and SSRS Level 1
This course is ideal for individuals new to Report Builder and SSRS reporting, those transitioning from other reporting tools, and existing report authors looking to strengthen their skills.
Participants should have basic Windows familiarity, including creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files.
You’ll learn to navigate the Report Builder interface, create table and matrix reports, write basic and advanced expressions, sort/filter/group data, add charts, and format reports for printing and export.
Yes, each module includes labs covering topics like navigating Report Builder, building table and matrix reports, formatting with expressions, grouping data, creating charts, and exporting reports.
The course covers the Report Builder environment, table reports, formatting and expressions, data grouping, matrix reports, charts, and printing/exporting reports in formats like PDF, Excel, and Word.