Enable Technology

Database 

SQL Server Reporting Services SSRS 2012/2014




Course Overview


Aimed at Report Writers using SQL Server Reporting Services (SSRS) 2012 and 2014 this intensive two day course demonstrates how to create and deploy parameterised reports using Report Builder and Report Designer. No prior Reporting Services experience is assumed but a reasonable grasp of SQL is essential.

Duration: 2 day course



Course Content


Introduction to SQL Server Reporting Services
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 a Customer Contact List 

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 Ad Hoc Reports with Report Builder
Create a Data Source Connection
Create A Shared DataSet for Northwind
Create a Report Based on a Shared Data Set 

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

Creating Reports with SQL Server Data Tools
Create and Configure a Report Server Project
Create Shared Data Sources and Data Sets
Create a Tabular Report 

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 Dialogue Box
No Data Rows
Groups before Row Headers
Synchronized Data Alignment 

Using the Tablix Report Type
Create a Shared Data Source and Two Data Sets
Create a Matrix Report
Create a Form-Like Report from a list

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
Field Collection
Globals Collection
User Collection
Report Items Collection
Variable Collection
Globals Collection

Creating Custom Functions
Creating a Custom Age Function
Sharing Custom Code with Multiple Reports

Calculations Using Expressions and Functions
Overview
Rein in the Length of a Text Field
Create a Custom Function 

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 Dialogue Box
Formatting Tablix Rows and Columns

Making Reports Interactive
Interactive Sorting
Drilldown Reports

Managing Page Layout and Adding Interactivity
Overview
Creating a Columnar Report
Create a Report with Interactive Sorting

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

Dynamic Reports with Parameters
Create a  Parameterised Report
Create a Drop-Down List Parameter
Work with Multivalued Parameters 

Enhancing Reports with Data Visualisations
Using Charts in a Report
Formatting a Chart 

Visualising Performance with Data Bars, Sparklines and Indicators
Data Bars
Sparkline
Indicators
Working with Maps and Spatial Data 

Enhancing Reports with Data Visualisation
Create a Pie Chart with Point Labels
Create a Map Report






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;