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

Classroom Training

Intensive fast-track 3-day Reporting Services (SSRS)

Classroom training course - online version also available

3 days

Sometimes our clients want to learn everything about SSRS (SQL Server Reporting Services) in one go, minimising the amount of time spent out of the office.  We've combined all of the units from our Introduction to SSRS course and the most useful ones from our Advanced SSRS course to create this intensive three-day course, aimed at the select class of people (you'll know if you're one of them) who aren't fazed by the prospect of an intensive three-day period of training. 

Course details

  • Locations for Fast track SSRS coursesPossible locations:London, Manchester, Online
  • Next Fast track SSRS course locationNext classroom course:No classroom dates
  • Fast track SSRS course timesTime:10.00-16.30

Course Contents

This fast-track course combines topics from the following other Wise Owl courses:

From our REPORTING SERVICES course

Introduction to SSRS

  • Visual Studio and SSDT
  • Solutions and projects
  • The Visual Studio environment

Designing a Simple Report

  • Authoring a report
  • Using report items
  • Selecting and formatting report items
  • Number formats

Data sources and datasets

  • Shared data sources
  • Shared versus embedded datasets
  • Using Query Designer

Tables

  • Structure of a table
  • Formatting tables
  • Inserting rows
  • Interactive sorting
  • Repeating page headers

Grouping tables

  • Using the grouping panes
  • Row and column groups
  • Displaying subtotals
  • Outlining

Expressions

  • Calculated fields
  • The ReportItems collection
  • Using built-in fields
  • Conditional formatting - expressions

Pages and printing

  • Page headers and footers
  • Pagination between groups
  • Header and footer expressions

Parameters

  • Using query parameters
  • Creating drop lists
  • Multi-value drop lists
  • Formatting using parameters

Indicators

  • Creating indicators
  • Changing the symbols displayed
  • Stopping indicators stretching

Gauges

  • Creating and formatting gauges
  • Gauge panels
  • Pointers, scales and ranges

Matrices

  • Areas of a matrix
  • Sorting and grouping matrices
  • Creating and formatting subtotals

Charts

  • The areas of a chart
  • Creating charts
  • Formatting charts

Data bars and sparklines

  • Need for a grouped row
  • Creating data bars
  • Creating sparklines

Covered if time allows If time

Lists

  • Creating and formatting lists
  • Grouping using lists
  • Using rectangles in lists

Covered if time allows If time

Subreports

  • Creating a child report
  • Creating the main report
  • Creating and formatting subreports

Drill-through reports

  • Parent and child reports
  • Creating actions
  • Passing values to a child report

Covered if time allows If time

Maps

  • ESRI shapefiles / SQL spatial data
  • Linking to datasets
  • Map layers
  • Center points and point layers

Deploying reports

  • Setting the target server
  • Deploying an entire project
  • Deploying single reports

The SSRS web portal

  • Browsing to the web portal
  • Viewing reports
  • Managing reports

Covered if time allows If time

KPIs and mobile reports

  • Creating a KPI
  • Installing Mobile Report Publisher
  • Creating a mobile report

Covered if time allows If time

Subscriptions

  • How subscriptions work
  • Creating a new subscription
  • Managing subscriptions
From our ADVANCED SSRS course

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

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

Covered if time allows If time

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

You don't need any pre-existing knowledge of SQL or SQL Server to attend this course, although if you understand how databases are constructed using tables and relationships you'll have a head start.  What you must have is a very good aptitude for IT, otherwise you won't enjoy your three days!

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

"Very informative classes and the teacher was able to answer my questions and explain with various examples how to accomplish this. Fellow colleague recommended the course."

Jack Wright (Brooksby Melton College)

"Very knowledgeable, yet friendly and approachable trainer. Great course."

Elaine Ferguson (NSL Limited)

"Really good pace and coverage of topics. Very happy, thank you."

Marie Woltman (Devon County Council)

"Excellent. Very encouraging tutor, useful manuals, enjoyed the course. Contents excellent for level being taught."

Chas Mills (Guardian Industries UK Ltd)

"The course was an extremely productive use of our time. It was delivered at a comfortable pace, despite a significant amount of content. The trainer was flexible in his approach and extremely accommodating."

Matt Franklin (LifeArc)

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

Advanced SSRS

Advanced

2 day course

Other Reporting Services training resources

SSRS exercises

SSRS exercises

We've published our SSRS exercises on our website, so you can see what we will include on your course.

View SSRS 2016 exercises

SSRS videos

SSRS videos

As an alternative (or supplement) to classroom training, we've created a series of SSRS videos.

View Reporting Services - Introduction, SSRS 2016, Report Builder 2016 or Reporting Services - Advanced videos

SSRS blogs

SSRS blogs

We've got all sorts of blogs on Reporting Services on our website.

View SSRS blogs

This page has 0 threads Add post