Programming & Development

55123 Writing Reports with Report Builder and SSRS Level 1

Introduction:

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

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.

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

Enroll in this course

$1,190.00

Need Help Finding The Right Training Solution?

Our training advisors are here for you.