Writing Reports with Report Designer and SSRS 2016 Level 2 (Microsoft Course 55170)
Overview
In this 2-day course, students will continue their learning on the foundations of business intelligence (BI) report writing with SQL Server Data Tools (SSDT) Report Designer and SSRS. The focus will be on report creation by connecting to a database and manipulating the data for presentation including: creating parameter reports, creating list reports, adding complex expressions to reports, adding images and subreports to reports, adding drilldown and drillthrough functionality, and adding sparklines, data bars, and indicators to reports. Report Designer is available for all supported versions of Microsoft SQL Server.
At the end of this course, students will be able to:
Prior to taking this course, students should have the following skills:
The primary audience for this course is persons who are new to reporting with SQL Server Data Tools Report Designer and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Designer and SSRS report authors.
Objectives
Topics
Prerequisites
Audience
The secondary audience for this course is persons who are using Report Builder.
Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with SQL Server Data Tools Report Designer and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.
Course duration
2 Days
Course outline
Module 1: Parameter Reports
This module introduces the use of the parameter in report writing. Parameters allow a level of self-service reporting wherein the report audience can choose the data to view (date range, department, geography, etc.).
Lessons:
Lab: Creating Parameterized Reports
After completing this module, students will be able to:
Module 2: List Data Regions
This module introduces the list data region. List data regions allow report writers free-form control over their reports, whereas, table and matrix reports bind you to a table or matrix data presentation. This free-form feature affords the report writer the ability to truly customize the report.
Lessons:
Lab: Creating List Reports
After completing this module, students will be able to:
Module 3: Enhancing Reports with Complex Expressions
This module introduces several new report formatting techniques which allow the report writer better control over the data displayed in the report.
Lessons:
Lab: Enhancing Reports with Complex Expressions
After completing this module, students will be able to:
Module 4: Enhance Reports with Images and Subreports
In this module, students will add images and reports to reports (subreports), and students will be introduced to SSRS (SQL Server Reporting Services).
Lessons:
Lab: Working With Images and Subreports
After completing this module, students will be able to:
Module 5: Drilldown and Drillthrough Reports
This module introduces the ToggleByItem and Action properties to incorporate drilldowns and drillthrough reporting.
Lessons:
Lab: Add Drilldown and Drillthrough Functionality to Reports
After completing this module, students will be able to:
Module 6: Sparklines, Data Bars, and Indicators
This module introduces the ability to create and add charts to reports. Whether through wizard or individual effort, chart reports or charts as report components allow us to visualize data with or without the details.
Lessons:
Lab: Adding Sparklines, Data Bars, and Indicators to Reports
After completing this module, students will be able to:
