Protect your training budget AND save money with our new pre-payment vouchers.
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.  We only offer this as a tailored course (here's why).

Our fast-track courses are only available as tailored training, either at your premises or at either our London or Manchester venues (here's why).

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

"Fantastic balance between group & individual work."

Laura Marsden (Guardian Industries UK Ltd)

"The trainer was very informative and enthusiastic. He explained things well and went through things in detail. The course was interesting and has helped me understand SSIS better."

Shivani Thakar (BAE Systems)

"Course content was great, as was trainer's knowledge and enthusiasm."

Darina Cunnane (Lloyds Banking Group)

"Excellent trainer whose enthusiasm was infectious and helped to make what might otherwise have been dull content interesting and engaging. The content was thorough and has given me much more confidence to further develop my skills using SQL. An excellent 3-day course."

James Berehowskyj (DHU Healthcare CIC)

"An excellent course, well delivered with a knowledgeable tutor."

Graham Davies (Lex)

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