SQL SERVER REPORTING SERVICES TRAINING COURSES DORSET
About Enable Technology Dorset SQL Server Reporting Services Training Courses
We offer intensive two and three days SQL Server Reporting Services courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and SQL Server Reporting Services course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Reporting Services queries.
We provide instructor led training coupled with hands on training. We are set up to deliver SQL Server Reporting Services training courses onsite at your premises. If you prefer we can offer an offsite socially distanced training location in Dorset. Every SQL Server Reporting Services course can be modified to meet your bespoke requirements.
SQL Server Reporting Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are TalkTalk Direct Limited, Birmingham Heartlands Hospital, Norfolk Police Constabulary, West Bromwich Building Society, Dollond & Aitchison Limited, GKN PLC, South Staffordshire Water PLC and Birmingham City University.
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Dorset
- 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 ... Page Structure Properties
- See Training Course Details...
Create a Shared Data Source and Two Data Sets
Working with Maps and Spatial Data Enhancing Reports with Data Visualisation
Building a Report with Report Builder
Report Designer and Data Windows Configuring Report Projects
Setting Report Project Properties
Synchronized Data Alignment Using the Tablix Report Type
Interactive Sorting
Reporting Services Modes
Providing a Drop-Down List for a Report Parameter
Exploring the Tablix Report Type
Create a Parameterised Report
Formatting Tablix Rows and Columns Making Reports Interactive
Installing SQL Server Data Tools
Report Builder Installation and Execution Options
Building a Matrix Report
Writing and Using Report Expressions
A Tour of the Report Builder Interface
Introducing SQL Server Data Tools
Report Project Types Working with Report Server Projects
Create a Matrix Report
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Dorset
- 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 ... Understanding Variances Between SQL Versions
- See Training Course Details...
Exploring the Report Builder Interface
Examining Parameters
Using Tables
Exploring Gauges
Examining Maps
Filtering, Grouping, and Sorting
Examining Security
Introduction to SQL Server 2016 Report Builder
Utilizing Data Sources
SQL Server 2016 Report Builder Graphics
Examining Management
Utilizing Dynamic Headers and Footers
Using the List Object to Combine Other Items
Formatting Reports
Exploring Matrix
Understanding HTML5 and Textboxes
Exploring Table or Matrix Wizard
Utilizing Lists
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Dorset
- 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 ... Building a Matrix (Cross-tab) Report
- See Training Course Details...
Tables Pane
Data-driven Subscription
Server Management Reports
Understanding Reporting Services 2005 Subscriptions
Reporting Services 2005 Diagram Pane
Reporting Services 2005 Administration
Execution Properties
Creating a New Report Project
Building Report Models in Reporting Services 2005
Understanding What Just Happened
Data Output
Adding Groups and Users
Starting SQL Server Business Intelligence Development Studio
Understanding Reporting Services 2005 Caching
Understanding Security Settings
Choose Table Style or Matrix Style Dialog
Navigation
Quick Formatting using Toolbar and Menu Options
Managing Objects in Object Explorer
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Dorset
- 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 ... Creating a report with the report wizard
- See Training Course Details...
Work with expressions and embedded code.
Secure access to reports by using authentication, permissions, and SSL encryption.
Schedules
Introduction to reporting services
Configuring data access with report designer
Data filters
Add a drillthrough to a custom URL
Publish a report to reporting services Working with Reporting Services Data
Create a report using report builder or report designer.
Topics include Introduction to Reporting Services
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Extend reporting services functionality with external assemblies.
Reporting services tools Reporting Services Data Sources
Use report services configuration manager to reconfigure SSRS servers.
Report caching, snapshots, and comments
Configuring data access with report builder
Report sub-reports
Report parameters
Overview of mobile reports
Using Datasets Creating Paginated Reports
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Dorset
- 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 you can use conditional formatting to make your reports more dynamic
- See Training Course Details...
Explore the basic architecture of SQL Server Reporting Services
Discover how to create standard report subscriptions
Find out how to display parameter values in report headers
Discover how to improve parameter prompts using drop-down list parameters
Managing Reporting Services
Investigate what SQL Server Reporting Services can do
Master the Reporting Services Grouping pane
Learn how to create a tabular report from scratch
Understand scope as it applies to aggregate functions
Discover how to add textboxes and other controls to reports
Snapshots and Subscriptions
Explore creating groups
Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server
Learn how to enable basic authentication for reports and how to require SSL for report operations
Understanding how Reporting Services parameters work with stored procedure parameters
Find out how to create drill-down reports
Calculation and Formatting
Email us about this courses
Other Dorset Enable Technology Training Courses
PL/SQL Dorset Training Courses
Excel Basic Dorset Training Courses
Excel Intermediate - Dorset Excel Training Courses
Power Graphics - Dorset Data Analytics Training Courses
Crystal 2008 - Dorset Crystal Reports Training Courses
SSIS 2005 Dorset Training Courses
Crystal 2013 - Dorset Crystal Reports Training Courses
Project 2016 L1 Dorset Training Courses
Excel Advanced - Dorset Excel Training Courses
JQuery - Dorset JavaScript Training Courses
Oracle SQL - Dorset SQL Training Courses
Crystal XI Dorset Training Courses
PHP Dorset Training Courses
Access VBA - Dorset Access Training Courses
Data Mining Dorset Training Courses
South West - Possible Sql Server Reporting Services Training Course Locations
Somerset Sql Server Reporting Services Training Courses Somerset, Bristol, Dorchester, Plymouth, Swindon, Salisbury, South West, Chippenham, Gloucestershire, Exeter, Weymouth, Stroud, Tewkesbury, Bath, Torquay, Cheltenham, Christchurch, Yoevil, Dorset, Bournemouth, Taunton, Poole, Wells, Trowbridge, Devon, Cirencester, Gloucester, Wiltshire
Bristol Sql Server Reporting Services Training Courses
Dorchester Sql Server Reporting Services Training Courses
Plymouth Sql Server Reporting Services Training Courses
Swindon Sql Server Reporting Services Training Courses
Salisbury Sql Server Reporting Services Training Courses
South West Sql Server Reporting Services Training Courses
Chippenham Sql Server Reporting Services Training Courses
Gloucestershire Sql Server Reporting Services Training Courses
Exeter Sql Server Reporting Services Training Courses
Weymouth Sql Server Reporting Services Training Courses
Stroud Sql Server Reporting Services Training Courses
Tewkesbury Sql Server Reporting Services Training Courses
Bath Sql Server Reporting Services Training Courses
Torquay Sql Server Reporting Services Training Courses
Cheltenham Sql Server Reporting Services Training Courses
Christchurch Sql Server Reporting Services Training Courses
Yoevil Sql Server Reporting Services Training Courses
Dorset Sql Server Reporting Services Training Courses
Bournemouth Sql Server Reporting Services Training Courses
Taunton Sql Server Reporting Services Training Courses
Poole Sql Server Reporting Services Training Courses
Wells Sql Server Reporting Services Training Courses
Trowbridge Sql Server Reporting Services Training Courses
Devon Sql Server Reporting Services Training Courses
Cirencester Sql Server Reporting Services Training Courses
Gloucester Sql Server Reporting Services Training Courses
Wiltshire Sql Server Reporting Services Training Courses