 |
|
|
|
|
|
|
A wish changes nothing - a decision changes everything
|
 |
|
|
 |
|
|
|
| |
|
|
|
Microsoft SQL Server Reporting Services 2016 - Level 2
On completion of this course delegates will be able to design and deliver Analytical Business and Management Information reports, using the more advanced features of Microsoft SQL Server Reporting Services.
Target Audience: This course is designed for report designers, who have some experience of SQL Reporting Services and want to create dynamic and interactive reports, who are responsible for the creation and distribution of business and management reports.
Pre-requisites: Delegates must be able to use a Microsoft Windows and a mouse
Be able to create and write basic SQL commands and statements
Completed an Introduction Microsoft SQL Server Reporting Services 2008 course, or have the equivalent knowledge |
|
| Review of Level 1 Topics |
Review of Creating Report Projects
Review of Creating Datasources and Datasets
Review of Creating Reports
Review of Creating Basic Expressions
|
| Working with Matrix Data Regions |
Overview of the Matrix Data Regions
Adding Fields to Matrix Data Regions
Adding Groups to Matrix Columns and Rows
Adding Totals to Matrix
Adding Static Rows and Columns in Matrix
|
| Working with Report Properties |
|
| Working with Advanced Parameters Features |
Overview of Parameters
Creating Datasets for Parameters
Creating Cascade Parameters
Editing Parameter Properties
Creating Expressions with Parameter Report Item Collections
|
| Working with List Data Regions |
Overview of List Data regions
Adding Fields to List Data Regions
Adding Grouping and Sorting
Nesting Report Items with List Data Regions
|
| Creating Advanced Charts |
Overview of Chart Data Regions
Adding Chart Data Regions
Adding Values and Column Groups
Grouping Data by Series
Working with Chart Properties
Advanced Chart Formatting Properties
|
| Working with Indicators & Gauges |
Overview of Indicators and Gauges
Working with Indicators
Working with Gauges
Formatting Indicators and Gauges
|
| Working with SSRS Interactive Features |
Overview of Interactive Features
Adding Actions to Reports
Adding Dynamic Visibility
Using the Hidden Property
Using the ToggleItem Property
|
| Working with Sub Reports |
Overview of Sub Reports
Adding Sub Report Items to Reports
Working with Sub Report Item Properties
|
| Publishing Reports to Report Manager |
Setting Report Project Deployment Properties
Publishing Reports to Report Manager from Within Visual Studio
Publishing Reports from within Report Manager
|
|
|
|
