SQL SERVER REPORTING SERVICES TRAINING COURSES WILTSHIRE
About Enable Technology Wiltshire SQL Server Reporting Services Training Courses
We offer intensive two and three days SQL Server Reporting Services courses. The training will be delivered by a Microsoft professional with development experience. Every person attending a SQL Server Reporting Services course will be provided with training materials and practice files to retain after the course. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Reporting Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
SQL Server Reporting Services courses are taught by a Microsoft Certified Solutions Expert. Our delivery method during the Covid 19 period is online virtual classrooms. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the SQL Server Reporting Services course exercises. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Reporting Services training needs.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Loughborough University, Lloyds TSB Bank PLC, Halfords Group PLC, Nuclear Engineering Services, DHL Express, Countrywide Homes Limited, Dollond & Aitchison Limited and Yell Group PLC.
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Wiltshire
- 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 ... Utilizing Data Sources
- See Training Course Details...
Mastering Data Region(s)
Understanding HTML5 and Textboxes
Understanding Variances Between SQL Versions
Utilizing Dynamic Headers and Footers
Using Tables
SQL Server 2016 Report Builder Wizards
Working with Datasets
Examining Maps
Utilizing Chart Wizard
Exploring Subscriptions
Examining Management
Examining Parameters
Filtering, Grouping, and Sorting
Creating Subreports and Drillthrough Reports
Visualizing Your Company Report Templates
Examining Security
Understanding Visualizations
Exploring Matrix
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Wiltshire
- 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 ... Learn how to calculate group totals and percentages
- See Training Course Details...
Learn about report variables and when you might need to use them
Discover how to create standard report subscriptions
Learn how to create custom functions using the Code window
Learn how to deploy Reporting Services projects and individual reports and data sources
Learn how to enable and control report caching
Learn how to solve common parameter issues
Explore the potential deployment and security issues that might arise when working with custom assemblies
Managing Reporting Services
Learn how to create data-driven report subscriptions
Investigate how to call a custom assembly from a report
Security
Explore creating linked reports
Explore the storing of credentials within a data source
Explore creating groups
Learn how to create a basic report using the SQL Server Reporting Services Wizard
Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box
Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services
Investigate what SQL Server Reporting Services can do
Discover how to add textboxes and other controls to reports
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Wiltshire
- 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 Main Components of the Design Environment
- See Training Course Details...
Understanding Users and Groups
The Toolbox
Understanding the Model Designer
Accessing Reports via the Report Manager
Building a Matrix (Cross-tab) Report
Previewing a Report
Report Filters
Formatting
Reporting Services 2005 Windows
Report Model Generation Rules
Reporting Services 2005 Toolbars
Understanding Reporting Services 2005 Subscriptions
Entities
Deploy Sample Reports to Report Server
Reporting Services 2005 Web Components
Using Reporting Services 2005 Expressions
Data Output
Report Formatting Toolbar
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Wiltshire
- 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 ... Build a Simple Report
- See Training Course Details...
Installing SQL Server Data Tools
Exploring the Tablix Report Type
The Tablix Properties Dialogue Box
Create a Map Report
Preview Performance
Shared Data Sources
Rein in the Length of a Text Field
Field Collection
Groups before Row Headers
Using the Expression Editor Using Built-in Report Operators and Functions
Building a Matrix Report
Multivalued Parameters Dynamic Reports with Parameters
Creating Report Parameters
Tablix Cell Content and Scope Building a Tablix Report
Drilldown Reports Managing Page Layout and Adding Interactivity
Using Report Parts Shared Data Sets
Introduction to SQL Server Reporting Services
Null Handling
Formatting Tablix Rows and Columns Making Reports Interactive
Displaying the Parameter Value and Label for a Drop-Down List Parameter
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Wiltshire
- 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 ... Publish a report to reporting services Working with Reporting Services Data
- See Training Course Details...
Formatting data
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Introduction to reporting services
Use databars, sparklines, and indicators in reports Summarising Report Data
Report sub-reports
Topics include Introduction to Reporting Services
Drilldown and drill through Sharing Reporting Services Reports
Databars, sparklines, indicators, gauges, and maps
Using Datasets Creating Paginated Reports
Data filters
Report subscription and delivery Administering Reporting Services
Images and charts
Configuring data access with report builder
Reporting services components
Use report services configuration manager to reconfigure SSRS servers.
Add a drillthrough to a custom URL
Implementing report filters and parameters Visualizsng Data with Report Services
Drillthrough in mobile reports
Configuring data access with report designer
Creating a report with the report wizard
Email us about this courses
Other Wiltshire Enable Technology Training Courses
Data Mining Wiltshire Training Courses
Crystal 2008 - Wiltshire Crystal Reports Training Courses
HTML - Wiltshire Web Development Training Courses
JavaScript - Wiltshire JavaScript Training Courses
PowerPoint Advanced - Wiltshire Office Training Courses
Power Query - Wiltshire Excel Training Courses
VBA - Wiltshire Excel Training Courses
Oracle BI Wiltshire Training Courses
Crystal 2013 Wiltshire Training Courses
Data Warehouse Wiltshire Training Courses
SSIS 2014 - Wiltshire SQL Server Integration Services Training Courses
Excel Intermediate - Wiltshire Excel Training Courses
Crystal 2011 Wiltshire Training Courses
Excel Basic - Wiltshire Excel Training Courses
PowerPoint Basic Wiltshire Training Courses
South West - Possible Sql Server Reporting Services Training Course Locations
Torquay, Taunton, Dorset, Trowbridge, Poole, Wells, Stroud, Wiltshire, Cirencester, Weymouth, Bournemouth, Tewkesbury, Plymouth, Bristol, Chippenham, Somerset, Swindon, Salisbury, South West, Exeter, Gloucester, Devon, Gloucestershire, Cheltenham, Dorchester, Bath, Christchurch, Yoevil