SQL Server Reporting Services

In this course, you will learn how to use SQL Server Reporting Services, explore its architecture and gain an understanding of the components of SSRS . You will explore creation of ad hoc reports with Report Builder, using Data tools and Tablix reports. The reports will cover using expressions and functions, interactivity and dynamic reporting as well as enhancement of reports with data visualisation tools. This course is a solid introduction to getting the most from the well-established and effective SSRS toolset.

Duration
2 days
Format
Instructor-led, in person or live online

What the course covers

Prerequisites

This course assumes no prior knowledge of SQL Server Reporting Services. This course does assume prior knowledge of SQL Server and the use of SQL Server Management Studio for development.

INTRODUCTION TO SQL SERVER REPORTING SERVICES

  • Introduction
  • Reporting Services Modes
  • Installing and Configuring Reporting Services
  • Reporting Services Architecture
  • Native Mode Architecture
  • Service Architecture
  • Report Building Tools
  • Report Builder vs. Report Designer
  • Build a Simple Report
  • Report Definition Language (RDL)

CREATING AD HOC REPORTS WITH REPORT BUILDER

  • Introduction to Report Builder
  • Report Builder Installation and Execution Options
  • A Tour of the Report Builder Interface
  • Building a Report with Report Builder
  • Preview Performance
  • Using Report Parts
  • Shared Data Sets
  • Shared Data Sources
  • Shared Dataset Design View

CREATING REPORTS WITH SQL SERVER DATA TOOLS

  • Introducing SQL Server Data Tools
  • Installing SQL Server Data Tools
  • Report Project Types
  • Working with Report Server Projects
  • Report Project Files and Folders
  • Report Designer and Data Windows
  • Configuring Report Projects
  • Setting Report Project Properties
  • Report Project Configurations
  • Creating a New Report in the Report Designer
  • The Report Designer

USING THE TABLIX REPORT TYPE

  • Exploring the Tablix Report Type
  • The Tablix Component
  • Tablix Cell Content and Scope
  • Building a Tablix Report
  • Creating a Shared Data Source and Data Sets
  • Building a Tabular Report
  • Building a Matrix Report
  • Building a List Report
  • Configuring Tablix Properties and Groups
  • The Tablix Properties Dialog Box
  • No Data Rows
  • Groups before Row Headers
  • Synchronized Data Alignment

CALCULATIONS USING EXPRESSIONS AND FUNCTIONS

  • Writing and Using Report Expressions
  • Using the Expression Editor
  • Using Built-in Report Operators and Functions
  • Expression Operators
  • Built-In Functions
  • Null Handling
  • The Global Collections
  • Fields Collection
  • Globals Collection
  • User Collection
  • ReportItems Collection
  • Variables Collection
  • Globals Collection
  • Creating Custom Functions
  • Creating a Custom Age Function
  • Sharing Custom Code with Multiple Reports

MANAGING PAGE LAYOUT AND ADDING INTERACTIVITY

  • Designing the Page Layout
  • Considering Report Layout Options
  • Page Structure Properties
  • Page Headers and Footers
  • Report Formatting Options
  • Formatting Text Boxes from the Toolbars
  • Formatting Text Boxes in the Properties Window
  • Formatting Text Boxes in the Text Box Properties Dialog Box
  • Formatting Tablix Rows and Columns
  • Making Reports Interactive
  • Interactive Sorting
  • Drilldown Reports

DYNAMIC REPORTS WITH PARAMETERS

  • Creating Report Parameters
  • Parameters and Stored Procedures
  • Using Parameters with Ad Hoc SQL
  • Using Unbound Parameters
  • Understanding Report and Data Set Parameters
  • Report Parameters
  • Data Set Parameters
  • Reordering Report Parameters
  • Using Drop-Down List Parameters
  • Providing a Drop-Down List for a Report Parameter
  • Displaying the Parameter Value and Label for a Drop-Down List Parameter
  • Cascading Parameters
  • Multivalued Parameters

ENHANCING REPORTS WITH DATA VISUALIZATION

  • Using Charts in a Report
  • Formatting a Chart
  • Visualizing Performance with Data Bars, Sparklines, and Indicators
  • Data Bars
  • Sparklines
  • Indicators
  • Working with Maps and Spatial Data

Course dates

There are no public dates for this course yet. We also run it on request for teams. Contact us to arrange a date.