Writing Reports with Report Builder and SSRS Level 1 (55123)
Course Length: 2 days
Delivery Methods:
Multiple delivery options
Course Overview
In this course, participants will advance their skills in report writing using Microsoft® SQL Server® Report Builder and SSRS. This course is designed for individuals new to reporting with Microsoft® SQL Server® Report Builder and SSRS, those transitioning from another reporting software application, and current Report Builder and SSRS report authors seeking to enhance their knowledge.
Course Benefits
- Learn to navigate the Report Builder environment.
- Learn to create table reports.
- Learn to format reports.
- Learn to create basic and complex expressions.
- Learn to group report data.
- Learn to create matrix reports.
- Learn to sort and filter data.
- Learn to summarize data with charts.
- Learn to print and export reports.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Private classes are delivered for groups at your offices or a location of your choice.
Course 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
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Class Prerequisites
Experience in the following is required for this Microsoft SQL Server class:
- Familiarity with Windows.
- Creating and navigating folders.
- Opening programs.
- Manipulating windows.
- Copying and pasting objects.
- Formatting text.
- Saving files.
Follow-on Courses
Live Public Class
$1,269.10 / student
Live Private Class
- Private Class for your Team
- Live training
- Online or On-location
- Customizable
- Expert Instructors