SQL SERVER REPORTING SERVICES TRAINING COURSES HEXHAM
About Enable Technology Hexham SQL Server Reporting Services Training Courses
We have a twenty year history of providing skills based SQL Server Reporting Services industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away SQL Server Reporting Services courseware which can be used as reference materials after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. This SQL Server Reporting Services course is available online during the Covid 19 crisis. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor. The SQL Server Reporting Services syllabus can be adjusted and additional topics incorporated if helpful.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are University of Birmingham, Birmingham City University, Wolverhampton City Council, Barclays Bank PLC, Royal & Sun Alliance Group PLC, Vodafone Group Services, Norfolk Police Constabulary and GKN PLC.
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Hexham
- 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 ... Globals Collection Creating Custom Functions
- See Training Course Details...
Expression Operators
Report Builder vs. Report Designer
Formatting Text Boxes in the Properties Window
Using Unbound Parameters Understanding Report And Data Set Parameters
Report Project Configurations Creating a New Report in the Report Designer
Multivalued Parameters Dynamic Reports with Parameters
Create a Form-Like Report from a list Calculations Using Expressions And Functions
Installing SQL Server Data Tools
Working with Maps and Spatial Data Enhancing Reports with Data Visualisation
Create a Data Source Connection
Formatting Tablix Rows and Columns Making Reports Interactive
A Tour of the Report Builder Interface
Reporting Services Modes
Indicators
Building a Matrix Report
Overview
Introducing SQL Server Data Tools
Introduction to SQL Server Reporting Services
The Tablix Properties Dialogue Box
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Hexham
- 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 ... Work with expressions and embedded code.
- See Training Course Details...
Schedules
Use report services configuration manager to reconfigure SSRS servers.
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Images and charts
Data filters
Preparing data for mobile reports
Using Datasets Creating Paginated Reports
Report parameters
Introduction to reporting services
Configuring data access with report builder
Drillthrough in mobile reports
Configuring data access with report designer
Create a report using report builder or report designer.
Sorting and grouping
Creating a report with the report wizard
Reporting services tools Reporting Services Data Sources
Report sub-reports
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Drilldown and drill through Sharing Reporting Services Reports
Use databars, sparklines, and indicators in reports Summarising Report Data
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Hexham
- 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 Wizards
- See Training Course Details...
Examining Management
Understanding Visualizations
Exploring Matrix
Working with Map Wizard
Understanding Variances Between SQL Versions
Using Tables
Utilizing Data Sources
Utilizing Chart Wizard
Planning Your Reports
Working with Expressions
Creating Subreports and Drillthrough Reports
Understanding HTML5 and Textboxes
Utilizing Lists
SQL Server 2016 Report Builder Advanced Reporting
Exploring Subscriptions
Examining Parameters
Using the List Object to Combine Other Items
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Hexham
- 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 Matrix Reports and Charts
- See Training Course Details...
Find out how to create drill-down reports
Learn about datasets and data regions
Learn about report variables and when you might need to use them
Snapshots and Subscriptions
Ad-Hoc Reporting with Report Builder 2.0
Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server
Introducing SQL Server Reporting Services
Learn how to enable and control report caching
Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services
Learn how to use URL to integrate Reporting Services reports into your applications
Learn how to calculate group totals and percentages
Explore the use of Reporting Services gauges
Investigate what SQL Server Reporting Services can do
Learn how to create data-driven report subscriptions
Learn how to deploy Reporting Services projects and individual reports and data sources
Understand how to plan and configure for deployment
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Hexham
- 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 ... Reporting Services 2005 Client Components
- See Training Course Details...
Reporting Services 2005 Administration
Parts of the Chart
Adding or Deleting
Server Management Reports
Rendering Extensions
Adding Groups and Users
Creating a Report Model Project
Previewing Reporting Services 2005 Reports
Understanding Users and Groups
Design the Query Dialog
Managing Parameters
Current Classroom Folder Structure
Reporting Services 2005 Distribution Options
Reporting Services 2005 Menus
Adding a Table Data Region
Setting the Reporting Services 2005 Report Properties
Visibility
Create a Data Source
Creating a Subscription
Create a Database for Report Execution Data
Email us about this courses
Other Hexham Enable Technology Training Courses
TSQL Hexham Training Courses
Crystal 2013 Hexham Training Courses
Excel Basic - Hexham Excel Training Courses
PowerPoint Basic - Hexham Office Training Courses
PHP Hexham Training Courses
SSAS 2017 - Hexham SQL Server Analysis Services Training Courses
HTML Hexham Training Courses
VBA Hexham Training Courses
Power Query - Hexham Excel Training Courses
Microsoft Project Level 2 - Hexham Microsoft Project Training Courses
Crystal XI - Hexham Crystal Reports Training Courses
Microsoft Project Level 3 Hexham Training Courses
CSS - Hexham Web Development Training Courses
Access VBA - Hexham Access Training Courses
PL/SQL - Hexham SQL Training Courses
North - Possible Sql Server Reporting Services Training Course Locations
Castleford, Leeds, Harrogate, York, Huddersfield, Halifax, Wetherby, Yorkshire, Doncaster, Hartlepool, South Shields, Bridlington, Grimsby, Sheffield, Newcastle Upon Tyne, Normanton, Durham, Barnsley, Rotherham, Scunthorpe, Keighley, Middlesbrough, Sunderland, Gateshead, North East, Pudsey, Dewsbury, Batley, Hexham, Wakefield, Scarborough