Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Do not give your attention to what others do or fail to do; give it to what you do or fail to do
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

Microsoft SQL Server Reporting Services 2014 - Level 2

2 days

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

If you require a tailored course click here