55123 Writing Reports with Report Builder and SSRS Level 1

Duration

2 Days

12 CPD hours

This course is intended 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.

Overview

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.

In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS.

Prerequisites

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

1 - Exploring the Report Builder Environment

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

2 - 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

3 - 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

4 - 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

5 - Matrix Reports

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

6 - Charts

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

7 - Printing and Exporting Reports

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