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