Writing Reports with Report Builder and SSRS Level 1

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.

Multiple Routes of Delivery to
Fit Your Timetable

We understand that flexibility is key to effective learning and development, especially in today’s dynamic work environment. That’s why we offer multiple delivery formats for our IT trainings in UAE. Whether you prefer the interaction of in-person classes, the convenience of live virtual training, or the independence of self-paced online learning, we have a solution tailored to your schedule. Our goal is to make professional growth accessible to everyone, allowing you to upskill without compromising your other commitments.

Online Instructor Led

Learn from the comforts of your home/office with our expert trainers via online platforms.

Classroom Training

Face-to-face physical classroom training with max interactions at our 5* training venues.

Onsite Training

Learn in your own environment from our expert trainers for maximum impact.

Overseas Training

Choose your desired country for learning with our expert trainers.

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

28 January 2025 - 29 January 2025

Writing Reports with Report Builder and SSRS Level 1

28 April 2025 - 29 April 2025

Writing Reports with Report Builder and SSRS Level 1

28 July 2025 - 29 July 2025

Writing Reports with Report Builder and SSRS Level 1

28 October 2025 - 29 October 2025

Writing Reports with Report Builder and SSRS Level 1

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.

Writing Reports with Report Builder and SSRS Level 1

Course Overview

Learning Objectives

Course Prerequisites