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 ...
In this page
You can see our SSRS courses, manuals, exercises, venues and much more at our main Reporting Services training courses page. This page shows what you might expect to learn on our two main SSRS scheduled courses:
Course | Notes |
---|---|
A two-day course showing you how to create reports in SQL Server Reporting Services. | |
A two-day advanced course, showing people who already know SSRS some extra tips and tricks (and in particular how to create custom assemblies in code, and how to link to them). |
We also publish an intensive fast-track SSRS course, which covers all of the introduction course topics and most of the advanced ones in a single three-day course.
On the introduction to SSRS course you'll first learn how to create tabular reports:
A simple table, listing directors of films.
The introductory course then shows how to create grouped reports, including using outlining:
A report showing films by country, with toggle items for the country name.
The introductory course then shows how to create expressions or formulae in SSRS:
The difference is a calculated field, and the page header and footer include expressions.
One particularly nice feature shown on the introductory course is the ability to use the render format to show a report as an Excel workbook of separate named worksheets, with one sheet per group (for example, you could have each director's films on a separate worksheet within the same workbook).
The introductory course shows how to create parameters (including dropdowns):
In this report you can choose any combination of directors using the multivalue dropdown, then choose a film and see its cast list.
Our advanced SSRS course shows how to create multi-value dropdowns based on stored procedures.
Our introductory course then covers creating indicators and gauges:
Indicators are cool! Here they show the relative length of different films.
The introduction course also shows how to create matrices (aka pivot tables):
A matrix showing the mean lengths of films by country and certificate.
Lists in SSRS are cousins of tables and matrices, and are covered on most introduction courses:
This list shows a table of the films made by each director, and also a chart.
Subreports allow you to show parents and children together, and are included at the end of most introduction courses:
The subreport shows the films made by each director.
Our two-day advanced Reporting Services course covers:
how to use stored procedures for reports (particularly for dropdown parameters)
using variables in reports
using bookmarks and document maps
creating dynamic reports
As one example to whet your appetite, here's a dynamic chart:
You can choose what you want to chart using a dropdown! Here we're comparing the length of films by country.
If neither course is exactly what you're looking for, ask us about onsite SSRS training, or our SSRS report development service.
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.