651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

Writing Reports with Report Builder and SSRS Level 1 (55123)

2 Days

Description

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

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.

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.

 

Upcoming Classes

Virtual Classroom Live
April 16, 2024

$950.00
  Featured Class 2 Days    8 AM CT - 4 PM CT
view class details and enroll
Virtual Classroom Live
June 24, 2024

$950.00
  Featured Class 2 Days    8 AM CT - 4 PM CT
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

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

Upcoming Classes

Virtual Classroom Live
April 16, 2024

$950.00
  Featured Class 2 Days    8 AM CT - 4 PM CT
view class details and enroll
Virtual Classroom Live
June 24, 2024

$950.00
  Featured Class 2 Days    8 AM CT - 4 PM CT
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

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

Upcoming Classes

Virtual Classroom Live
April 16, 2024

$950.00
  Featured Class 2 Days    8 AM CT - 4 PM CT
view class details and enroll
Virtual Classroom Live
June 24, 2024

$950.00
  Featured Class 2 Days    8 AM CT - 4 PM CT
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date