Which Reporting Services course should you choose?
You can see our SSRS courses, manuals, exercises, venues and much more at our SSRS training home page. This page shows what you might expect to cover on our introductory Reporting Services course.
Currently Wise Owl SSRS courses run in SQL Server 2012, which is almost identical to 2008 R2 from the point of view of Reporting Services.
Creating tables
On the introduction course you'll first learn how to create tabular reports:
A simple table, listing directors of films.
Grouping tables
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.
Expressions
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).
Parameters
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.
Indicators
Our introductory course covers creating indicators:
Indicators are cool! Here they show the relative length of different films.
Gauges
The introduction to SSRS course also shows how to create the all-powerful gauges:
The same information, but this time using a radial gauge to show the length of each film.
Matrices
The introduction course shows how to create matrices (aka pivot tables):
A matrix showing the mean lengths of films by country and certificate.
Lists
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
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.
Advanced SSRS training
Our two-day advanced Reporting Services course covers:
- how to use stored procedures for reports (particularly for dropdown parameters)
- using variables in reports
- how to create custom assemblies and use these in your 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.
You can see details of our two standard SSRS courses as follows:
- Two-day Introduction to SSRS course
- Two-day Advanced SSRS course
Or ask us about onsite SSRS training, or our SSRS report development service.