Writing Reports with Report Builder and SSRS Level 1

Session Detail:    Classroom 2 Day

In this 2-day course, students are introduced to the foundations of report writing with Microsoft SQL Server Report Builder and SSRS. The focus will be on report writing by connecting to a database and manipulating the data for presentation including creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, sorting and filtering data, charting data, and preparing reports for printing and exporting. Report Builder 3.0 is available for Microsoft SQL Server versions 2014, 2012, and 2008 R2.

Prerequisites

  • Familiarity with Windows.
  • Creating and navigating folders.
  • Opening programs.
  • Manipulating windows.
  • Copying and pasting objects.
  • Formatting text.
  • Saving files.
  • Microsoft Office Access 2013: Level 1 or have equivalent experience with basic database concepts.

Who Can Benefit

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. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft SQL Server Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.

Session Outline

Class Outline

Module 1: Exploring the Report Builder Environment

  • Lesson 1: Introducing the Report Builder Environment
  • Lesson 2: Working with Existing Reports

After completing this module, students will be able to:

  • Describe and navigate the graphical elements of the Report Builder application
  • Work with existing reports and navigate between Design and Run modes

Module 2: Adding Data to Table Reports

  • Lesson 1: Create Report Data Sources
  • Lesson 2: Create Report Datasets
  • Lesson 3: Work with the Tablix Data Region
  • Lesson 4: Create a Table Report

After completing this module, students will be able to:

  • Create report data sources
  • Create report datasets
  • Work with the tablix data region
  • Create a table report

Module 3: Formatting Data and Creating Expressions in Reports

  • Lesson 1: Formatting Reports
  • Lesson 2: Sorting and Filtering Report Data
  • Lesson 3: Adding Data to a Dataset
  • Lesson 4: Creating Simple Expressions
  • Lesson 5: Creating Complex Expressions

After completing this module, students will be able to:

  • Format data in a report using the Report Builder Properties dialog boxes
  • Add data to a report and make changes to column names in the dataset query
  • Format data in a report using simple and complex expressions
  • Display data in a report using simple and complex expressions

Module 4: Grouping Report Data

  • Lesson 1: Group Data in Reports
  • Lesson 2: Group Data Using an Expression
  • Lesson 3: Creating Subgroups and Group Aggregates

After completing this module, students will be able to:

  • Group data in reports using fields
  • Group data in reports using expressions
  • Create group hierarchies
  • Aggregate grouped data in a report

Module 5: Matrix Reports

  • Lesson 1: Creating and Modifying Matrix Data Regions
  • Lesson 2: Creating and Modifying Column Groups

After completing this module, students will be able to:

  • Describe the key features of using a matrix in a report
  • Create and modify matrix reports
  • Define column group hierarchies
  • Use expressions to define matrix headings and sort orders

Module 6: Charts

  • Lesson 1: Create and Modify Chart Wizard Reports
  • Lesson 2: Add Charts to Existing Reports
  • Lesson 3: Modify Charts in Reports

After completing this module, students will be able to:

  • Describe the key features of charts
  • Create charts using the Chart Wizard and the Ribbon
  • Modify chart data and the formatting of chart elements
  • Use expressions in charts

Module 7: Printing and Exporting Reports

  • Lesson 1: Print Features and Print Options
  • Lesson 2: Export Reports

After completing this module, students will be able to:

  • Describe the key features of electronic reporting vs. print reporting
  • Prepare a report for paper printing
  • Export reports in supported formats

Need to train your team?

All of our sessions can be customized to meet your team’s specific needs. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Writing Reports with Report Builder and SSRS Level 1

2 Day
Classroom

$1,090.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now