SQL Server Reporting Services
Course Description
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
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