Short course on Microsoft SQL Server Reporting Services (SSRS) Regular Course Price: £200.00   
Total Duration: 5 Hours
Course level: Beginner
Delivery Method: Instructor Led Online Training
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.

Skills Required

This course is suitable for those who already have basic knowledge on Microsoft SQL Server database and table design, SQL, T-SQL and Stored Procedure. Our Database Design with Microsoft SQL Server and Querying Data with SQL and T-SQL training courses cover all of the prerequisites.

Course Dates, Prices & Enrolment

Training
Method
Dates and Times
(in the UK)
Dates and Times
(if not in the UK)
Price 
Online Training using Zoom 23 Nov 2021 - 25 Nov 2021
Tuesday & Thursday
11am - 1:30pm
Start Date & Time
End Date & Time
£200
Enrol Now
Online Training using Zoom 04 Dec 2021 - 11 Dec 2021
2 Saturdays
11am - 1:30pm
Start Date & Time
End Date & Time
£200
Enrol Now
Online Training using Zoom 25 Jan 2022 - 27 Jan 2022
Tuesday & Thursday
11am - 1:30pm
Start Date & Time
End Date & Time
£200
Enrol Now
Online Training using Zoom 05 Feb 2022 - 12 Feb 2022
2 Saturdays
11am - 1:30pm
Start Date & Time
End Date & Time
£200
Enrol Now

Full Course Outline

  1. Introduction to SSRS
    • BIDS and Report Manager
    • Solutions and projects
    • The 4 main Visual Studio windows
  2. Designing a Simple Report
    • Authoring a report
    • Using report items
    • Selecting and formatting report items
    • Number formats
  3. Data sources and datasets
    • Shared data sources
    • Shared versus embedded datasets
    • Using Query Designer
  4. Tables
    • Structure of a table
    • Formatting tables
    • Inserting rows
    • Interactive sorting
    • Repeating page headers
  5. Grouping tables
    • Using the grouping panes
    • Row and column groups
    • Displaying subtotals
    • Outlining
  6. Expressions
    • Calculated fields
    • The ReportItems collection
    • Using built-in fields
    • Conditional formatting using
    • expressions
  7. Parameters
    • Using query parameters
    • Creating drop lists
    • Multi-value drop lists
    • Formatting using parameters
  8. Indicators
    • Creating indicators
    • Changing the symbols displayed
    • Stopping indicators stretching
  9. Charts
    • The areas of a chart
    • Creating charts
    • Formatting charts
  10. Data bars and sparklines
    • Need for a grouped row
    • Creating data bars
    • Creating sparklines
  11. Gauges
  12. Lists
  13. Subreports
  14. Map Report
  15. Deploying Reports

Booking Request

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:

You must need to Register / Sign In first to submit this booking request form.

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

Course Tutors

The course instructor is a .NET developer with 15 years of experience in software and web development. He is a Microsoft Certified Application Developer and skilled on C#, ASP.NET, Microsoft SQL Server, Ajax, HTML, and CSS.

Save Money with Packages

SAVE more than 15% by booking this course with other related courses as shown below:

SQL Server and SSRS

£540 (save £60)

This package combines
Find out more & book now

Newsletter Sign-up

Have a Question?