• Venue
  • Register
  • FAQs
  • Contact
  • Time Zone

SQL Server Reporting Services (SSRS)

Batch Price From £240 (approx. $299 USD) View Dates & Prices
Custom Price From £120 (approx. $149 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 
Online Training using Zoom 21 May 2024 - 22 May 2024
Tuesday & Wednesday
05:00 AM - 09:00 AM ET 		£240 £280
(approx. $299 USD) 		Enrol Now
Classroom Training 21 May 2024 - 22 May 2024
Tuesday & Wednesday
05:00 AM - 09:00 AM ET 		£280
(approx. $349 USD) 		Enrol Now
Classroom Training 25 May 2024 - 26 May 2024
Saturday to Sunday
05:00 AM - 09:00 AM ET 		£280
(approx. $349 USD) 		Enrol Now
Online Training using Zoom 09 Jul 2024 - 11 Jul 2024
Tuesday & Thursday
05:00 AM - 09:00 AM ET 		£240 £280
(approx. $299 USD) 		Enrol Now
Classroom Training 09 Jul 2024 - 11 Jul 2024
Tuesday & Thursday
05:00 AM - 09:00 AM ET 		£280
(approx. $349 USD) 		Enrol Now
Classroom Training 13 Jul 2024 - 14 Jul 2024
Saturday to Sunday
05:00 AM - 09:00 AM ET 		£280
(approx. $349 USD) 		Enrol Now
Online Training using Zoom 20 Jul 2024 - 21 Jul 2024
Saturday to Sunday
05:00 AM - 09:00 AM ET 		£240 £280
(approx. $299 USD) 		Enrol Now
Classroom Training 20 Aug 2024 - 22 Aug 2024
Tuesday & Thursday
05:00 AM - 09:00 AM ET 		£280
(approx. $349 USD) 		Enrol Now
Online Training using Zoom 20 Aug 2024 - 22 Aug 2024
Tuesday & Thursday
05:00 AM - 09:00 AM ET 		£240 £280
(approx. $299 USD) 		Enrol Now
Classroom Training 31 Aug 2024 - 01 Sep 2024
Saturday to Sunday
05:00 AM - 09:00 AM ET 		£280
(approx. $349 USD) 		Enrol Now
Online Training using Zoom 31 Aug 2024 - 01 Sep 2024
Saturday to Sunday
05:00 AM - 09:00 AM ET 		£240 £280
(approx. $299 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

£512 (save £128)

This package combines
Find out more & book now

Newsletter Sign-up

Have a Question?

Please read our frequently asked questions or contact us.

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT
Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom
UK: +44 (0)208 432 6218
USA: +1 610-234-7870
CANADA: +1 416-900-1211

Share this page now!

2012 - 2024 © London Academy of IT Limited. All Rights Reserved.
Registered in England & Wales with company no. 07923992.