Classroom Training
Advanced SSRS
Classroom training course - online version also available
£950 + VAT for most venues (£1,095 + VAT for London)
2 days
If you can already create reports using either Report Builder or Reporting Services, we'd like to show you what else SSRS can do! This two-day advanced course will show you how to create and use variables; why and how you should base your reports on views and stored procedures; and how to use bookmarks, document maps and dynamic reports. If you're getting a group of people up to speed on SSRS from scratch, combining this and our two-day Introduction to SSRS course together makes for a nice three-day onsite course.
We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking.
Alternatively, you could enquire about running the course in your office or even (if available) as a tailored online course.
Course Contents
The contents of this course are as follows:
Revision of grouping
- Creating grouped tables
- Fixing page headers
- Collapsing and expanding
Revision of expressions
- Calculated fields
- Using the expression builder
- Conditional formatting
Advanced expressions
- Understanding scope
- Using RowNumber
- Running totals
Variables
- How variables work
- Report variables
- Group variables
Embedding code
- Setting code for a report
- Calling functions in expressions
- Better ways to write code
Using SQL views
- Why views are a good idea
- Designing views
- Scripting views
- Creating virtual tables
Revision of parameters
- Configuring parameters
- Referencing parameters
- Dealing with no rows
- Default and null values
- Dropdown parameters
Stored procedures in SSRS
- Pros and cons of stored procedures
- Server Explorer vs SSMS
- Creating and editing procedures
- Using for reports
Stored procedure parameters
- Creating report parameters
- Refreshing fields
- Default and null values
Dropdowns with procedures
- The stored procedures needed
- Cascading dropdowns
- Replacing SELECT A VALUE
Multivalue parameter procedures
- Splitting the choices made in SQL
- Displaying the chosen data
- Restricting the number of choices
Improving report navigation
- Document maps
- Using bookmarks
- Setting tooltips
Dynamic reports
- Dynamic datasets
- Dynamic grouping
- Dynamic matrices
The ideal preparation for this course is to attend our two-day Reporting Services course. We will accept other delegates, but you must have a good understanding of how to create reports in SSRS. Delegates must also know some SQL. This course is taught using SQL Server 2016, although the version isn't particularly important.
Why Choose Us?
- No more than 6 people per class
- Proper restaurant lunch included
- 519 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Alison Hopkins (Greater Manchester Combined Authority (GMCA))
Natalie Sheard (Alzheimers Research UK)
Mark Mullett (Frimley Health NHS Foundation Trust)
Solomon Odunlami (Department for Levelling Up, Housing and Communities (DLUHC, ex MHCLG))
Kim Cowell (Government Internal Audit Agency (GIAA))
There are lots more where these came from (or just refresh this page to change the quotes shown).
Related Courses
Other Reporting Services training resources
SSRS exercises
To help you decide whether you like the Wise Owl approach to classroom training, take a look at some of the Reporting Services exercises we've published online.
View SSRS 2016 exercises
SSRS videos
We don't just do classroom training! There is a whole series of Reporting Services videos on the Wise Owl YouTube channel too.
View Reporting Services - Introduction, SSRS 2016, Report Builder 2016 or Reporting Services - Advanced videos
SSRS blogs
Exercises, videos and blogs on Reporting Services too, as you can see by following this link.
View SSRS blogs