Type and hit enter to Search
×

Writing Reports with Report Builder and SSRS Level 1

  • 4.8(45,300 Rating)

Course Overview

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS.

Learning Objectives

Navigate the Report Builder Environment.

  • Create table reports.
  • Format reports.
  • Create basic and complex expressions.
  • Group report data.
  • Create matrix reports.
  • Sort and filter data.
  • Summarize data with charts.
  • Print and export reports.

Course Prerequisites

  • Familiarity with Windows.
  • Creating and navigating folders.
  • Opening programs
  • .Manipulating windows
  • .Copying and pasting objects
  • .Formatting text
  • Saving files.

Target Audiance

  • The meticulous analyst seeking to refine data presentation for strategic insights.
  • The budding entrepreneur eager to streamline business operations with professional reporting.
  • The diligent project manager aiming to enhance team communication through structured reports.

Schedule Dates

Writing Reports with Report Builder and SSRS Level 1
03 September 2024 - 04 September 2024
Writing Reports with Report Builder and SSRS Level 1
03 December 2024 - 04 December 2024
Writing Reports with Report Builder and SSRS Level 1
03 March 2025 - 04 March 2025
Writing Reports with Report Builder and SSRS Level 1
03 June 2025 - 04 June 2025

Course Content

  • • Introducing the Report Builder Environment
  • • Working with Existing Reports

  • • Create Report Data Sources
  • • Create Report Datasets
  • • Work with the Tablix Data Region
  • • Create a Table Report

  • • Formatting Reports
  • • Sorting and Filtering Report Data
  • • Adding Data to a Dataset
  • • Creating Simple Expressions
  • • Creating Complex Expressions

  • • Group Data in Reports
  • • Group Data Using an Expression
  • • Creating Subgroups and Group Aggregates

  • • Creating and Modifying Matrix Data Regions
  • • Creating and Modifying Column Groups

  • • Create and Modify Chart Wizard Reports
  • • Add Charts to Existing Reports
  • • Modify Charts in Reports

  • • Print Features and Print Options
  • • Export Reports

FAQs

Report Builder is a tool for authoring paginated reports, and SSRS (SQL Server Reporting Services) is a server-based report-generating software system from Microsoft. They are used to design, deploy, and manage reports for businesses.

This course is suitable for anyone interested in learning how to create professional reports using Report Builder and SSRS. It’s especially beneficial for analysts, developers, and IT professionals working with data.

In this course, you will learn how to design and develop reports using Report Builder and SSRS, including creating data connections, designing layouts, implementing interactivity, and deploying reports.

No prior experience is required, but familiarity with SQL and basic understanding of databases will be helpful. The course starts from the basics and gradually progresses to advanced topics.

Yes, we offer both in-person and remote learning options for this course. You can choose the mode of learning that best suits your preferences and schedule.

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