Who should take this course?
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.
Prerequisites
- Familiarity with Windows
- Creating and navigating folders
- Opening programs
- Manipulating windows
- Copying and pasting objects
- Formatting text
- Saving files
The Training Covers These Topics:
- 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
Exploring the Report Builder Environment
- Introducing the Report Builder Environment
- Working with Existing Reports
- Lab: 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: 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: Formatting Reports
Grouping Report Data
- Group Data in Reports
- Group Data Using an Expression
- Creating Subgroups and Group Aggregates
- Lab: Creating Reports with Groups and Aggregates
Matrix Reports
- Creating and Modifying Matrix Data Regions
- Creating and Modifying Column Groups
- Lab: Creating Matrix Reports
Charts
- Create and Modify Chart Wizard Reports
- Add Charts to Existing Reports
- Modify Charts in Reports
- Lab: Creating Charts and Chart Reports
Printing and Exporting Reports
- Print Features and Print Options
- Export Reports
- Lab: Printing and Exporting Reports