SQL – Writing Reports and Report Builder L2

Two Days • Instructor-led

Course Description

This course provides an introduction Microsoft® SQL Server® Report Builder. In this course, participants will create reports by connecting to a database and manipulate the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, charting data, and preparing reports for printing and exporting. Report Builder is available in all supported versions of Microsoft® SQL Server® (2016, 2014, 2012, and 2008R2).

Audience

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). Persons may be business analysts, program analysts, data analysts, database administrators, or IT professionals. Course participants 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.

Course Objectives

After completing this course, students will be able to:

  • Create parameter reports.
  • Create list reports.
  • Work with complex expressions.
  • Images and Subreports.
  • Drilldown and Drillthrough Reports.
  • Sparklines, Data Bars, and Indicators

Course Outline

This course covers the following:

  • Parameter Reports
  • List Reports
  • Complex Expressions
  • Images and Subreports
  • Drilldown and Drillthrough Reports
  • Sparklines, Data Bars, and Indicators

View upcoming Class Schedule