55123 Writing Reports with Report Builder and SSRS Level 1

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

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.

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

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

This course is SATV-Eligible All class times shown are in Pacific Standard Time (PST)

Contact Us For Price

Course Length: 2 Days

1. Choose a Date | 2. Click Enroll Now

Mar 09

Online LIVE, 6:00 am - 2:00 pm
NHCLC G2R

Jun 02

Online LIVE, 8:00 am - 4:00 pm
NHCLC G2R

Need Help Picking the Right Course? Give us a call! 781-388-0026