SQL SERVER REPORTING SERVICES TRAINING COURSES LEAMINGTON SPA
About Enable Technology Leamington Spa SQL Server Reporting Services Training Courses
Enable Technology offer short intensive skills based SQL Server Reporting Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training SQL Server Reporting Services resources which they can continue to use after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Reporting Services queries.
SQL Server Reporting Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. During the Covid 19 crisis we can 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. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Reporting Services course to some extent is bespoke and tailored to your needs.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Norfolk Police Constabulary, Wolverhampton City Council, Capita Group PLC, Vodafone Group Services, Norwich Union PLC, Cadbury PLC, Royal Air Force and Halfords Group PLC.
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Leamington Spa
- 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 ... Create a report using report builder or report designer.
- See Training Course Details...
Drilldown and drill through Sharing Reporting Services Reports
Introduction to reporting services
Topics include Introduction to Reporting Services
Reporting services tools Reporting Services Data Sources
Secure access to reports by using authentication, permissions, and SSL encryption.
Report parameters
Mobile report publisher
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Using Datasets Creating Paginated Reports
Work with expressions and embedded code.
Add a drillthrough to a custom URL
Extend reporting services functionality with external assemblies.
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Overview of mobile reports
Preparing data for mobile reports
Data filters
Publish a report to reporting services Working with Reporting Services Data
Creating a report with the report wizard
Reporting services components
Configuring data access with report designer
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Leamington Spa
- 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 ... Investigate how Reporting Services secures access to reports and other Reporting Services resources
- See Training Course Details...
Understand how to plan and configure for deployment
Creating Matrix Reports and Charts
Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services
Learn about report variables and when you might need to use them
Learn how to enable basic authentication for reports and how to require SSL for report operations
Investigate Reporting Services charts
Find out how to create drill-down reports
Learn how to calculate group totals and percentages
Discover how to create standard report subscriptions
Learn how to deploy Reporting Services projects and individual reports and data sources
Understanding how Reporting Services parameters work with stored procedure parameters
Explore the use of Reporting Services gauges
Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services
Discover the many application programming interfaces of Reporting Services
Working with Parameters
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Leamington Spa
- 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 ... Tools for Managing Reports
- See Training Course Details...
Drawing Lines and Rectangles
Creating a Report Model Data Source
Security
Choose Table Style or Matrix Style Dialog
Understanding Reporting Services 2005 Caching
Model Designer Layout
Building a Table Report
Design the Query Dialog
Query tab
Visual Studio 2005 and Development Studio
Fields tab
The Reporting Services 2005 Report Designer
Key Considerations
Adding Groups to Reporting Services
The Reporting Services 2005 Key Components
Custom Data Processing Extensions
Installing Auditing and Management Reports
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Leamington Spa
- 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 ... Working with Expressions
- See Training Course Details...
Using the List Object to Combine Other Items
Exploring Matrix
Understanding HTML5 and Textboxes
Using Tables
Formatting Reports
Exploring Table or Matrix Wizard
Understanding Report Parts
Introduction to SQL Server 2016 Report Builder
Examining Parameters
SQL Server 2016 Report Builder Advanced Reporting
SQL Server 2016 Report Builder Wizards
Examining Management
Utilizing Charts
Examining Security
Exploring Subscriptions
Mastering Data Region(s)
Planning Your Reports
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Leamington Spa
- 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 ... Creating Report Parameters
- See Training Course Details...
Create a Report with Interactive Sorting Dynamic Reports with Parameters
Report Builder vs. Report Designer
Introduction to SQL Server Reporting Services
Report Project Types Working with Report Server Projects
Create a Drop-Down List Parameter
Field Collection
Report Project Files and Folders
Overview
Report Builder Installation and Execution Options
Create a Map Report
Data Set Parameters
Create a Form-Like Report from a list Calculations Using Expressions And Functions
Building a List Report Configuring Tablix Properties and Groups
Create a Matrix Report
Building a Tabular Report
Null Handling
The Report Designer Creating Reports with SQL Server Data Tools
Using the Expression Editor Using Built-in Report Operators and Functions
Displaying the Parameter Value and Label for a Drop-Down List Parameter
Email us about this courses
Other Leamington Spa Enable Technology Training Courses
SSAS 2005 - Leamington Spa SQL Server Analysis Services Training Courses
Excel Advanced - Leamington Spa Excel Training Courses
Project 2016 Leamington Spa Training Courses
Data Mining - Leamington Spa Data Analytics Training Courses
Access VBA Leamington Spa Training Courses
Data Warehouse Leamington Spa Training Courses
SSAS 2008 - Leamington Spa SQL Server Analysis Services Training Courses
SSAS Tabular Leamington Spa Training Courses
JQuery Leamington Spa Training Courses
PL/SQL - Leamington Spa SQL Training Courses
DAX Leamington Spa Training Courses
Visio 2013 Leamington Spa Training Courses
SSIS 2014 - Leamington Spa SQL Server Integration Services Training Courses
PHP - Leamington Spa PHP Training Courses
Mobile - Leamington Spa Web Development Training Courses
Midlands - Possible Sql Server Reporting Services Training Course Locations
Nottingham, Stoke On Trent, Bromsgrove, Halesowen, Stourbridge, Shrewsbury, Solihull, Crewe, Stratford Upon Avon, Leicestershire, Wolverhampton, Oswestry, Lichfield, Coventry, Uttoxeter, Milton Keynes, Stafford, Kidsgrove, Staffordshire, Bridgnorth, Warwick, Leek, Redditch, Hereford, Bedworth, Burton On Trent, Malvern, Nuneaton, Wednesbury, Birmingham, Walsall, Telford, Midlands, Kenilworth, Tamworth, Staffordshire, Dudley, Smethwick, West Bromwich, Northhampton, Stourbridge, Cannock, Oxford, Rugby, Tipton, Warwickshire, Cheltenham, Black Country, Leamington Spa, East Midlands, Evesham, Atherstone, Leicester, Newcastle Under Lyme, Derby, Shropshire, Worcester, Droitwich, Kidderminster, Rugeley, Worcestershire, Sandwell, Rowley, West Midlands, Herefordshire, Chester