SQL Server Reporting Services (SSRS)

Batch Price From £280 (approx. $369 USD) View Dates & Prices
Custom Price From £160 (approx. $211 USD) Price Calculator & Booking Short course on Microsoft SQL Server Reporting Services (SSRS)

Total Duration: 8 Hours
Course level: Beginner
Delivery Method: Instructor-led Physical Classes or Virtual Classes
Certification: Certificate of Completion will be provided after completing the course

Course Overview

Our SQL Server Reporting Services (SSRS) is an instructor-led classroom based training course that teaches attendees how to design and create report, indicators, charts, data bars, lists, map layers and manage these by using SSRS.

Requirements

This course is suitable for those who already have basic knowledge of SQL.

We highly recommend you complete the following course(s) before attending the SQL Server Reporting Services (SSRS) course:

SQL for Beginners

You may also complete the following course(s) before attending the SQL Server Reporting Services (SSRS) course but they are not mandatory:

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes

Time Zone:

There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later.

Note: Online classes are usually delivered through Zoom video conferencing.

Course Content

Getting Started with SSRS
- What is SSRS?
- Installing SQL Server with Reporting Services
- Report Design Environments
- Introduction to Visual Studio
Retrieving Data for Reports
- Solutions and Projects
- Create a New Project
- The Elements of a Report
- Data Sources and Datasets
- Creating a Report
Designing Report Layout
- Report Design Elements
- Adding a Table to display data
- Adding Page Header and Footer
- Formatting the Table
Expressions and Functions
- Introduction of Expressions
- Develop Expressions with a Built-in Field
- Using Function in an Expression
- Using IIF function
- Using SWITCH function
Making Reports Dynamic with Parameters
- Using Report Parameters
- Parameter Lists
- Create a Dynamic Parameter List
- Default Parameters
Creating Drill-down Reports
- Introduction to Drill-down Reports
- Create a Drill-down Report
Creating Multi-level Reports
- Introduction to Multi-level Reports
- Create a Multi-level Report
- Adding Subtotals and Totals
- Making Expandable/Collapsible Groups
Creating Matrix Reports
- Introduction of Matrix Reports
- Aggregate Data
- Creating a Matrix Report
- Grouping in a Matrix Report
Creating Charts
- Adding a Bar Chart
- Creating a Pie Chart
Using Indicators
- Introduction to Indicators
- Adding an Indicator Column

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a booking.

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

book a course on different dates
book for a group of delegates
book corporate training
book a customised training
book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

How many hours?

How many people?

Total Cost

Price per person

Preferred Dates and Times

Any other information