55128 Writing Reports with Report Builder and SSRS Level 2
CLASS DATE(s):
5/20/2020 - 5/21/2020
7/15/2020 - 7/16/2020

COURSE LENGTH: 2 Days

COURSE COST: $995.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

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 AND PREREQUISITES

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

PREREQUISITE COURSES  

*Course Cost listed does not include the cost of courseware. Course is subject to a minimum enrollment to run class. Course may run as a virtual instructor led class if the minimum enrollment is not met. For more information, please contact learn@vtec.org or call 207-775-0244.

COURSE TOPICS:


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