Community Course

Writing Reports with Report Builder and SSRS Level 2

55128AC (Class Pack)
Based on student feedback via 'Metrics that Matter'
Writing Reports with Report Builder and SSRS Level 2
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. Report Builder is available for all supported versions of Microsoft SQL Server and this course can be used against all of them.
Please contact your Learning Partner in order to take this course
Author: Techmite, Inc.

Course Duration: 2 Days


About This Course

In this two-day course, students will experience a hands-on, deep dive into reporting techniques for analyzing data using paginated reports, charts, and scorecards. We transfer the skills and insights needed for real world analysis and reporting of data using course content, discussions, demonstrations, and scenario-based labs. Students can work through objectives based on reporting requirements or they can complete the work by following step-by-step instructions.

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.

All features covered in this course have become normal requirements in today's reporting landscape. Report Builder is available for all supported versions of Microsoft SQL Server and this course content can be applied against any of those versions.

Audience Profile

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.

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
  • Create date range parameters
  • Troubleshoot failing parameter reports
  • 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