SQL SERVER REPORTING SERVICES TRAINING COURSES CHESHIRE
About Enable Technology Cheshire SQL Server Reporting Services Training Courses
Enable Technology offer short intensive skills based SQL Server Reporting Services training courses. The tutor delivering the course will be a Microsoft certified expert. All candidates receive comprehensive SQL Server Reporting Services training materials and practice files which are theirs to refer to after the course. We also provide an ongoing support service to people attending our SQL Server Reporting Services courses. Delegates can contact the course tutor with specific SQL Server Reporting Services questions for as long as they need following the course.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. This instructor led course is available online only during the current lockdown. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Reporting Services training needs.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Royal & Sun Alliance Group PLC, Shell UK Oil Products Ltd, University of Birmingham, Countrywide Homes Limited, Birmingham Heartlands Hospital, Nationwide Building Society Limited, Yell Group PLC and TalkTalk Direct Limited.
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 ... Native Mode Architecture
- See Training Course Details...
Globals Collection Creating Custom Functions
Report Parameters
Formatting Text Boxes in the Text Box Properties Dialogue Box
Formatting Text Boxes in the Properties Window
Sparkline
Build a Simple Report
Create a Custom Function Managing Page Layout and Adding Interactivity
Create a Matrix Report
Create a Parameterised Report
Report Builder Installation and Execution Options
Cascading Parameters
Create a Shared Data Source and Two Data Sets
User Collection
Creating a Customer Contact List Creating Ad Hoc Reports With Report Builder
Page Structure Properties
Installing SQL Server Data Tools
Displaying the Parameter Value and Label for a Drop-Down List Parameter
Building a Matrix Report
Building a List Report Configuring Tablix Properties and Groups
Multivalued Parameters Dynamic Reports with Parameters
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 ... Report sub-reports
- See Training Course Details...
Topics include Introduction to Reporting Services
Sorting and grouping
Using Datasets Creating Paginated Reports
Report caching, snapshots, and comments
Report subscription and delivery Administering Reporting Services
Mobile report publisher
Formatting data
Drillthrough in mobile reports
Databars, sparklines, indicators, gauges, and maps
Overview of mobile reports
Data filters
Report parameters
Extend reporting services functionality with external assemblies.
Creating a report with the report wizard
Work with expressions and embedded code.
Configuring data access with report builder
Publish a report to reporting services Working with Reporting Services Data
Preparing data for mobile reports
Reporting services components
Secure access to reports by using authentication, permissions, and SSL encryption.
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 ... Creating a Report Model Data Source
- See Training Course Details...
Entities
History Properties
Report Server Components
Deploying the Auditing and Management Reports
Saving a Report
Database Components
Modifying the Data Source View
Security
Rendering Extensions
Tables Pane
Resizing
Interactive Sort
Understanding Reporting Services 2005 Caching
Fields tab
Reporting Services 2005 Security Model Concepts
Reporting Services 2005 Distribution Options
Using the Report Manager
Managing Tables with the Table Properties Dialog
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 ... Learn how to use URL to integrate Reporting Services reports into your applications
- See Training Course Details...
Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place
Master the Reporting Services Grouping pane
Dig into the use of unbound, multivalued, and cascading parameters
Investigate what SQL Server Reporting Services can do
Advanced Reporting Services Programming
Find out how to create drill-down reports
Understand scope as it applies to aggregate functions
Learn how to solve common parameter issues
Investigate how Reporting Services secures access to reports and other Reporting Services resources
Snapshots and Subscriptions
Learn how to create a tabular report from scratch
Grouping and Sorting
Discover how to create standard report subscriptions
Learn about datasets and data regions
Explore the use of Reporting Services gauges
Explore how to create expressions in your reports using
Learn how to create custom functions using the Code window
Learn about report variables and when you might need to use them
Learn how to call the Report Server Web Service
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 ... Examining Parameters
- See Training Course Details...
Utilizing Data Sources
Exploring the Report Builder Interface
Visualizing Your Company Report Templates
Working with Map Wizard
Utilizing Chart Wizard
SQL Server 2016 Report Builder Wizards
Exploring Matrix
Utilizing Lists
Examining Management
Introduction to SQL Server 2016 Report Builder
Creating Subreports and Drillthrough Reports
Working with Datasets
Understanding Variances Between SQL Versions
Using the List Object to Combine Other Items
SQL Server 2016 Report Builder Graphics
Exploring Table or Matrix Wizard
Using Tables
Exploring Subscriptions
Filtering, Grouping, and Sorting
Email us about this courses
Other Cheshire Enable Technology Training Courses
Access 2016 Cheshire Training Courses
Project 2016 Cheshire Training Courses
Access VBA - Cheshire Access Training Courses
JQuery Mobile Cheshire Training Courses
VBA - Cheshire Excel Training Courses
Visio 2013 - Cheshire Visio Training Courses
Crystal 2016 - Cheshire Crystal Reports Training Courses
SQL Cheshire Training Courses
Excel Power Pivot Cheshire Training Courses
Excel Advanced Cheshire Training Courses
SSIS 2014 - Cheshire SQL Server Integration Services Training Courses
JQuery Cheshire Training Courses
TSQL Cheshire Training Courses
PHP Cheshire Training Courses
Oracle SQL Cheshire Training Courses
North West - Possible Sql Server Reporting Services Training Course Locations
Leigh, Lytham Urmston, Widnes, Blackpool, Warrington, Saddleworth, Bury, Leyland, Chester, Sale, Merseyside, Stretford, Birkenhead, Lancashire, Crosby, Denton, Ellesmere Port, Salford, Morecambe, Kirkby, Macclesfield, Eccles, Lancaster, Bootle, Oldham, Middleton, Chadderton, Prestwich, Hyde, Ashton-under-Lyne, Altrincham, Winsford, Barrow-in-Furness, Wythenshawe, Blackburn, Liverpool, Rochdale, Burnley, Accrington, Cheshire, Southport, Chorley, Skelmersdale, Wigan, Stockport, Bolton, Farnworth, North West, Carlisle, Crewe, Runcorn, Northwich, Preston, Wallasey, Thornton-Cleveleys, Manchester, Huyton