SQL SERVER REPORTING SERVICES TRAINING COURSES COVENTRY
About Enable Technology Coventry SQL Server Reporting Services Training Courses
We are a company that offers short, practical, SQL Server Reporting Services hands on technology courses. All of our tutors are Microsoft Certified Professionals. Every course participant will receives course practice files and SQL Server Reporting Services course resources that can be referenced post training. If delegates have have questions about SQL Server Reporting Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Courses are instructor led and groups sizes small. During the Covid 19 period we are delivering course online through virtual classrooms. Delegates can join scheduled SQL Server Reporting Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance. We are happy to modify the SQL Server Reporting Services syllabus to match your teams training requirements.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Norwich Union PLC, Yell Group PLC, Loughborough University, Carillion PLC, Birmingham City University, Royal & Sun Alliance Group PLC, Norfolk Police Constabulary and Boots UK Limited.
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Coventry
- 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 ... Grouping and Sorting
- See Training Course Details...
Discover interactive sorting
Learn how to enable and control report caching
Creating Tabular and List Reports
Programming Reporting Services
Working with Parameters
Introducing SQL Server Reporting Services
Discover how to create standard report subscriptions
Dig into the use of unbound, multivalued, and cascading parameters
Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place
Learn how to create a tabular report from scratch
Calculation and Formatting
Learn how to create parameters in ad-hoc SQL
Explore the maintenance of report history
Understand how to plan and configure for deployment
Learn about report variables and when you might need to use them
Investigate how Reporting Services secures access to reports and other Reporting Services resources
Gain a basic understanding of the components behind SQL Server Reporting Services
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Coventry
- 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 ... Sorting and grouping
- See Training Course Details...
Work with expressions and embedded code.
Schedules
Drilldown and drill through Sharing Reporting Services Reports
Create a report using report builder or report designer.
Use databars, sparklines, and indicators in reports Summarising Report Data
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Report subscription and delivery Administering Reporting Services
Configuring data access with report designer
Add a drillthrough to a custom URL
Extend reporting services functionality with external assemblies.
Report caching, snapshots, and comments
Using Datasets Creating Paginated Reports
Preparing data for mobile reports
Reporting services tools Reporting Services Data Sources
Creating a report with the report wizard
Report sub-reports
Secure access to reports by using authentication, permissions, and SSL encryption.
Use report services configuration manager to reconfigure SSRS servers.
Configuring data access with report builder
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Coventry
- 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 ... Using Report Parts Shared Data Sets
- See Training Course Details...
Formatting Text Boxes in the Properties Window
Variable Collection
Field Collection
Sparkline
Exploring the Tablix Report Type
The Global Collections
Expression Operators
Reordering Report Parameters Using Drop-Down List Parameters
Report Builder vs. Report Designer
Building a Report with Report Builder
The Tablix Properties Dialogue Box
Rein in the Length of a Text Field
Introduction to SQL Server Reporting Services
Indicators
The Report Designer Creating Reports with SQL Server Data Tools
Built-in Functions
Create Shared Data Sources and Data Sets
Create a Report Based on a Shared Data Set Creating Reports With SQL Server Data Tools
Report Items Collection
Creating a Shared Data Source and Data Sets
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Coventry
- 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 Datasets
- See Training Course Details...
Examining Management
Mastering Data Region(s)
Exploring the Report Builder Interface
Exploring Subscriptions
SQL Server 2016 Report Builder Advanced Reporting
Utilizing Dynamic Headers and Footers
Creating Subreports and Drillthrough Reports
Understanding Variances Between SQL Versions
Planning Your Reports
Utilizing Lists
Filtering, Grouping, and Sorting
Examining Maps
Working with Map Wizard
SQL Server 2016 Report Builder Basic Reports
Using the List Object to Combine Other Items
Understanding Visualizations
Formatting Reports
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Coventry
- 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 ... Understanding What Just Happened
- See Training Course Details...
Sorting
Report Toolbar
Create a Data Source
The Toolbox
Create a Dataset
Building a Table Report
Adding Reporting Services 2005 Users
Clickthrough Reports
Creating a Data Source View
Filters
Reporting Services 2005 Data Processing Extensions
Server Management Reports
Setting the Reporting Services 2005 Report Properties
Understanding System-level Roles
Execution Reporting Services 2005 Log Reports
Deploy Sample Reports to Report Server
Data-driven Subscription
Adding Fields to the Table Data Region
Email us about this courses
Other Coventry Enable Technology Training Courses
Data Mining - Coventry Data Analytics Training Courses
TSQL - Coventry SQL Training Courses
Power Graphics - Coventry Data Analytics Training Courses
SSAS 2005 - Coventry SQL Server Analysis Services Training Courses
SSAS 2014 - Coventry SQL Server Analysis Services Training Courses
SSAS 2017 - Coventry SQL Server Analysis Services Training Courses
PowerPoint Advanced - Coventry Office Training Courses
DAX - Coventry Excel Training Courses
VBA - Coventry Excel Training Courses
SSIS 2014 - Coventry SQL Server Integration Services Training Courses
Power Query - Coventry Excel Training Courses
Crystal 2013 - Coventry Crystal Reports Training Courses
Microsoft Project Level 2 - Coventry Microsoft Project Training Courses
PowerPoint Basic Coventry Training Courses
Crystal 2011 Coventry Training Courses
Midlands - Possible Sql Server Reporting Services Training Course Locations
Rowley, Shrewsbury, Stratford Upon Avon, Bedworth, Leek, Crewe, Burton On Trent, Solihull, Rugeley, Coventry, Hereford, Kidsgrove, Nottingham, Tamworth, Kenilworth, Birmingham, Tipton, Evesham, Lichfield, Walsall, Newcastle Under Lyme, Bromsgrove, Telford, Staffordshire, Kidderminster, Wolverhampton, Dudley, Stafford, Rugby, West Midlands, Black Country, Chester, Worcestershire, Worcester, Derby, Leicester, Uttoxeter, Halesowen, East Midlands, Nuneaton, Herefordshire, Smethwick, Oswestry, Warwick, Leicestershire, Milton Keynes, Cheltenham, Droitwich, Northhampton, Oxford, Warwickshire, Staffordshire, Midlands, Stourbridge, Stoke On Trent, Cannock, West Bromwich, Malvern, Stourbridge, Wednesbury, Shropshire, Atherstone, Bridgnorth, Leamington Spa, Sandwell, Redditch