SQL SERVER REPORTING SERVICES TRAINING COURSES WORCESTER
About Enable Technology Worcester SQL Server Reporting Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Reporting Services training. The training will be delivered by a Microsoft professional with development experience. All course participants are issued SQL Server Reporting Services training manuals they can refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Reporting Services for as long as they need.
Enable Technology training courses are delivered as instructor led courses. This SQL Server Reporting Services course is delivered online during the current Covid 19 restrictions Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen. The SQL Server Reporting Services syllabus can be adjusted and additional topics incorporated if helpful.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Carillion PLC, Boots UK Limited, Cadbury PLC, Homeserve PLC, University of Birmingham, Loughborough University, Keele University and Dollond & Aitchison Limited.
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Worcester
- 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...
Ad-Hoc Reporting with Report Builder 2.0
Understand how to plan and configure for deployment
Explore the maintenance of report history
Learn how to calculate group totals and percentages
Investigate how to manage Reporting Services projects using Report Manager
Learn how to use URL to integrate Reporting Services reports into your applications
Explore creating groups
Understand scope as it applies to aggregate functions
Explore the potential deployment and security issues that might arise when working with custom assemblies
Programming Reporting Services
Investigate how to call a custom assembly from a report
Learn how to enable and control report caching
Discover the various global collections that you can reference in your expressions
Learn how to enable basic authentication for reports and how to require SSL for report operations
Learn how to create parameters in ad-hoc SQL
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Worcester
- 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 ... Building a Report with Report Builder
- See Training Course Details...
Groups before Row Headers
The Tablix Properties Dialogue Box
Overview
Create A Shared DataSet for Northwind
Expression Operators
Setting Report Project Properties
Report Project Files and Folders
Native Mode Architecture
Overview
Create a Data Source Connection
Report Project Configurations Creating a New Report in the Report Designer
Null Handling
Using Parameters with Ad Hoc SQL
Cascading Parameters
Writing and Using Report Expressions
Field Collection
Formatting a Chart Visualising Performance with Data Bars, Sparklines and Indicators
Report Builder Installation and Execution Options
Working with Maps and Spatial Data Enhancing Reports with Data Visualisation
Synchronized Data Alignment Using the Tablix Report Type
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Worcester
- 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 ... The Reporting Services 2005 Key Components
- See Training Course Details...
Creating a Chart Report
Report Groupings
Explorer Pane
Creating a Report Model File
Key Considerations
Security
Using Reporting Services 2005 Report Builder
Adding System-level Roles
Sorting
Model Statistics
Formatting Textboxes with the Textbox Properties Dialog
Accessing Reports via the Report Manager
The Reporting Services 2005 Layout View
Understanding Snapshots
Reporting Services 2005 Query and Report Parameters
Design Area
The Reporting Services 2005 Report Wizard
Deploying a Report Model
Previewing Reporting Services 2005 Reports
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Worcester
- 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 ... Introduction to SQL Server 2016 Report Builder
- See Training Course Details...
Exploring Subscriptions
Understanding Variances Between SQL Versions
Utilizing Data Sources
Planning Your Reports
Using the List Object to Combine Other Items
Understanding Visualizations
Examining Parameters
Examining Management
Filtering, Grouping, and Sorting
Working with Expressions
Using Tables
SQL Server 2016 Report Builder Wizards
Exploring Table or Matrix Wizard
Utilizing Lists
Mastering Data Region(s)
Understanding Report Parts
Working with Datasets
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Worcester
- 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 ... Preparing data for mobile reports
- See Training Course Details...
Topics include Introduction to Reporting Services
Configuring data access with report designer
Mobile report publisher
Extend reporting services functionality with external assemblies.
Report subscription and delivery Administering Reporting Services
Report sub-reports
Create a report using report builder or report designer.
Drillthrough in mobile reports
Reporting services components
Implementing report filters and parameters Visualizsng Data with Report Services
Images and charts
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Secure access to reports by using authentication, permissions, and SSL encryption.
Report parameters
Configuring data access with report builder
Work with expressions and embedded code.
Add a drillthrough to a custom URL
Use databars, sparklines, and indicators in reports Summarising Report Data
Formatting data
Report caching, snapshots, and comments
Email us about this courses
Other Worcester Enable Technology Training Courses
SSAS 2005 - Worcester SQL Server Analysis Services Training Courses
Access 2016 - Worcester Access Training Courses
Project 2016 Worcester Training Courses
Oracle SQL Worcester Training Courses
SSIS 2014 - Worcester SQL Server Integration Services Training Courses
SSIS 2005 - Worcester SQL Server Integration Services Training Courses
Power Query Worcester Training Courses
Access VBA Worcester Training Courses
PowerPoint Advanced - Worcester Office Training Courses
Microsoft Project Level 3 Worcester Training Courses
Excel Intermediate Worcester Training Courses
JavaScript Worcester Training Courses
Excel Power Pivot Worcester Training Courses
Crystal 2016 Worcester Training Courses
Crystal 2011 Worcester Training Courses
Midlands - Possible Sql Server Reporting Services Training Course Locations
Kidderminster, Warwick, Tipton, Rugeley, Shrewsbury, Telford, Shropshire, Bridgnorth, Halesowen, Stourbridge, Milton Keynes, Coventry, Worcester, Dudley, Staffordshire, Newcastle Under Lyme, Sandwell, Birmingham, Rugby, Leicestershire, Herefordshire, Staffordshire, Nottingham, Warwickshire, Redditch, Tamworth, Oxford, Hereford, East Midlands, Chester, Leicester, Derby, Stoke On Trent, Stratford Upon Avon, Nuneaton, Bromsgrove, Oswestry, Stourbridge, Rowley, Midlands, Bedworth, Evesham, Smethwick, Atherstone, Wednesbury, Kidsgrove, Leek, Kenilworth, Burton On Trent, Black Country, Worcestershire, Droitwich, Malvern, Lichfield, Northhampton, Stafford, Crewe, Uttoxeter, Wolverhampton, West Midlands, Solihull, Cheltenham, Cannock, Walsall, West Bromwich, Leamington Spa