Type and hit enter to Search

Writing Reports with Report Builder and SSRS Level 2

  • 4.7(45,337 Rating)

Course Overview

The “Writing Reports with Report Designer and SSRS 2016 Level 2” course delves into the more advanced features of SQL Server Reporting Services (SSRS) and is designed for learners looking to enhance their report designing skills. This course provides an in-depth understanding of how to create dynamic reports using parameters, sophisticated expressions, and data visualization components like sparklines, data bars, and indicators. Learners will explore how to utilize list data regions, incorporate images and subreports, and implement interactive features such as drill-down and drill-through capabilities. By mastering these concepts, participants will be equipped to design complex and interactive reports that can adapt to user input and provide insightful data analysis. This course is essential for professionals seeking to leverage the full potential of SSRS to deliver comprehensive reporting solutions.

Learning Objectives and Outcomes:

  • Understand and implement parameterized reporting to allow user input to shape report data and presentation.
  • Learn how to create, modify, and set default values for report parameters to refine data retrieval and analysis.
  • Acquire the ability to provide a list of available values for parameters, enhancing report usability and accuracy.
  • Master the use of the List Data Region to organize report data in a flexible format.
  • Develop complex expressions to calculate and display data, improving the depth and meaningfulness of reports.
  • Integrate images and subreports into main reports for a comprehensive data overview.

Course Prerequisites

To ensure that participants are well-prepared and can fully benefit from the Writing Reports with Report Designer and SSRS 2016 Level 2 course, the following minimum prerequisites are recommended:

  • Basic understanding of database concepts, including tables and relationships.
  • Familiarity with the Microsoft Windows operating system and its core functionality.
  • Experience with Microsoft SQL Server, including the ability to write basic SQL queries.
  • Prior knowledge of or experience with report writing, ideally with exposure to SQL Server Reporting Services (SSRS) or a similar reporting tool.

Target Audiance

  • Data Analysts: Professionals who need to enhance their skills in generating and customizing reports using Report Builder and SSRS for detailed data analysis.
  • Business Intelligence Developers: Individuals looking to advance their ability to create dynamic and visually appealing reports for business insights.
  • Database Administrators: Attendees aiming to improve their report-building proficiency to better manage and present database information.
  • IT Managers: Managers seeking to gain expertise in report creation to facilitate better decision-making processes within their teams.

Schedule Dates

Writing Reports with Report Builder and SSRS Level 2
01 July 2024 - 02 July 2024
Writing Reports with Report Builder and SSRS Level 2
01 October 2024 - 02 October 2024
Writing Reports with Report Builder and SSRS Level 2
01 January 2025 - 02 January 2025
Writing Reports with Report Builder and SSRS Level 2
01 April 2025 - 02 April 2025

Course Content

  • Parameterized Reporting
  • Create Report Parameters
  • Modify Report Parameters
  • Provide Default Parameter Values
  • Provide Available Values for Parameters

  • Introducing the List Data Region
  • Create Reports Using List Data Regions
  • Modify Reports Which Use List Data Regions

  • Enhancing Report Appearance
  • Using Running Values to Provide Subtotals and Totals
  • Creating and Using Top N Reports

  • Add Images to Reports
  • Retrieve Images from a Database
  • Introducing SSRS (SQL Server Reporting Services) Report Server
  • Add Subreports to Reports

  • Add and Configure Drilldown Reporting
  • Add and Configure Drillthrough Reporting

  • Sparklines
  • Data Bars
  • Indicators


Learn advanced techniques for customizing report layouts and visual design to enhance readability and user engagement.

Master the creation of sophisticated charts, gauges, and maps to represent data effectively.

Explore the use of cascading parameters, multi-value parameters, and dynamic parameter lists to create interactive reports.

Understand how to integrate subreports and enable drill through actions for detailed data exploration.

Techniques for improving report execution times and performance tuning for large datasets.

Start learning with 15.8k students around the world.
  • 3.3k
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
How Can We Help You?