SQL SERVER REPORTING SERVICES TRAINING COURSES SUNDERLAND
About Enable Technology Sunderland SQL Server Reporting Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Reporting Services skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each person attending a course takes away SQL Server Reporting Services courseware which can be used as reference materials after the training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Reporting Services course can contact the tutor for as long as they like if they encounter SQL Server Reporting Services problems.
We provide instructor led training coupled with hands on training. While social distancing is in place we are only delivering SQL Server Reporting Services courses via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance. We will work with you prior to the course to tailor the SQL Server Reporting Services syllabus to match your requirements.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Unipart Group, Loughborough University, Homeserve PLC, Canadian High Commission, Dollond & Aitchison Limited, GKN PLC, Norfolk Police Constabulary and Fujistu PLC.
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Sunderland
- 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 ... Creating Tabular and List Reports
- See Training Course Details...
Dig into the use of unbound, multivalued, and cascading parameters
Discover interactive sorting
Find out how you can use conditional formatting to make your reports more dynamic
Calculation and Formatting
Advanced Reporting Services Programming
Learn about report variables and when you might need to use them
Learn how to calculate group totals and percentages
Explore the potential deployment and security issues that might arise when working with custom assemblies
Grouping and Sorting
Introducing SQL Server Reporting Services
Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services
Learn about datasets and data regions
Explore how to use Report Builder to build ad-hoc tabular, matrix and chart reports Discover how to create Report Builder reports without using the wizards
Discover how to create standard report subscriptions
Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services
Explore the storing of credentials within a data source
Understand scope as it applies to aggregate functions
Investigate how to manage Reporting Services projects using Report Manager
Managing Reporting Services
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Sunderland
- 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 ... Filters
- See Training Course Details...
Sorting
Understanding System-level Roles
Web Folder Properties
Tools for Managing Reports
Reporting Services 2005 Windows
Deploying the Auditing and Management Reports
Clickthrough Reports
Execution Properties
Modifying the Data Source View
Using the Reporting Services 2005 Graphical Query Designer
Creating a Data Source View
Building a Table Report
Create a Database for Report Execution Data
Previewing a Report
Perspectives
Data Output
Toolbar
Visual Studio 2005 and Development Studio
Creating a New Report Project
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Sunderland
- 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 ... Extend reporting services functionality with external assemblies.
- See Training Course Details...
Report parameters
Drilldown and drill through Sharing Reporting Services Reports
Data filters
Reporting services tools Reporting Services Data Sources
Formatting data
Secure access to reports by using authentication, permissions, and SSL encryption.
Configuring data access with report designer
Overview of mobile reports
Drillthrough in mobile reports
Mobile report publisher
Implementing report filters and parameters Visualizsng Data with Report Services
Configuring data access with report builder
Report subscription and delivery Administering Reporting Services
Publish a report to reporting services Working with Reporting Services Data
Databars, sparklines, indicators, gauges, and maps
Sorting and grouping
Images and charts
Create a report using report builder or report designer.
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Preparing data for mobile reports
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Sunderland
- 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 ... Shared Data Sources
- See Training Course Details...
Report Builder vs. Report Designer
Creating a Customer Contact List Creating Ad Hoc Reports With Report Builder
Overview
Create a Matrix Report
Reporting Services Modes
Report Parameters
Globals Collection
Create A Shared DataSet for Northwind
Report Project Types Working with Report Server Projects
The Tablix Properties Dialogue Box
Create and Configure a Report Server Project
Field Collection
Sparkline
Create a Drop-Down List Parameter
Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
Working with Maps and Spatial Data Enhancing Reports with Data Visualisation
Parameters and Stored Procedures
Work with Multivalued Parameters Enhancing Reports with Data Visualisations
Report Items Collection
Null Handling
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Sunderland
- 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 ... Using the List Object to Combine Other Items
- See Training Course Details...
Utilizing Chart Wizard
Examining Maps
Working with Map Wizard
Using Tables
Examining Management
Utilizing Lists
Examining Parameters
Creating Subreports and Drillthrough Reports
Exploring the Report Builder Interface
Exploring Table or Matrix Wizard
SQL Server 2016 Report Builder Graphics
Filtering, Grouping, and Sorting
Understanding Visualizations
Introduction to SQL Server 2016 Report Builder
Mastering Data Region(s)
Working with Datasets
Email us about this courses
Other Sunderland Enable Technology Training Courses
DAX - Sunderland Excel Training Courses
HTML - Sunderland Web Development Training Courses
Access 2016 - Sunderland Access Training Courses
SSAS 2017 Sunderland Training Courses
JavaScript - Sunderland JavaScript Training Courses
SSIS 2008 Sunderland Training Courses
Excel Power Pivot - Sunderland Excel Training Courses
Access VBA Sunderland Training Courses
HTML - Sunderland Web Development Training Courses
SSAS 2014 - Sunderland SQL Server Analysis Services Training Courses
PowerPoint Basic - Sunderland Office Training Courses
SSAS Tabular - Sunderland SQL Server Analysis Services Training Courses
Excel Basic - Sunderland Excel Training Courses
Project 2016 L1 Sunderland Training Courses
SSIS 2014 Sunderland Training Courses
North - Possible Sql Server Reporting Services Training Course Locations
Harrogate, Castleford, Leeds, Pudsey, Wakefield, Hexham, Rotherham, Sunderland, Hartlepool, Newcastle Upon Tyne, York, Wetherby, South Shields, Dewsbury, Huddersfield, Normanton, Bridlington, Doncaster, Middlesbrough, Barnsley, Yorkshire, Scunthorpe, Scarborough, Batley, Sheffield, North East, Halifax, Durham, Keighley, Gateshead, Grimsby