Enable Technology



About Enable Technology Oxford SQL Server Reporting Services Training Courses

Enable Technology provides practical SQL Server Reporting Services skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued SQL Server Reporting Services training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Reporting Services queries. This support is open ended.

SQL Server Reporting Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. While social distancing is in place we are only delivering SQL Server Reporting Services courses via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance. We will work with you prior to the course to tailor the SQL Server Reporting Services syllabus to match your requirements.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: West Bromwich Building Society, Norwich Union PLC, Royal Air Force, Countrywide Homes Limited, GKN PLC, National Power PLC, Halfords Group PLC and Homeserve PLC.

SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Oxford
  • 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 ...
  • Synchronized Data Alignment  Using the Tablix Report Type
    Using Report Parts Shared Data Sets
    Building a Matrix Report
    Built-in Functions
    Formatting Text Boxes in the Properties Window
    Create a Matrix Report
    Null Handling
    Writing and Using Report Expressions
    Data Bars
    Formatting Text Boxes in the Text Box Properties Dialogue Box
    Create A Shared DataSet for Northwind
    Using Charts in a Report
    Create a Drop-Down List Parameter
    Formatting a Chart  Visualising Performance with Data Bars, Sparklines and Indicators
    Report Parameters
    Report Definition Language (RDL)
    Parameters and Stored Procedures
    Building a List Report Configuring Tablix  Properties and Groups
    Create Shared Data Sources and Data Sets
    Create a Report Based on a Shared Data Set  Creating Reports With  SQL Server Data Tools
    Formatting Text Boxes from the Toolbars

  • See Training Course Details...

Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Oxford
  • 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 ...
  • Report parameters
    Implementing report filters and parameters Visualizsng Data with Report Services
    Drilldown and drill through Sharing Reporting Services Reports
    Formatting data
    Creating a report with the report wizard
    Drillthrough in mobile reports
    Use report services configuration manager to reconfigure SSRS servers.
    Reporting services tools Reporting Services Data Sources
    Extend reporting services functionality with external assemblies.
    Overview of mobile reports
    Images and charts
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Sorting and grouping
    Work with expressions and embedded code.
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Data filters
    Reporting services components
    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
    Configuring data access with report designer

  • See Training Course Details...

SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Oxford
  • 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 about datasets and data regions 
    Dig into the use of unbound, multivalued, and cascading parameters 
    Snapshots and Subscriptions
    Discover how to improve parameter prompts using drop-down list parameters 
    Find out how to display parameter values in report headers 
    Investigate how Reporting Services secures access to reports and other Reporting Services resources 
    Discover interactive sorting 
    Learn how to use URL to integrate Reporting Services reports into your applications 
    Calculation and Formatting
    Investigate how to manage Reporting Services projects using Report Manager 
    Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place 
    Understand how to plan and configure for deployment 
    Learn about report variables and when you might need to use them 
    Master the Reporting Services Grouping pane 
    Learn how to create matrix reports 
    Introducing SQL Server Reporting Services
    Discover how to add textboxes and other controls to reports 
    Investigate Reporting Services charts 
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 

  • See Training Course Details...

SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Oxford
  • 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 ...
  • Grouping Data
    Design the Query Dialog
    Creating a Data Source and Dataset
    Launching Report Builder
    Select the Data Source Dialog
    Introduction to Reporting Services 2005
    Getting Started Pane
    Managing Reporting Services
    Creating a Subscription
    A Closer Look at Preview
    Saving a Report
    Reporting Services 2005 Menus
    Reporting Services 2005 Toolbars
    The Reporting Services 2005 Key Components
    Reporting Services 2005 Distribution Options

  • See Training Course Details...

Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Oxford
  • 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 ...
  • Exploring Subscriptions
    Utilizing Lists
    Exploring Gauges
    Exploring the Report Builder Interface
    Examining Management
    Creating Subreports and Drillthrough Reports
    Working with Datasets
    Visualizing Your Company Report Templates
    Using Tables
    Introduction to SQL Server 2016 Report Builder
    Mastering Data Region(s)
    Working with Expressions
    Understanding Report Parts
    Examining Security
    Utilizing Data Sources
    Working with Map Wizard
    Utilizing Chart Wizard
    SQL Server 2016 Report Builder Wizards
    Examining Parameters

  • See Training Course Details...

Email us about this courses

Other Oxford Enable Technology Training Courses

Crystal 2008 Oxford Training Courses
SSIS 2014 - Oxford SQL Server Integration Services Training Courses
PowerPoint Basic Oxford Training Courses
SSIS 2005 Oxford Training Courses
Power Query Oxford Training Courses
JQuery - Oxford JavaScript Training Courses
Excel Advanced - Oxford Excel Training Courses
SSAS 2008 Oxford Training Courses
VBA - Oxford Excel Training Courses
Crystal 2013 Oxford Training Courses
DAX - Oxford Excel Training Courses
Visio 2013 Oxford Training Courses
PL/SQL Oxford Training Courses
Project 2016 L1 Oxford Training Courses
HTML - Oxford Web Development Training Courses

Midlands - Possible Sql Server Reporting Services Training Course Locations

Rugby, Warwickshire, Rugeley, Milton Keynes, Herefordshire, Warwick, Burton On Trent, Oswestry, Stoke On Trent, Tamworth, Shrewsbury, Leamington Spa, Midlands, Shropshire, Northhampton, Telford, Bedworth, Nuneaton, Leicestershire, Birmingham, Atherstone, Walsall, Malvern, Worcestershire, Leek, West Midlands, Kenilworth, Evesham, Bromsgrove, Kidsgrove, Cannock, Wolverhampton, Stourbridge, Uttoxeter, Lichfield, Smethwick, Droitwich, East Midlands, West Bromwich, Crewe, Stratford Upon Avon, Rowley, Solihull, Kidderminster, Newcastle Under Lyme, Hereford, Oxford, Wednesbury, Stourbridge, Dudley, Sandwell, Cheltenham, Staffordshire, Worcester, Halesowen, Nottingham, Black Country, Stafford, Derby, Coventry, Chester, Leicester, Staffordshire, Tipton, Bridgnorth, Redditch