55123 Writing Reports with Report Builder and SSRS Level 1

Training for Your Group

Training On Demand

Training for Individuals

$1095

Course Overview

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.

Prerequisites: 

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

Course Length: 2 days

What You're Going To Learn

  • 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.

Register for an Upcoming Date

Date Location Price Register

Course Outline

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

What to Expect at LeapFox

Knowledgeable Instructors

Our instructors are certified professionals. They are trained on the latest features and how to get the most out of software programs.

Hands-on Labs

No boring lectures! Our courses are designed to give students lots of time to practice what they are learning with hands-on exercises and projects.

Certificate of Completion

Receive a certificate of completion at the end of every course.

Up-to-date Curriculum

Each course comes with a helpful and up-to-date ebook which will contain instruction and practice exercises.

Time Saving Tips N Tricks

In each course, your instructor will show you tips and tricks that will save you time and make you more efficient.

Friendly and Helpful Staff

Our staff is dedicated to your success. Each team member is trained to provide the absolute best customer service possible.

Satisfaction Guarantee

If you aren't 100% satisfied with your experience at LeapFox, simply let us know, and we will make it right.

Look who Else is Using LeapFox

albertsons

See What Our Customers Say