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
551 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 ...
We've been running classroom training courses in Reporting Services for a number of years, and now offer online SSRS training too. If you're trying to learn SSRS there will be something on this page for you!
We currently run the following scheduled SSRS courses:
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 publish two standard 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.
Each of our scheduled courses (whether classroom or online) includes:
In addition, our classroom courses also include:
Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.
Here are the next SSRS courses we have scheduled:
Course | Dates | Venue |
---|---|---|
Reporting Services | 20-21 Jan | Online |
Report Builder | 22-23 Jan | Online |
Fast track SSRS | 12-14 Feb | Online |
Report Builder | 13-14 Feb | Online |
Reporting Services | 17-18 Feb | Online |
Report Builder | 11-12 Mar | Online |
Reporting Services | 20-21 Mar | Online |
All prices exclude VAT. If you can't see the dates you want, don't forget that you always have the option of arranging onsite training at your offices (we'll even provide the computers and projector).
If you need to use Reporting Services to create and distribute reports based on your corporate data, you'll probably need to learn SQL too.
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.
There are many ways in which we can help you learn SSRS!
We've published all of our SSRS and Report Builder exercises online (we mix and match betwen the two, as they're virtually identical), so you can judge for yourself whether our training is for you.
Click on the link below to see some of our blogs on Reporting Services.
Whatever version of SSRS you're using, you'll find both our 2012 and 2016 videos useful.
Have a look at our Reporting Services tips and tricks.
Here's where our scheduled SSRS courses run.
You can sample or license the following courseware manuals.
Rather than learn Reporting Services, you could commission Wise Owl to create your reports (which will almost inevitably involve writing SQL too).
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 2024. All Rights Reserved.