Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
493 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Not sure if we deserve all the reviews you can see on this site? Here are some of the things we do (very) differently to earn them.
How can any training company guarantee the quality of their courses? Here's how:
Our course manuals and exercises are by some way the best in the computer training industry. Fortunately you don't have to take our word for this - you can see for yourself:
Our values are simple - we treat people as we would like to be treated ourselves. So:
You can see more on our corporate values here.
We've put a lot of thought into making our online courses as useful and interactive as possbile:
Choose a specific course, or stay on this page to see all of our SSRS training.
Course:
Can't see the dates/course type that you want? Create your own onsite course (and tailor the content too!).
Course |
Dates |
Venue/type |
||||
---|---|---|---|---|---|---|
We don't have any scheduled courses for this combination of criteria: please try different options. | ||||||
Reporting Services | 22-23 May | Online | Book | |||
Reporting Services | 02-03 Jun | Manchester | Book | |||
Fast track SSRS | 09-11 Jun | Online | Book | |||
Report Builder | 12-13 Jun | Online | Book | |||
Reporting Services | 19-20 Jun | Online | Book | |||
Report Builder | 16-17 Jul | Online | Book | |||
Reporting Services | 17-18 Jul | Online | Book | |||
Fast track SSRS | 04-06 Aug | Online | Book | |||
Report Builder | 13-14 Aug | Online | Book | |||
Reporting Services | 18-19 Aug | Online | Book | |||
Report Builder | 11-12 Sep | Online | Book | |||
Reporting Services | 23-24 Sep | Online | Book | |||
Fast track SSRS | 01-03 Oct | Online | Book | |||
Report Builder | 16-17 Oct | Online | Book | |||
Reporting Services | 20-21 Oct | Online | Book | |||
Report Builder | 13-14 Nov | Online | Book | |||
Reporting Services | 20-21 Nov | Online | Book | |||
Report Builder | 15-16 Dec | Online | Book |
If you can't see the course you want listed above, don't despair! If you can muster 3 or 4 people together, it may well be worth organising an onsite course at your office (we'll provide and set up the computers), or else an online course tailored to your needs.
Here are some comments we've received about our SSRS + training. You can see all of our 493 reviews here. We would like to sincerely thank the clients whose names are shown below for kindly agreeing to let us share their feedback.
"Really great course and really appreciate this being changed last minute to provide me with the content and experience needed for SSRS reporting."
Lauren Szarvas
Bedfordshire Police
"I cannot fault the course or trainer. It was the best professional training I've ever received."
Justin Cowley
Derby Homes Ltd
"An excellent tutor, who gave a vivid understanding of how report builder works. He would make sure each and every one of us understood the topic before moving onto the next one. He structured his sessions in a way that it wasn't stressful, which made sure I had enough time to grasp what was being taught."
Joseph Philip
Torus62 Ltd
"Trainer was really engaging, knew his stuff and was helpful in guiding us to utilising SSRS effectively. He seemed to really enjoy teaching us and we could tell. Well delivered course and great content, example database to use. The trainer slightly adapted his delivery based on what he believed we would need and he was right."
Nathan Vickery
TVS Supply Chain Solutions
"The trainer was brilliant and adjusted the course to the needs of everyone in the group. We managed to go through many more things than initially assumed. Thank you. Wise Owl was recommended to us by my previous manager and I will definitely consider using Wise Owl for any further development of my team."
Przemyslaw Brzek
TVS Supply Chain Solutions
"Well structured course and the trainer adapted the pace of learning to benefit my needs. I feel I have come away from the course with more knowledge than I expected to and feel confident I will be able to utilise my new skills going forward. Manual is great. Thank you."
Julie Chapman
Hereford Sixth Form College
Have you got an off-the-shelf package which contains some standard reports, but you're finding they don't show what you need to see? Maybe it's time to learn how to create reports in SQL Server Reporting Services!
We run two standard SSRS courses:
Course | Contents |
---|---|
Creating and publishing reports in SSRS | |
Basic reports on views and stored procedures, and other advanced topics |
if yo're a glutton for punishment you can combine these two courses together and sit on our intensive three-day fast-track SSRS course.
Here's what you'll learn on the two-day introductory course:
Topic | Notes |
---|---|
Tables | Linking to data sources, creating datasets and displaying the resulting rows in formatted tables in your reports. |
Grouping data | Learning to create group headers and footers, as well as ensuring titles remain at the top of each page and being able to expand and collapse topics. |
Expressions | Creating additional columns in reports using functions like SWITCH, and using expressions to conditionally format parts of a report. |
Pages and printing | Displaying page headers and footers, and learning to customise print settings for a report. |
Parameters | Making a report return different results according to the values of parameters that you type in (such as start/end dates), and creating dropdown parameters. |
Indicators and gauges | Displaying traffic lights or smiley faces to show how good a particular score is, or a linear or radial gauge for even more gimmickiness! |
Matrices | Displaying data in a two-dimensional grid, similar to a pivot table in Excel. |
Charts | Learning how to show charts in an SSRS report, including (if time allows) spark lines and data bars. |
Subreports | Creating a subreport to show for each item on a main report, and using an action to enable drill down in a report. |
Lists | Using a list to display tables, charts and matrices for each row in a main table. |
Maps | If time allows, creating maps and linking them to data tables to show different pie charts at different locations for different postcodes. |
Deployment | Copying your work onto your corporate server, and using the SSRS web portal to view reports. |
The two-day advanced course includes the following topics:
Topic | Notes |
---|---|
Expressions | A revision of expressions, followed by an explanation of what scope means and how to use it. |
Variables | Creating report-level and group-level variables. |
Embedded code | Creating and referencing custom functions within a report. |
Views | Creating views on SQL and referencing them in reports. |
Stored procedures | Using stored procedures as a basis for reports, as well as creating them in SQL. |
Parameters | A refresher of parameters in reports, followed by how to use them with stored procedures (including dropdown and multivalue parameters using stored procedures). |
Report navigation | Using document maps and bookmarks to make it easier to navigate in a report. |
Dynamic reports | How to vary the content and structure of a report depending on options chosen by a user. |
You can see even more details about what our SSRS courses will cover here.
You don't need to learn SQL to attend our SSRS course, but it's virtually inevitable that you will at some point need to learn how to combine data from different database tables using the SQL querying language.
In an ideal world, we'd suggest attending courses in the following order:
Course | Notes |
---|---|
Learn how to select data from your corporate database, including joining tables together, setting criteria and using expressions. | |
Learn how to create beautiful (!) reports based on this data, including parameters so that you can choose which rows to see. | |
Learn how to create stored procedures and use other advanced programming techniques, giving you more power to select exactly the right data for your reports. |
However, you definitely shouldn't book an advanced SQL course until a) you're sure you'll need to learn this and b) your trainer on the introduction course has confirmed that you'll enjoy it!
Click on any heading below to learn more.
Contact method | Details |
---|---|
Phone | Call us on (0161) 883 3606 and (within normal UK office hours) a friendly and helpful human will answer the phone! |
Send an email to our inbox and we'll aim to answer it within a couple of working hours. | |
Web | Fill in an enquiry form letting us know what you want to achieve, and we'll do our best to help! |
We've got the following videos on our site to help you to learn SSRS:
Category | Videos |
---|---|
21 |
|
6 |
|
5 |
|
84 |
Blog topic |
---|
SSRS |
In addition to our classroom and online SSRS training courses, we also have the following learning resources:
Resource | Notes |
---|---|
Tips and tricks | Useful tips and tricks to make SSRS easier |
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2025. All Rights Reserved.