55128 Writing Reports with Report Builder and SSRS Level 2

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.
Course Details

Price:

$1,295.00

Days:

2

Location:

Virtual

Course Overview

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.

After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators.

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; Course 55123: Writing Reports with Report Builder and SSRS Level 1

1 – Parameter Reports

  • Parameterized Reporting
  • Create Report Parameters
  • Modify Report Parameters
  • Provide Default Parameter Values
  • Provide Available Values for Parameters
  • Lab: Creating Parameterized Reports

2 – List Data Regions

  • Introducing the List Data Region
  • Create Reports Using List Data Regions
  • Modify Reports Which Use List Data Regions
  • Lab: Creating List Reports

3 – Enhancing Reports with Complex Expressions

  • Formatting Reports
  • Top N Reports
  • Running Values
  • Lab: Enhancing Reports with Complex Expressions

4 – Enhance Reports with Images and Subreports

  • Add Images to Reports
  • Retrieve Images from a Database
  • Introducing SSRS (SQL Server Reporting Services) Report Server
  • Add Subreports to Reports
  • Lab: Working With Images and Subreports

5 – Drilldown and Drillthrough Reports

  • Add and Configure Drilldown Reporting
  • Add and Configure Drillthrough Reporting
  • Lab: Add Drilldown and Drillthrough Functionality to Reports

6 – Sparklines, Data Bars, and Indicators

  • Sparklines
  • Data Bars
  • Indicators
  • Lab: Adding Sparklines, Data Bars, and Indicators to Reports
Class Dates & Times
Filters Sort results
Reset Apply
06/23/2025 - 06/24/2025
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$1,295.00
09/18/2025 - 09/19/2025
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$1,295.00
12/22/2025 - 12/23/2025
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$1,295.00
— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.