iTrain Scotland IT Training Edinburgh image

Microsoft SQL Server 2014 Reporting Services

iTrain Scotland IT Training Edinburgh image

Home > Courses > SQL courses > Microsoft SQL Server 2014 Reporting Services

Microsoft SQL Server 2014 Reporting Services

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 2014 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 using Analysis Services as a data source, making your reports more dynamic (such as allowing users to interactively select groups for a matrix through parameters), alternating background colours for table rows, and other handy tips to enable developers to design truly professional reports. 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. For example, clients interested only in report development could attend just the first 3 days of the course omitting Report Server management ordinarily covered on day 4.

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 2014 (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: Querying Data for Report Developers”, would be an ideal primer for anyone considering taking this course.

Upon successful completion of the full 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
  • Set up Report Publishing and Execution Settings
  • Manage Report Server Content with Report Manager
  • Distribute Reports with Subscriptions
  • Secure Report Server Resources



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



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


Drill-Through Reports


5. Visualizing Data

Working with Charts


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

Using an Analysis Services Data Source

Implementing Maps with Spatial Data

Embedding Code in Reports

Implementing Custom Assemblies

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

Other Report Design Tips and Tricks




8. Deploying Reports

Configuring Reporting Services

Deploying Reports

Introduction to the Report Manager

Executing Reports on Demand


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


10. Distributing Reports with Subscriptions

Introduction to Report Subscriptions

Creating a Standard Subscription

Creating a Data-Driven Subscription

Managing Report Subscriptions


11. Controlling Access to Report Server Content

Securing Report Server Content

Implementing Data Security

Using URL Access to Display a Report

Prices below are for scheduled courses held in our Edinburgh Training Centre. Major discounts available for onsite or private courses: click General Enquiry button below to enquire about private courses.
Group discount
1 place £ 3000 n/a
2 places £ 3600 n/a
3 places £ 9000 £ 4200
4 places £ 12000 £ 4800
5 places £ 15000 £ 5400
6 places £ 18000 £ 6000
7 places £ 21000 £ 6600
8 places £ 24000 £ 7200