SQL SERVER REPORTING SERVICES TRAINING COURSES CHESHIRE
About Enable Technology Cheshire SQL Server Reporting Services Training Courses
We offer intensive two and three days SQL Server Reporting Services courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant is given SQL Server Reporting Services courseware which they can refer to after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Reporting Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can set up a training lab at your premises and deliver SQL Server Reporting Services courses onsite at your site. If delivery onsite is an issue we will organise a socially distanced venue near you in Cheshire. Every SQL Server Reporting Services course can be modified to meet your bespoke requirements.
We also deliver this course online. Delegates participate in a virtual SQL Server Reporting Services class and can both talk to and share their screen with the tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Norwich Union PLC, Birmingham City Council, Carillion PLC, Capita Group PLC, Dollond & Aitchison Limited, TalkTalk Direct Limited, Unipart Group and GKN PLC.
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Cheshire
- Telephone on 01952 305730
- Course Outline
-
This three day intensive course will give delegates a comprehensive understanding of how to design and publish parametrised reports, manage permissions, schedule automated reporting and configure report caching. The course also demonstrates how to build reports designed for tablets and mobile devices.
- Some of the training topics covered include ... Drillthrough in mobile reports
- See Training Course Details...
Add a drillthrough to a custom URL
Drilldown and drill through Sharing Reporting Services Reports
Work with expressions and embedded code.
Report caching, snapshots, and comments
Introduction to reporting services
Report parameters
Topics include Introduction to Reporting Services
Reporting services tools Reporting Services Data Sources
Use databars, sparklines, and indicators in reports Summarising Report Data
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Configuring data access with report builder
Sorting and grouping
Secure access to reports by using authentication, permissions, and SSL encryption.
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Implementing report filters and parameters Visualizsng Data with Report Services
Report sub-reports
Formatting data
Extend reporting services functionality with external assemblies.
Use report services configuration manager to reconfigure SSRS servers.
Creating a report with the report wizard
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Cheshire
- Telephone on 01952 305730
- Course Outline
-
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.
- Some of the training topics covered include ... Variable Collection
- See Training Course Details...
Sparkline
Introduction to Report Builder
Report Items Collection
Built-in Functions
Groups before Row Headers
Create a Custom Function Managing Page Layout and Adding Interactivity
Tablix Cell Content and Scope Building a Tablix Report
Building a Report with Report Builder
Create a Parameterised Report
The Tablix Properties Dialogue Box
Creating a Customer Contact List Creating Ad Hoc Reports With Report Builder
Create a Form-Like Report from a list Calculations Using Expressions And Functions
Indicators
Using Unbound Parameters Understanding Report And Data Set Parameters
Considering Report Layout Options
Interactive Sorting
Work with Multivalued Parameters Enhancing Reports with Data Visualisations
Building a Tabular Report
Create a Data Source Connection
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Cheshire
- Telephone on 01952 305730
- Course Outline
-
Aimed at Data Analysts and SQL users this instructor-led course provides participants with the necessary knowledge to develop reports using Microsoft SQL Server 2016 Report Builder. The course covers Report Builder wizards, basics of report design, report parameters, report expressions, filters, report visualisations including graphs, charts, images and gauges. The course also covers the use of maps, interactive reports, report parts, sub reports, subscriptions and exporting options.
- Some of the training topics covered include ... SQL Server 2016 Report Builder Graphics
- See Training Course Details...
SQL Server 2016 Report Builder Advanced Reporting
Utilizing Charts
Examining Security
Filtering, Grouping, and Sorting
Working with Map Wizard
Working with Expressions
Using the List Object to Combine Other Items
Utilizing Data Sources
Understanding HTML5 and Textboxes
Exploring Matrix
Examining Maps
Planning Your Reports
Exploring Subscriptions
Using Tables
Examining Parameters
Utilizing Dynamic Headers and Footers
Understanding Variances Between SQL Versions
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Cheshire
- Telephone on 01952 305730
- Course Outline
-
This is a two day course which equips participants with the skills necessary to effectively use SQL Server 2005 Reporting Services. Enable Technology also run a comparable two day Reporting Services 2000 training course.
- Some of the training topics covered include ... Report Item Style Properties
- See Training Course Details...
The Management Studio Object Explorer
Report Server Components
Diagram Organizer Pane
Using the Reporting Services 2005 Graphical Query Designer
Changing Columns and Rows
Included Reporting Services 2005 Extensions
Formatting
Security
General
Default Folder Structure
Report Builder Design Layout
Sorting
Using the Report Manager
Adding an Item-Level Role
Database Components
Adding Data Fields to a Table Data Region
Understanding Report Builder
Drawing Lines and Rectangles
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Cheshire
- Telephone on 01952 305730
- Course Outline
-
A two day intensive course introducing the comprehensive range of SQL Server Reporting Services 2008 report writing and deployment features.
- Some of the training topics covered include ... Find out how to create drill-down reports
- See Training Course Details...
Find out how to use Report Manager to manage user accounts and roles
Discover the many application programming interfaces of Reporting Services
Understand how to plan and configure for deployment
Explore how to create expressions in your reports using
Learn about report variables and when you might need to use them
Investigate the scheduling of report snapshots
Learn how to enable and control report caching
Learn how to solve common parameter issues
Snapshots and Subscriptions
Learn how to create parameters in ad-hoc SQL
Discover how to improve parameter prompts using drop-down list parameters
Investigate the list data region
Calculation and Formatting
Find out how you can use conditional formatting to make your reports more dynamic
Gain a basic understanding of the components behind SQL Server Reporting Services
Learn how to create a basic report using the SQL Server Reporting Services Wizard
Learn how to deploy Reporting Services projects and individual reports and data sources
Email us about this courses
Other Cheshire Enable Technology Training Courses
Crystal 2008 - Cheshire Crystal Reports Training Courses
Power BI - Cheshire Microsoft Power BI Training Courses
SQL - Cheshire SQL Training Courses
Microsoft Project Level 2 - Cheshire Microsoft Project Training Courses
HTML Cheshire Training Courses
Access VBA Cheshire Training Courses
PowerPoint Advanced - Cheshire Office Training Courses
SSAS Tabular Cheshire Training Courses
CSS - Cheshire Web Development Training Courses
PL/SQL Cheshire Training Courses
VBA - Cheshire Excel Training Courses
Crystal 2011 - Cheshire Crystal Reports Training Courses
DAX - Cheshire Excel Training Courses
Power Graphics - Cheshire Data Analytics Training Courses
SSIS 2005 Cheshire Training Courses
North West - Possible Sql Server Reporting Services Training Course Locations
Wigan Sql Server Reporting Services Training Courses Wigan, Crosby, Salford, Crewe, Blackpool, Widnes, Denton, Prestwich, Ellesmere Port, Leigh, Northwich, Morecambe, Stockport, Lancashire, Leyland, Bolton, Runcorn, Warrington, Ashton-under-lyne, Bury, Oldham, Wythenshawe, Altrincham, Cheshire, Wallasey, Farnworth, Accrington, Middleton, Barrow-in-furness, Skelmersdale, Rochdale, Liverpool, Saddleworth, Merseyside, Birkenhead, Lytham Urmston, Blackburn, North West, Burnley, Hyde, Sale, Chorley, Thornton-cleveleys, Carlisle, Winsford, Preston, Kirkby, Lancaster, Bootle, Chester, Manchester, Stretford, Eccles, Chadderton, Huyton, Southport, Macclesfield
Crosby Sql Server Reporting Services Training Courses
Salford Sql Server Reporting Services Training Courses
Crewe Sql Server Reporting Services Training Courses
Blackpool Sql Server Reporting Services Training Courses
Widnes Sql Server Reporting Services Training Courses
Denton Sql Server Reporting Services Training Courses
Prestwich Sql Server Reporting Services Training Courses
Ellesmere Port Sql Server Reporting Services Training Courses
Leigh Sql Server Reporting Services Training Courses
Northwich Sql Server Reporting Services Training Courses
Morecambe Sql Server Reporting Services Training Courses
Stockport Sql Server Reporting Services Training Courses
Lancashire Sql Server Reporting Services Training Courses
Leyland Sql Server Reporting Services Training Courses
Bolton Sql Server Reporting Services Training Courses
Runcorn Sql Server Reporting Services Training Courses
Warrington Sql Server Reporting Services Training Courses
Ashton-under-Lyne Sql Server Reporting Services Training Courses
Bury Sql Server Reporting Services Training Courses
Oldham Sql Server Reporting Services Training Courses
Wythenshawe Sql Server Reporting Services Training Courses
Altrincham Sql Server Reporting Services Training Courses
Cheshire Sql Server Reporting Services Training Courses
Wallasey Sql Server Reporting Services Training Courses
Farnworth Sql Server Reporting Services Training Courses
Accrington Sql Server Reporting Services Training Courses
Middleton Sql Server Reporting Services Training Courses
Barrow-in-Furness Sql Server Reporting Services Training Courses
Skelmersdale Sql Server Reporting Services Training Courses
Rochdale Sql Server Reporting Services Training Courses
Liverpool Sql Server Reporting Services Training Courses
Saddleworth Sql Server Reporting Services Training Courses
Merseyside Sql Server Reporting Services Training Courses
Birkenhead Sql Server Reporting Services Training Courses
Lytham Urmston Sql Server Reporting Services Training Courses
Blackburn Sql Server Reporting Services Training Courses
North West Sql Server Reporting Services Training Courses
Burnley Sql Server Reporting Services Training Courses
Hyde Sql Server Reporting Services Training Courses
Sale Sql Server Reporting Services Training Courses
Chorley Sql Server Reporting Services Training Courses
Thornton-Cleveleys Sql Server Reporting Services Training Courses
Carlisle Sql Server Reporting Services Training Courses
Winsford Sql Server Reporting Services Training Courses
Preston Sql Server Reporting Services Training Courses
Kirkby Sql Server Reporting Services Training Courses
Lancaster Sql Server Reporting Services Training Courses
Bootle Sql Server Reporting Services Training Courses
Chester Sql Server Reporting Services Training Courses
Manchester Sql Server Reporting Services Training Courses
Stretford Sql Server Reporting Services Training Courses
Eccles Sql Server Reporting Services Training Courses
Chadderton Sql Server Reporting Services Training Courses
Huyton Sql Server Reporting Services Training Courses
Southport Sql Server Reporting Services Training Courses
Macclesfield Sql Server Reporting Services Training Courses