• Venue
  • Register
  • FAQs
  • Contact
  • Time Zone

SQL Server Reporting Services (SSRS)

Batch Price From £240 (approx. $305 USD) View Dates & Prices
Custom Price From £120 (approx. $152 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:

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:
Training MethodDates and TimesPrice 
Classroom Training 25 May 2024 - 26 May 2024
Saturday to Sunday
05:00 AM - 09:00 AM ET
£280
(approx. $356 USD)
Enrol Now
Classroom Training 02 Jul 2024 - 04 Jul 2024
Tuesday & Thursday
05:00 AM - 09:00 AM ET
£280
(approx. $356 USD)
Enrol Now
Classroom Training 13 Jul 2024 - 14 Jul 2024
Saturday to Sunday
05:00 AM - 09:00 AM ET
£280
(approx. $356 USD)
Enrol Now
Classroom Training 20 Aug 2024 - 22 Aug 2024
Tuesday & Thursday
05:00 AM - 09:00 AM ET
£280
(approx. $356 USD)
Enrol Now
Classroom Training 31 Aug 2024 - 01 Sep 2024
Saturday to Sunday
05:00 AM - 09:00 AM ET
£280
(approx. $356 USD)
Enrol Now

Course Content

  1. Getting Started with SSRS
    • What is SSRS?
    • Installing SQL Server with Reporting Services
    • Report Design Environments
    • Introduction to Visual Studio
  2. Retrieving Data for Reports
    • Solutions and Projects
    • Create a New Project
    • The Elements of a Report
    • Data Sources and Datasets
    • Creating a Report
  3. Designing Report Layout
    • Report Design Elements
    • Adding a Table to display data
    • Adding Page Header and Footer
    • Formatting the Table
  4. Expressions and Functions
    • Introduction of Expressions
    • Develop Expressions with a Built-in Field
    • Using Function in an Expression
    • Using IIF function
    • Using SWITCH function
  5. Making Reports Dynamic with Parameters
    • Using Report Parameters
    • Parameter Lists
    • Create a Dynamic Parameter List
    • Default Parameters
  6. Creating Drill-down Reports
    • Introduction to Drill-down Reports
    • Create a Drill-down Report
  7. Creating Multi-level Reports
    • Introduction to Multi-level Reports
    • Create a Multi-level Report
    • Adding Subtotals and Totals
    • Making Expandable/Collapsible Groups
  8. Creating Matrix Reports
    • Introduction of Matrix Reports
    • Aggregate Data
    • Creating a Matrix Report
    • Grouping in a Matrix Report
  9. Creating Charts
    • Adding a Bar Chart
    • Creating a Pie Chart
  10. 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:


Career Path

This is a possible career path after completing this course:

SQL Server Report Designer > Senior SQL Server Report Designer

Participant Reviews

"Great value for money, covers all aspects of SSRS!"

James Lutaya, 28/06/2016

"Good course for learning the most common features of SSRS. Helpful and kind teacher."

Michelangelo Rubino, 18/11/2015

Share This Course

Save Money with Packages

SAVE up to 20% by booking this course with other related courses as shown below:

Data Analyst SQL & SSRS

£560 (save £140)

This package combines
Find out more & book now

Newsletter Sign-up

Have a Question?