Canadian Academy of IT

SQL Server Reporting Services (SSRS)

Learn to create reports, indicators, charts, data bars, lists, and manage these by using SSRS
  • Beginner
  • Online Classes
  • Total 8 hours in class
  • SQL Server Reporting Services (SSRS)


This course suits those with basic knowledge of Microsoft SQL Server database and table design, SQL, T-SQL and Stored Procedure. Our SQL for Beginners covers all of the prerequisites.

Class Details

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

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

Request for Course Dates and 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:


Subscribe to our newsletter

Sign up for our newsletter, so you can be the first to find out the latest news and tips about our classes, as well as general updates throughout the year.