Reporting Services (SSRS) Training Courses
We've been training and consulting on Reporting Services enthusiastically for a number of years. If you're trying to learn SSRS there will be something on this page for you!
Not sure which course you want? See what you can learn on one of our SSRS courses.
Which is the right SSRS course for you?
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:
|Introduction to SSRS (2 days)||Creating and publishing reports in SSRS|
|Advanced SSRS (2 days)||Linking to custom assemblies and other advanced topics|
We took the decision recently to stop publishing dates for our advanced SSRS course, because we're not convinced that most people will find the topics useful! We will still run the course onsite, however.
Here's what you'll learn on the two-day introductory course:
|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.|
You can see even more details about what our SSRS courses will cover here. We currently teach using SSRS 2016, but you won't notice much difference between this and 2014, 2012 or even 2008 R2 (with the exception of the SSRS web portal for the last topic, which has replaced the previous Report Manager).
10 things our SSRS courses include
Each of our scheduled courses includes:
- Small course sizes - we have a maximum of 6 people on each course, and frequently run courses with fewer.
- A computer for each delegate (obviously).
- A trainer! And not just anyone - Wise Owl courses are only ever given by Wise Owls.
- Full colour courseware of oustanding quality (download a sample SSRS courseware chapter to judge this claim for yourself) .
- Interesting exercises to reinforce what you've learnt (you can review some of the SSRS exercises we use here).
- Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
- Unlimited refreshments during the day, including Tassimo or Nespresso coffee and a range of biscuits and snacks to keep you going through those dark afternoon hours.
- A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too.
- A Sheaffer biro and notepad.
- Unofficial help after the course (although we don't have a dedicated post-course support line, in practice trainers will be happy to answer the odd ad hoc question after a course has taken place).
Scheduled SSRS training dates
Here are the SSRS courses we have scheduled for the next 3 months:
|Reporting Services||Wed/Thu 30-31 May 2018||2||Manchester||£695||Book places|
|Report Builder||Tue/Wed 26-27 June 2018||2||London||£850||Book places|
|Report Builder||Thu/Fri 28-29 June 2018||2||Manchester||£695||Book places|
|Reporting Services||Tue/Wed 03-04 July 2018||2||London||£850||Book places|
|Reporting Services||Thu/Fri 05-06 July 2018||2||Manchester||£695||Book places|
|Report Builder||Tue/Wed 07-08 August 2018||2||Manchester||£695||Book places|
|Reporting Services||Tue/Wed 14-15 August 2018||2||London||£850||Book places|
|Reporting Services||Thu/Fri 16-17 August 2018||2||Manchester||£695||Book places|
|Report Builder||Tue/Wed 21-22 August 2018||2||London||£850||Book places|
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 SSRS training at your offices (we'll even provide the computers and projector).
About our SSRS training
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:
|Introduction to SQL||Learn how to select data from your corporate database, including joining tables together, setting criteria and using expressions.|
|Introduction to SSRS||Learn how to create beautiful (!) reports based on this data, including parameters so that you can choose which rows to see.|
|Advanced SQL||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.
Other Reporting Services training resources
Try our SSRS exercises
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:
Blogs on SSRS
Click on the link below to see some of our blogs on Reporting Services:
SSRS courseware manuals
To allow you to judge the quality of our training we publish a few courseware chapters at random on our website (you can download them and view them in Word):
Videos on SSRS
Rather than learn Reporting Services, you could commission Wise Owl to create your reports (which will almost inevitably involve writing SQL too):