Enable Technology



About Enable Technology Cheltenham SQL Server Reporting Services Training Courses

Enable Technology provides practical SQL Server Reporting Services skills based technology training. The course will always be taught by a Microsoft Certified Professional (MCP). Everyone attending a SQL Server Reporting Services course receives learning resources which also serves as a reference source after the course. We also provide an ongoing support service to people attending our SQL Server Reporting Services courses. Delegates can contact the course tutor with specific SQL Server Reporting Services questions for as long as they need following the course.

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 been providing IT training primarily in the Midlands for two decades. Our clients include: Royal & Sun Alliance Group PLC, Carillion PLC, Boots UK Limited, Nationwide Building Society Limited, EDF Energy PLC, Dollond & Aitchison Limited, Birmingham City University and National Power PLC.

SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Cheltenham
  • 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 the differences between Report Builder 1.0 and Report Builder 2.0 
    Find out how to use Report Manager to manage user accounts and roles 
    Understand scope as it applies to aggregate functions 
    Discover interactive sorting 
    Find out how to display parameter values in report headers 
    Learn how to deploy Reporting Services projects and individual reports and data sources 
    Investigate the scheduling of report snapshots 
    Discover how to improve parameter prompts using drop-down list parameters 
    Programming Reporting Services
    Discover the various global collections that you can reference in your expressions 
    Working with Parameters
    Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services 
    Investigate what SQL Server Reporting Services can do 
    Introducing SQL Server Reporting Services
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 
    Explore the basic architecture of SQL Server Reporting Services 
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Explore creating linked reports 

  • See Training Course Details...

SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Cheltenham
  • 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 ...
  • Creating a New Report Project
    Using the Reporting Services Configuration Manager
    Understanding Report Builder
    The Reporting Services 2005 Layout View
    Design the Query Dialog
    The Management Studio Object Explorer
    Displaying Parameters in a Report
    Reporting Services 2005 Query vs. Report Parameters
    Identifying Field
    Deploying the Auditing and Management Reports
    Select the Data Source Dialog
    Designing the Layout
    Reporting Services 2005 Windows
    Execution Reporting Services 2005 Log Reports
    Query tab
    Auditing and Management Reports
    Understand the Report Model Architecture
    Installing Auditing and Management Reports
    Report Design Options
    Reporting Services 2005 Web Components

  • See Training Course Details...

Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Cheltenham
  • 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 ...
  • Using Tables
    Working with Expressions
    Utilizing Chart Wizard
    Understanding Variances Between SQL Versions
    Utilizing Charts
    Introduction to SQL Server 2016 Report Builder
    Understanding Report Parts
    Exploring Table or Matrix Wizard
    Examining Parameters
    Examining Management
    Examining Maps
    Working with Map Wizard
    Examining Security
    Exploring Matrix
    Filtering, Grouping, and Sorting
    Exploring Subscriptions
    Mastering Data Region(s)
    Visualizing Your Company Report Templates
    Understanding Visualizations
    Utilizing Data Sources

  • See Training Course Details...

Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Cheltenham
  • 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 ...
  • Introduction to reporting services
    Work with expressions and embedded code.
    Topics include Introduction to Reporting Services
    Overview of mobile reports
    Extend reporting services functionality with external assemblies.
    Drillthrough in mobile reports
    Creating a report with the report wizard
    Implementing report filters and parameters Visualizsng Data with Report Services
    Using Datasets Creating Paginated Reports
    Databars, sparklines, indicators, gauges, and maps
    Formatting 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
    Create a report using report builder or report designer.
    Reporting services components
    Drilldown and drill through Sharing Reporting Services Reports
    Add a drillthrough to a custom URL
    Preparing data for mobile reports
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Mobile report publisher

  • See Training Course Details...

SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Cheltenham
  • 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 ...
  • Data Set Parameters
    Work with Multivalued Parameters  Enhancing Reports with Data Visualisations
    Report Project Files and Folders
    Built-in Functions
    Report Designer and Data Windows Configuring Report Projects
    Interactive Sorting
    Field Collection
    Cascading Parameters
    Formatting Text Boxes in the Text Box Properties Dialogue Box
    Creating a Custom Age Function
    Shared Dataset Design View  Creating Ad Hoc Reports with Report Builder
    Create a Drop-Down List Parameter
    Create a Custom Function  Managing Page Layout and Adding Interactivity
    Creating a Customer Contact List  Creating Ad Hoc Reports With Report Builder
    Designing the Page Layout
    Report Items Collection
    Rein in the Length of a Text Field
    Creating Report Parameters
    User Collection
    Multivalued Parameters Dynamic Reports with Parameters
    Create a Form-Like Report from a list Calculations Using Expressions And Functions

  • See Training Course Details...

Email us about this courses

Other Cheltenham Enable Technology Training Courses

Oracle BI Cheltenham Training Courses
Excel Intermediate Cheltenham Training Courses
VBA - Cheltenham Excel Training Courses
Power Graphics Cheltenham Training Courses
SSAS 2005 Cheltenham Training Courses
Project 2016 L1 Cheltenham Training Courses
SSIS 2005 - Cheltenham SQL Server Integration Services Training Courses
JQuery Cheltenham Training Courses
PowerPoint Basic Cheltenham Training Courses
SSAS Tabular Cheltenham Training Courses
Excel Basic Cheltenham Training Courses
SSIS 2014 - Cheltenham SQL Server Integration Services Training Courses
Visio 2013 Cheltenham Training Courses
Crystal 2011 - Cheltenham Crystal Reports Training Courses
Access VBA Cheltenham Training Courses

South West - Possible Sql Server Reporting Services Training Course Locations

Stratford Upon Avon, Derby, Sandwell, Kidsgrove, Leek, Herefordshire, Smethwick, Redditch, Walsall, Uttoxeter, Droitwich, Midlands, Hereford, Leicestershire, Staffordshire, Wednesbury, West Bromwich, Wolverhampton, Oswestry, Tamworth, Nottingham, Stourbridge, Black Country, Leicester, Halesowen, Stourbridge, Burton On Trent, Rugeley, Bromsgrove, Staffordshire, Dudley, West Midlands, Nuneaton, Shropshire, Kidderminster, Worcestershire, Malvern, Stafford, Bedworth, Newcastle Under Lyme, Rowley, Tipton, East Midlands, Worcester, Shrewsbury, Solihull, Oxford, Evesham, Telford, Lichfield, Bridgnorth, Northhampton, Chester, Milton Keynes, Stoke On Trent, Leamington Spa, Crewe, Kenilworth, Warwickshire, Atherstone, Coventry, Birmingham, Rugby, Cheltenham, Warwick, CannockBournemouth, Taunton, Exeter, Somerset, Weymouth, South West, Devon, Wells, Tewkesbury, Chippenham, Cheltenham, Wiltshire, Bath, Christchurch, Plymouth, Dorchester, Gloucestershire, Cirencester, Poole, Swindon, Torquay, Stroud, Salisbury, Dorset, Trowbridge, Yoevil, Gloucester, Bristol