Summary

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.

Introduction

Who Should Attend
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.

Course 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

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

Outline

  • EXPLORING THE REPORT BUILDER ENVIRONMENT

    • Introducing the Report Builder Environment
    • Working with Existing Reports
    • Lab 1: Exploring the Report Builder Application
  • 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
  • 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
  • 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
  • MATRIX REPORTS

    • Creating and Modifying Matrix Data Regions
    • Creating and Modifying Column Groups
    • Lab 1: Creating Matrix Reports
  • CHARTS

    • Create and Modify Chart Wizard Reports
    • Add Charts to Existing Reports
    • Modify Charts in Reports
    • Lab 1: Creating Charts and Chart Reports
  • PRINTING AND EXPORTING REPORTS

    • Print Features and Print Options
    • Export Reports
    • Lab 1: Printing and Exporting Reports

Course Schedule

*Indicates a course that spans over multiple days.

**Indicates a course that is only a half day.