Browse 537 attributed reviews, viewable separately for our classroom and online training
Classroom training -  Advanced SSRS

Classroom Training

Advanced SSRS

Classroom training course - online version also available

£750 + VAT for most venues (£895 + 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?

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).

"Just to say thank you to our trainer; his breadth of knowledge in SSRS, VBA and SQL helped me better understand it. Not the easiest product to use, but I now have learned some valuable techniques and tips around some of the bugs I have been encountering. "

Michael Taylor (Leeds Community Healthcare NHS Trust)

"Course was just right level. Enjoyed breaking up sessions with exercises."

Gemma Wood (Loftware)

"Found the course very, very useful."

Katie Cawley (Cobalt Housing)

"I really enjoyed this course. I've done a number of courses over the years (not Wise Owl Training and not PBI), but this was head and shoulders above the others. It might be that I was interested in learning about the topic, but the whole experience was seamless. The pre-course IT check was an important detail (I did a course the previous week with another provider and this beset with IT issues upon starting). Using the remote desktop meant I had easy access to the data and the trainer could see when I did something wrong. The trainer was also very good. I'd actually be happy to do another online course again (even after Covid) - I didn't feel like I lost anything by doing it this way. It was booked for me - but I'm glad the person who booked it, chose Wise Owl."

Stuart Andrews (Valuation Office Agency)

"I thought this course was really great, really comprehensive and easy to follow. Having the course materials sent out is also really helpful for work after the course. The trainer was amazing! He was so personable and patient and it must be so hard to to teach not in a standard classroom environment, but he did a wonderful job and left a really great lasting impression."

Bev Power-Wealls (Valuation Office Agency)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Related Courses

Reporting Services

Basic

2 day course

Introduction to SQL

Introduction

2 day course

Advanced SQL

Advanced

2 day course

Other Reporting Services training resources

SSRS exercises

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

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

SSRS blogs

Exercises, videos and blogs on Reporting Services too, as you can see by following this link.

View SSRS blogs

This page has 0 threads Add post