55123 Writing Reports with Report Builder and SSRS Level 1

Course Length: 2 Days

Delivered: Virtually

OVERVIEW:

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. This course may earn a Credly Badge.

COURSE PREREQUISITES:

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

TARGET 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.

COURSE OBJECTIVES:

• Navigate the Report Builder Environment.
• Create table reports.
• Format reports.
• Create basic and complex expressions.
• Group report data.
• Create matrix reports.
• Sort and filter data.
• Summarize data with charts.
• Print and export reports.

COURSE CONTENT:

Exploring the Report Builder Environment

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

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

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

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

Matrix Reports

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

Charts

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

Printing and Exporting Reports

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