Classroom Training

Reporting Services (SSRS)

Classroom training course - online version also available

£850 + VAT for most venues (£995 + VAT for London)

2 days

If you're wondering whether you should be learning SQL Server Reporting Services, the answer is yes! SSRS (as it's often called) allows you to create impressive reports, including drill-through, indicators, gauges and lots of other whizzy features. You can then publish these reports directly to your company's website in a number of different formats, or push them out to subscribers by email.

Course details

Possible locations:London, Manchester, Online
Next classroom course:No classroom dates
Time:09:30-16:30

SCHEDULED DATES Course Contents - PDF

Course Contents

The contents of this course are as follows:

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

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

You do not need any prior knowledge of SQL to attend this course (although you should have an understanding of tables and databases).

Why Choose Us?

No more than 5 people per class
Proper restaurant lunch included
479 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

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

"Great course and content, very professionally delivered."

Mark Potter (Linney Group Ltd)

"The trainer was very engaging and delivered the training in a way that was informative and easy to follow. The course content was varied and very useful."

Sherry Goodman (Advanced Business Software and Solutions)

"I really enjoyed the course and learnt lots! The handbook, exercises and memory stick are great to take away. (SQL)The speed of the course was just right. (SSRS) A fab course - learnt lots, my brain feels a little bit blown though! The course manual will be really useful back at work."

Harriet Taylor (Macclesfield College)

"Course was great. Intuitive, well constructed and patiently and expertly delivered. All questions were answered and solutions were demonstrated even though they may not have been part of the structure. I'd happily choose and recommend this course to others and as part of my own professional development, would potentially be asking for further training from Wise Owl."

Andrew Smith (North Staffordshire Combined Healthcare NHS Trust)

"The trainer is very personable and knowledgeable. Fircroft has used Wise Owl many times and I would highly recommend them!"

Louise Gorry (Fircroft Engineering Service Ltd)

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

Related Courses

Introduction to SQL RECOMMENDED

Basic

2 day course

Advanced SQL

Advanced

2 day course

Advanced SSRS

Advanced

2 day course

Other Reporting Services training resources

SSRS exercises

Lest you not be sure if this is the right course for you, we've published all of our Reporting Services exercises online.

View SSRS 2016 exercises

SSRS videos

Look at our range of videos on SSRS, which provide and alternative way of learning to classroom training.

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

SSRS blogs

There are lots of good blogs on Reporting Services, which you can inspect at your leisure.

View SSRS blogs

This page has 0 threads Add post