Enable Technology



About Enable Technology Oswestry SQL Server Reporting Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Reporting Services technology training courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a SQL Server Reporting Services course receives learning resources which also serves as a reference source 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.

Courses are instructor led and groups sizes small. We are delivering this instructor led SQL Server Reporting Services training online during the current crisis. Participants can se the tutors screen, ask questions and share their screen with the tutor. We offer the option of working with you to develop a bespoke SQL Server Reporting Services programme which precisely matches your organisations training requirements.

Our teaching team have over twenty years continuous technical training experience. Our clients include: EDF Energy PLC, West Bromwich Building Society, Wolverhampton City Council, Birmingham City University, Nuclear Engineering Services, Lloyds TSB Bank PLC, Barclays Bank PLC and University of Birmingham.

SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Oswestry
  • 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 ...
  • Building a Tabular Report
    Parameters and Stored Procedures
    Setting Report Project Properties
    No Data Rows
    Reporting Services Modes
    Create A Shared DataSet for Northwind
    Reordering Report Parameters Using Drop-Down List Parameters
    Introduction to Report Builder
    Creating a Custom Age Function
    Create a Map Report
    Report Parameters
    Report Project Types  Working with Report Server Projects
    Report Designer and Data Windows Configuring Report Projects
    Formatting Text Boxes in the Text Box Properties Dialogue Box
    Create a Tabular Report  Using the Tablix Report Type
    Creating a Shared Data Source and Data Sets
    Formatting a Chart  Visualising Performance with Data Bars, Sparklines and Indicators
    Preview Performance

  • See Training Course Details...

Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Oswestry
  • 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 ...
  • Creating Subreports and Drillthrough Reports
    Examining Parameters
    SQL Server 2016 Report Builder Wizards
    Working with Datasets
    SQL Server 2016 Report Builder Graphics
    Utilizing Dynamic Headers and Footers
    Exploring Table or Matrix Wizard
    Examining Security
    Examining Maps
    Exploring Matrix
    Using Tables
    SQL Server 2016 Report Builder Advanced Reporting
    Understanding Variances Between SQL Versions
    Exploring Gauges
    Filtering, Grouping, and Sorting
    Utilizing Chart Wizard
    Utilizing Lists
    Understanding HTML5 and Textboxes
    Understanding Visualizations
    Understanding Report Parts
    Using the List Object to Combine Other Items

  • See Training Course Details...

Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Oswestry
  • 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 ...
  • Images and charts
    Create a report using report builder or report designer.
    Topics include Introduction to Reporting Services
    Add a drillthrough to a custom URL
    Introduction to reporting services
    Report sub-reports
    Extend reporting services functionality with external assemblies.
    Report parameters
    Using Datasets Creating Paginated Reports
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Use report services configuration manager to reconfigure SSRS servers.
    Data filters
    Mobile report publisher
    Configuring data access with report designer
    Formatting data
    Publish a report to reporting services Working with Reporting Services Data
    Report subscription and delivery Administering Reporting Services
    Implementing report filters and parameters Visualizsng Data with Report Services
    Creating a report with the report wizard
    Work with expressions and embedded code.

  • See Training Course Details...

SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Oswestry
  • 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 Reporting Services 2005 Layout View
    Tools for Managing Reports
    Interactive Sort
    Table Data Region Record Sorting
    Deploying a Report Model
    Previewing Reporting Services 2005 Reports
    Understanding Security Settings
    Adding Groups and Users
    Key Considerations
    Understanding What Just Happened
    SQL Server 2005 Reporting Services Features
    Displaying Parameters in a Report
    Modifying the Data Source View
    Reporting Services 2005 Menus
    Design Area
    Changing Columns and Rows
    Choose the Table Layout
    Understanding Reporting Services 2005 Subscriptions

  • See Training Course Details...

SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Oswestry
  • 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 
    Learn how to create parameters in ad-hoc SQL 
    Learn about report variables and when you might need to use them 
    Introducing SQL Server Reporting Services
    Learn how to deploy Reporting Services projects and individual reports and data sources 
    Explore the use of Reporting Services gauges 
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 
    Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services 
    Snapshots and Subscriptions
    Learn about datasets and data regions 
    Explore creating linked reports 
    Grouping and Sorting
    Discover how to improve parameter prompts using drop-down list parameters 
    Explore creating groups 
    Working with Parameters
    Find out how to create drill-down reports 
    Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server 

  • See Training Course Details...

Email us about this courses

Other Oswestry Enable Technology Training Courses

Power Query - Oswestry Excel Training Courses
Crystal 2011 Oswestry Training Courses
DAX Oswestry Training Courses
Crystal 2013 - Oswestry Crystal Reports Training Courses
SSAS Tabular Oswestry Training Courses
SSAS 2005 Oswestry Training Courses
Crystal 2008 - Oswestry Crystal Reports Training Courses
CSS Oswestry Training Courses
Data Mining Oswestry Training Courses
PL/SQL - Oswestry SQL Training Courses
SSAS 2008 Oswestry Training Courses
Access VBA Oswestry Training Courses
JavaScript Oswestry Training Courses
Access 2016 Oswestry Training Courses
Microsoft Project Level 2 Oswestry Training Courses

Midlands - Possible Sql Server Reporting Services Training Course Locations

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