Virtual and Classroom Training - All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.

banner image

MS SQL Server 2016/17 Reporting Services

4 Day Course
course icon

Course Information

This 4 day course is intended for students who need to learn and understand the full reporting lifecycle of designing, managing, and accessing reports in a Microsoft SQL Server 2016 or 2017 environment. Days 1 and 2 will familiarise attendees with the Reporting Services development tools used to create and author reports, and will enable students to design initially basic, then more complex, reports. All of the data regions utilised in report design are covered here including tables, matrices, lists, and charts. Interactive features such as drilldown and drill-through reports are also covered in this section, as are the implementation and use of report parameters. 

Day 3 builds upon the knowledge gained over the previous two days by covering advanced report design concepts, such as making reports more dynamic (for example, allowing users to interactively select groups for a matrix using parameters), alternating background colours for table rows, and other handy tips to enable developers to design truly professional reports. We round off the development phase of the reporting lifecycle by considering the implementation of mobile reports and KPIs. Day 4 of the course deals more specifically with the role of the Report Server itself. Here, students will learn how to deploy reports to a Report Server, manage Report Server content, handle subscriptions, and control access to reports. 

Concise coverage of the subject matter is augmented with plenty of hands-on exercises to facilitate the learning process and to enable students to quickly gain confidence in using Reporting Services. Additionally, with the course structure being fully modularised, customised versions of this course can also be devised and delivered.

Prerequisites

No prior knowledge of the subject matter is assumed. However, students should ideally be familiar with basic programming concepts, and understand the fundamental design of relational databases and data normalization. Some prior working knowledge of SQL Server 2017 (or previous version), and the use of SQL Server Management Studio, is assumed. Attendees should additionally be familiar with the SQL query language, in particular the SELECT statement used for retrieving data. The course, “Microsoft SQL Server 2016 and 2017 Querying Data for Report Developers”, would be an ideal primer for anyone considering taking this course.

Course Objectives

Upon successful completion of this course, students will be able to:

  • Understand the Reporting Services Architecture and Report Lifecycle
  • Create and Edit Reports using Tables, Matrices, and Lists
  • Use Expressions to Enhance Report Capabilities
  • Enhance Reports by Implementing Interactive Features
  • Incorporate Charts, Indicators, and other Graphical Features into Reports
  • Work with Data Sources and Datasets
  • Understand Advanced Report Design Concepts
  • Implement Mobile Reports and KPIs
  • Set up Report Publishing and Execution Settings
  • Manage Report Server Content with the Reporting Services Web Portal
  • Distribute Reports with Subscriptions
  • Secure Report Server Resources

Course Outline

1. Introduction to SQL Server Reporting Services
  • Overview of Reporting Services
  • The Reporting Life Cycle
  • Reporting Services Architecture
  • Reporting Services Tools
2. Authoring Reports – Getting Started
  • Introduction to SQL Server Data Tools (SSDT)
  • Creating a Report Project
  • The Report Designer Environment
  • Table Reports
  • Grouping and Aggregating Data
  • Sorting Data
  • Using a Matrix
  • Using a List
  • Using Text Boxes, Lines, and Images
  • Formatting Reports
  • Page Breaks
  • Report Headers and Footers
  • Implementing Expressions
  • Using Variables
3. Enhancing Reports
  • Controlling Layout with Rectangles
  • Interactive Sorting
  • Drill-Down Reports
  • Document Maps
  • Bookmarks
4. Working with Parameters
  • Using Parameters to Restrict Query Results
  • Using Parameters to Filter Report Data
  • Creating Dynamic Parameter Lists
  • Cascading Parameters
  • Displaying User Selected Parameters in a Report
  • Subreports
  • Drill-Through Reports
5. Visualizing Data
  • Working with Charts
  • Gauges
  • Indicators and KPIs
  • Data Bars
  • Spark Lines
6. Using Report Builder
  • Overview of Report Builder
  • Designing a Report in Report Builder
  • Implementing Report Parts
7. Advanced Report Design
  • Implementing Maps with Spatial Data
  • Embedding Code in Reports
  • Creating Templates
  • Using Parameters with a Stored Procedure
  • Dynamic Data Sources and Datasets
  • Dynamic Grouping
  • Hiding/Showing Columns
  • Adjacent Groups
  • Recursive Hierarchy Grouping
  • Alternating Background Colours
  • Compact Grouping Layout
  • Handling the Absence of Data in a Report
8. Implementing Mobile Reports
  • Overview of Mobile Reports
  • Creating a Mobile Report
  • Publishing a Mobile Report
  • Creating a KPI
  • Creating a Drill-Through Mobile Report
9. Deploying Reports
  • Configuring Reporting Services
  • Deploying Reports
  • Introduction to the Reporting Services Web Portal
  • Executing Reports on Demand
10. Managing the Report Server
  • Managing Report Server Content
  • Linked Reports
  • Managing Data Source Properties
  • Caching Reports
  • Report Snapshots
  • Report History
  • The My Reports Folder
  • Rendering Reports to Different Formats
11. Distributing Reports with Subscriptions
  • Introduction to Report Subscriptions
  • Creating a Standard Subscription
  • Creating a Data-Driven Subscription
  • Managing Report Subscriptions
12. Controlling Access to Report Server Content
  • Securing Report Server Content
  • Implementing Data Security
  • Using URL Access to Display a Report

Private Courses

We can arrange your own private Microsoft SQL Server course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

What Our Clients Think

This course was excellent and I am delighted with how much I have achieved. The trainer was very friendly and approachable.

Rosie Heath - Licensed Trade Charity

Really good course. lots of hands on practice and clear explanations.

fiona dawe - Covetrus Global Software Services

Really enjoyed this course. It delivered exactly what I wanted out it.

Malkit Singh - Regatta Ltd

Got a really good and rounded training session. It met more than my original needs, and has given me great confidence.

Debbie Seymour - FatFace

This has been by far one of the most useful and well planned/executed training courses I have ever attended. For this to have been achieved remotely just adds to how impressive it was managed.

Trevor Stratton - Lincolnshire County Council

Very clear instruction, pace was kept moving, great snippets of advice given.

Robert Montgomery - Liberty Aluminium Technologies

Related Courses

System Admin Foundation 3 Days
Learn the essential skills necessary to maintain a Microsoft SQL Server 2016 or 2017 system infrastructure.
Systems Introduction 4 Days
Learn the full reporting lifecycle of designing, managing, and accessing reports in a Microsoft SQL Server 2016 or 2017 environment.
Systems Introduction 4 Days
You will learn to create SSIS projects and packages, work with Control Flow Tasks, and design Data Flows using a variety of transformations and data sources.
Programming Introduction 5 Days
Learn skills with the Microsoft Transact-SQL (T-SQL) language to query and program Microsoft SQL Server 2016 or 2017.