Enable Technology



About Enable Technology Rugby SQL Server Reporting Services Training Courses

We offer intensive two and three days SQL Server Reporting Services courses. The tutor delivering the course will be a Microsoft certified expert. All candidates receive comprehensive SQL Server Reporting Services training materials and practice files which are theirs to refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Reporting Services for as long as they need.

Delegates are taught by an experienced Microsoft professional. SQL Server Reporting Services courses are delivered through a mix of practical hands on exercises and walk throughs. 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 are happy to discuss customising the course content should you have particular SQL Server Reporting Services training requirements.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Royal Air Force, TalkTalk Direct Limited, EDF Energy PLC, Birmingham Heartlands Hospital, Birmingham City University, Nuclear Engineering Services, Boots UK Limited and Shell UK Oil Products Ltd.

SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Rugby
  • 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 ...
  • Introducing SQL Server Reporting Services
    Understand scope as it applies to aggregate functions 
    Discover the various global collections that you can reference in your expressions 
    Explore the maintenance of report history 
    Discover interactive sorting 
    Learn how to enable basic authentication for reports and how to require SSL for report operations 
    Discover the many application programming interfaces of Reporting Services 
    Investigate how to manage Reporting Services projects using Report Manager 
    Explore the storing of credentials within a data source 
    Learn how to create a tabular report from scratch 
    Learn the differences between Report Builder 1.0 and Report Builder 2.0 
    Calculation and Formatting
    Snapshots and Subscriptions
    Discover how to improve parameter prompts using drop-down list parameters 
    Learn how to create parameters in ad-hoc SQL 
    Programming Reporting Services
    Creating Tabular and List Reports

  • See Training Course Details...

SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Rugby
  • 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 ...
  • Expression Operators
    Create a Form-Like Report from a list Calculations Using Expressions And Functions
    Synchronized Data Alignment  Using the Tablix Report Type
    Page Headers and Footers Report Formatting Options
    Using Charts in a Report
    Create A Shared DataSet for Northwind
    Multivalued Parameters Dynamic Reports with Parameters
    Using Report Parts Shared Data Sets
    Displaying the Parameter Value and Label for a Drop-Down List Parameter
    A Tour of the Report Builder Interface
    User Collection
    Formatting a Chart  Visualising Performance with Data Bars, Sparklines and Indicators
    Shared Dataset Design View  Creating Ad Hoc Reports with Report Builder
    Tablix Cell Content and Scope Building a Tablix Report
    The Report Designer Creating Reports with SQL Server Data Tools
    Build a Simple Report
    Create a Custom Function  Managing Page Layout and Adding Interactivity
    Create a Data Source Connection
    Reporting Services Modes
    Designing the Page Layout

  • See Training Course Details...

Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Rugby
  • 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 ...
  • Understanding HTML5 and Textboxes
    Exploring Gauges
    Filtering, Grouping, and Sorting
    Creating Subreports and Drillthrough Reports
    Exploring Table or Matrix Wizard
    Exploring Subscriptions
    Understanding Visualizations
    Utilizing Chart Wizard
    Utilizing Lists
    Working with Map Wizard
    Utilizing Charts
    Formatting Reports
    SQL Server 2016 Report Builder Wizards
    SQL Server 2016 Report Builder Advanced Reporting
    Examining Security
    Planning Your Reports
    Working with Datasets
    Utilizing Data Sources
    Using Tables
    Using the List Object to Combine Other Items

  • See Training Course Details...

SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Rugby
  • 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 ...
  • Visibility
    Design the Query Dialog
    Grouping Data
    Using the Reporting Services 2005 Graphical Query Designer
    Execution Reporting Services 2005 Log Reports
    Understanding Reporting Services 2005 Subscriptions
    Rendering Extensions
    Understanding Users and Groups
    Included Reporting Services 2005 Extensions
    Report Design Options
    Select the Report Type Dialog
    Changing Columns and Rows
    Creating a Subscription
    Parts of the Chart
    Understanding System-level Roles
    Server Properties
    Data Output
    Model Designer Layout

  • See Training Course Details...

Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Rugby
  • 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 ...
  • Reporting services components
    Use report services configuration manager to reconfigure SSRS servers.
    Add a drillthrough to a custom URL
    Publish a report to reporting services Working with Reporting Services Data
    Creating a report with the report wizard
    Extend reporting services functionality with external assemblies.
    Sorting and grouping
    Using Datasets Creating Paginated Reports
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Images and charts
    Implementing report filters and parameters Visualizsng Data with Report Services
    Data filters
    Configuring data access with report designer
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Introduction to reporting services
    Drillthrough in mobile reports
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Preparing data for mobile reports
    Mobile report publisher

  • See Training Course Details...

Email us about this courses

Other Rugby Enable Technology Training Courses

VBA Rugby Training Courses
Data Warehouse - Rugby SQL Training Courses
JavaScript Rugby Training Courses
PowerPoint Basic - Rugby Office Training Courses
JQuery Mobile Rugby Training Courses
HTML Rugby Training Courses
PL/SQL Rugby Training Courses
Power Graphics Rugby Training Courses
Crystal XI - Rugby Crystal Reports Training Courses
PowerPoint Advanced - Rugby Office Training Courses
SSAS 2008 Rugby Training Courses
Crystal 2011 - Rugby Crystal Reports Training Courses
Oracle BI Rugby Training Courses
Crystal 2016 - Rugby Crystal Reports Training Courses
SSAS Tabular - Rugby SQL Server Analysis Services Training Courses

Midlands - Possible Sql Server Reporting Services Training Course Locations

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