Summary
55123 Writing Reports with Report Builder and SSRS Level 1
In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS.
Introduction
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.
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
Prerequisites
•Familiarity with Windows. •Creating and navigating folders. •Opening programs. •Manipulating windows. •Copying and pasting objects. •Formatting text. •Saving files.
Outline
-
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
Course Schedule
DATES
LOCATION
START
END
STATUS
**Indicates a course that is only a half day.