Description

Duration

2 Days

12 CPD hours

This course is intended for

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.

Overview

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.

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

Prerequisites

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

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

Course Images

55123 Writing Reports with Report Builder and SSRS Level 1

By Nexus Human

Booking options

Highlights

Description

Dates

About The Provider

Tags

Reviews