Course Code: 9867

55128 Writing Reports with Report Builder and SSRS Level 2

Class Dates:
2 Days
Class Time:
Instructor-Led Training, Virtual Instructor-Led Training


  • Course Overview
  • In this 2-day course, students will continue their learning on the foundations of report writing and data analysis with Microsoft® SQL Server® Report Builder and SSRS. Troubleshooting reports, creating parameter reports, creating custom reports, adding complex expressions to analyze data, adding images and subreports to reports, adding drilldowns and using drillthrough behaviors to analyze data, add sparklines, data bars, and indicators to reports. .

    We will work with interactive reporting using parameters, create custom reports with rectangles and lists, use conditional formatting to enhance data presentation, use complex formatting expressions, add images to reports, provide drilldown capability, connect server-hosted reports, analyze data with mini-charts, mini-gauges, and scorecards. In addition, we will also troubleshoot and resolve failing reports and features early and often.
  • Audience
  • This course is intended for experienced Report Builder and SSRS report writers who are business analysts, programmer analysts, data analysts, developers, database administrators, and IT professionals.


Course Details

  • At Course Completion
  • Incorporate the use of single valued parameters, multi-valued parameters, range parameters, and cascading parameters in a report
  • Add default values for parameters
  • Create a list of available values for a parameter and Create date range parameters
  • Troubleshoot failing parameter reports and Create free-form reports with rectangles
  • Use master-detail data with report objects, Troubleshoot and resolve master-detail data errors in reports
  • Use conditional formatting to enhance data presentation, Define and implement running values
  • Create TOP N reports, Format reports for presentation and analysis
  • Troubleshoot and resolve failing TOP N filters and reports, Use a Visual Basic procedure in a report
  • Use images to enhance reports and display images stored in databases, Use advanced report formatting techniques
  • Understand composite reports which use different page layouts, Incorporate the use of cascading parameters in reports
  • Use mini-charts and mini-gauges in reports, Use mini-gauges to create a scorecard
  • Troubleshoot and resolve failing features of a mini-chart report
  • Module 1: Parameter Reports - This module reviews dynamic reporting through the use of parameters.
  • Parameterized reporting
  • Creating and Modifying Parameters
  • Creating Default Values and Available Values for Parameters
  • Lab 1: Parameterized Reports
  • Create a Report which uses a Single-Value Parameter and Multi-Value Parameter
  • Create a Report which provides a List of Available Parameter Values to Choose From
  • Create a Report with using Multiple Parameters, Default Parameter Date Range Values, and Available Values
  • Troubleshoot Failing Parameter Reports which use Multiple Parameters, Default Parameter Values, and Available
  • Parameter Values
  • Module 2: Creating Custom Reports with Rectangles and Master-Detail Data
  • Introducing Rectangles and Lists
  • Create Reports using Rectangles and List Data Regions
  • Modify Reports which use Rectangles and List Data Regions
  • Lab 1: Create Custom Reports using Lists, Master-Detail Data, and Rectangles
  • Create a Report with Rectangles, Lists, Tables, and Master-Detail Data
  • Create an Invoice Report with a Rectangles, Lists, Tables, and Text Boxes
  • Module 3: Enhancing Reports with Formatting and Complex Expressions
  • Enhancing Report Appearance
  • Using Running Values to Provide Totals and Subtotals
  • Creating and Using Top N Reports
  • Lab 1: Enhancing Reports with Complex Expressions
  • Analyze Report Data with Conditional Formatting
  • Use Complex Expressions in Charts
  • Calculate a Running Value
  • Create TOP N Reports
  • Format a Table with Alternate Row Shading
  • Matrix Report Alternate Row Shading with Visual Basic
  • Module 4: Enhance Reports with Images and Subreports
  • In this module, students will add images and reports (subreports) to reports.
  • Adding Images to Reports
  • Retrieving Images from a Database
  • Introducing SQL Server Reporting Services Report Manager
  • Adding Subreports to Reports
  • Lab 1: Working with Images and Subreports
  • Enhancing an Existing Report with Images
  • Adding Subreports to a Report
  • Adding Parameterized Subreports to Reports
  • Module 5: Drilldown and Drillthrough Reports
  • This module explains how to add drilldowns to your report to allow your audience the ability to uncover layers of detail about your summarized content.
  • Drilldowns
  • Drillthroughs
  • Lab 1: Summarize Data with Drilldowns and Drillthroughs
  • Adding Drilldowns to Control Report Detail
  • Add Drilldown Behavior to a Group
  • Add Drilldown Behavior to a Group Hierarchy
  • Analyze Data using Drillthrough Behaviors in a Report
  • Module 6: Inline Data Analysis with Mini-charts and Mini-Gauges
  • This module introduces the use of mini-charts and mini-gauges in report writing.
  • Mini-Charting with Graphs of Data
  • Mini-Charting with Bars of Data
  • Mini-Gauging with Scorecards
  • Lab 1: Analyze Data with Mini-Charts and Mini-Gauges
  • Analyze Data with Indicators and Data Bars
  • Analyze Data with Sparklines
  • Use Indicators to Analyze Data with a Scorecard