SQL Server Reporting Services

Enabling you to design, deploy and manage reports using Reporting Services.
Overview

The ability to report, analyse and visualise data in a variety of interactive, mobile and printed reports is essential to control and manage your organisation. such reports and dashboards are increasingly designed and deployed using Microsoft SQL Server Reporting Services (SSRS). This course uses SQL Server 2017 but is equally suitable for SQL 2016 and other previous versions.

Course Code
SQL3REP
Duration
3 Days
Delivery Style
Classroom
Course Type
Public or Private
Max Delegates
12
Available as Nutshell
No

Book your team training at your premises

  • Date
  • Venue
  • Cost
  • More info

Book your place

  • Date
  • Venue
  • Cost
  • Availability
  •  
  • 09 Jan 2019
  • VenueWorcester
  • Cost£1,197
  • AvailabilityAvailable
  • Book Now
  • 22 Jul 2019
  • VenueWorcester
  • Cost£1,197
  • AvailabilityAvailable
  • Book Now
Purpose of this course

This course covers the design of reports in Report Builder. It also includes mobile reports and key performance indicators. Reports will include tablix, charts and gauges. Different types of interactive content will be used. Other topics covered include managing security, exporting reports and delivering reports to folders and by email. Exercises are included to consolidate the skills taught.

Who is this course for

IT professionals who need to design, deploy and manage reports for SQL Server Reporting Services.

You will learn how to
  • Develop reports, mobile reports and key performance indicators
  • Include graphical content in reports
  • Use expressions for conditional formatting in reports
  • Add parameters to reports
  • Link reports to provide drill down functionality
  • Deploy reports to a Reporting Services server
  • Manage Reporting Services content
  • Brand the Web Portal
  • Use push subscriptions to email reports
Benefits for your organisation

This course will give your organisation the ability to develop, deploy and manage Reporting Services reports across the organisation.  These reports will often present information in an impressive graphical format and incorporate interactive features.

Benefits for you as an individual

This course will equip you with the skills to understand and use SQL Server Reporting Services.  You will have the confidence to develop complex reports and manage Reporting Services.  You will be able to use both Report Builder and the Reporting Services Web Portal.

Introduction to SQL Server Reporting Services

Overview of SQL Server Reporting Services
Features in Different SQL Server Editions
Reporting Services Architecture
Installing Reporting Services
Configuring Reporting Services
Paginated Reports
Mobile Reports and Key Performance Indicators

Creating Reports Using Wizards

Report Builder
Launching Report Builder
Using Wizards to Create a Report
Using Report Builder
Report Properties
SQL Server Data Tools

Tables Using Tablix

Overview of Tables
Creating a Report
Adding a Table to a Report
Grouping Rows
Properties Window
Other Content
Saving a Report
Drill Down Reports
Shared Data Sources
Shared Datasets

Charts, Gauges and Maps

Overview of Charts and Gauges
Charts
Gauges
Other Types of Chart and Gauge
Maps

Expressions

Overview of Expressions
Entering Expressions
Example of Expressions
Aggregate Functions
Decision Making Function
Reporting Services Variables
Embedded Code in Reports
Action
Embedded HTML in Text Boxes

Advanced Report Features

Overview of Advanced Report Features
Lists
Report Parameters
Linked Reports
Subreports
Matices
Images
Report Parts

Securing Reporting Services

Overview of Reporting Services Security 
System Tasks and Roles
Item Tasks and Roles
Creating System and Item Roles
Data Source Security

Managing Reporting Services

Using the Web Portal
Favourites
Report Properties
Processing Options
Report History
Schedules
Subscriptions
Using Reports From Applications
Reporting Services Settings
Monitoring Reporting Services

Prerequisites

No previous knowledge of Microsoft SQL Server Reporting Services is required.  A basic knowledge of Microsoft SQL Server is required.  This could be gained from our SQL Server Essentials course or through work experience.

About the Lead Trainer

Stephen has 20 years’ experience in the IT industry. A member of the Institute of IT Training and British Computer Society with a degree in business computing systems, Stephen has a solid foundation upon which his ITIL® Expert qualification sits.