Enable Technology



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
    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

  • See Training Course Details...

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 
    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 
    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 

  • See Training Course Details...

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
    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
    Reporting Services 2005 Windows
    Report Model Generation Rules
    Reporting Services 2005 Toolbars
    Understanding Reporting Services 2005 Subscriptions
    Deploy Sample Reports to Report Server
    Reporting Services 2005 Web Components
    Using Reporting Services 2005 Expressions
    Data Output
    Report Formatting Toolbar

  • See Training Course Details...

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
    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

  • See Training Course Details...

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
    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

  • See Training Course Details...

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