Enable Technology



About Enable Technology Gateshead SQL Server Reporting Services Training Courses

We have a twenty year history of providing skills based SQL Server Reporting Services industry training. We guarantee the training will be delivered by a Microsoft certified expert. Each course participant will be issued with training SQL Server Reporting Services resources which they can continue to use after the training. 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.

Our primary method of delivery is instructor led training coupled with practical hands on activities. During the Covid 19 period we are delivering course online through virtual classrooms. Delegates can join scheduled SQL Server Reporting Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance. Every SQL Server Reporting Services course can me modified to meet your bespoke requirements.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Wolverhampton City Council, Nuclear Engineering Services, Capita Group PLC, Dollond & Aitchison Limited, Birmingham Heartlands Hospital, Nationwide Building Society Limited, Keele University and South Staffordshire Water PLC.

SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Gateshead
  • 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 ...
  • Creating Report Parameters
    Report Designer and Data Windows Configuring Report Projects
    Considering Report Layout Options
    Providing a Drop-Down List for a Report Parameter
    Create a Shared Data Source and Two Data Sets
    Create A Shared DataSet for Northwind
    Built-in Functions
    Shared Dataset Design View  Creating Ad Hoc Reports with Report Builder
    Preview Performance
    Shared Data Sources
    Setting Report Project Properties
    Create a Form-Like Report from a list Calculations Using Expressions And Functions
    Page Headers and Footers Report Formatting Options
    Report Project Types  Working with Report Server Projects
    Parameters and Stored Procedures
    The Report Designer Creating Reports with SQL Server Data Tools
    Field Collection
    Groups before Row Headers
    Building a Tabular Report
    Reporting Services Modes

  • See Training Course Details...

Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Gateshead
  • 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 Table or Matrix Wizard
    Formatting Reports
    SQL Server 2016 Report Builder Graphics
    Understanding Report Parts
    SQL Server 2016 Report Builder Wizards
    Using the List Object to Combine Other Items
    Examining Management
    Examining Maps
    Understanding Variances Between SQL Versions
    SQL Server 2016 Report Builder Advanced Reporting
    Creating Subreports and Drillthrough Reports
    Working with Expressions
    Utilizing Charts
    Working with Map Wizard
    Exploring Gauges
    Filtering, Grouping, and Sorting
    Examining Parameters

  • See Training Course Details...

SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Gateshead
  • 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 report variables and when you might need to use them 
    Learn how to use URL to integrate Reporting Services reports into your applications 
    Discover the classes and methods exposed by the Reporting Services Web Service API 
    Explore how to create expressions in your reports using 
    Learn how to create parameters in ad-hoc SQL 
    Discover how to improve parameter prompts using drop-down list parameters 
    Programming Reporting Services
    Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box 
    Learn how to work with rich text to produce mail merge style reports 
    Explore the use of Reporting Services gauges 
    Investigate what SQL Server Reporting Services can do 
    Learn the differences between Report Builder 1.0 and Report Builder 2.0 
    Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services 
    Investigate the list data region 
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Investigate how to call a custom assembly from a report 
    Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Advanced Reporting Services Programming

  • See Training Course Details...

Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Gateshead
  • 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 ...
  • Overview of mobile reports
    Use report services configuration manager to reconfigure SSRS servers.
    Data filters
    Report parameters
    Work with expressions and embedded code.
    Sorting and grouping
    Drilldown and drill through Sharing Reporting Services Reports
    Images and charts
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Mobile report publisher
    Report sub-reports
    Topics include Introduction to Reporting Services
    Extend reporting services functionality with external assemblies.
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Databars, sparklines, indicators, gauges, and maps
    Create a report using report builder or report designer.
    Reporting services components
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Preparing data for mobile reports
    Report caching, snapshots, and comments

  • See Training Course Details...

SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Gateshead
  • 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 ...
  • Add Report Parameter to a Dataset
    Installing Auditing and Management Reports
    Usability Features
    Model Designer Layout
    Report Design Options
    Custom Data Processing Extensions
    Included Reporting Services 2005 Extensions
    Configure and Run the Job Package
    Managing Reporting Services
    Create a Database for Report Execution Data
    Adding Fields to the Table Data Region
    Using the Expression Editor Dialog
    Understanding Snapshots
    Deploying Reports with Development Studio
    A Closer Look at Preview
    Changing Columns and Rows
    Auditing and Management Reports

  • See Training Course Details...

Email us about this courses

Other Gateshead Enable Technology Training Courses

PowerPoint Basic - Gateshead Office Training Courses
SSAS 2017 Gateshead Training Courses
CSS - Gateshead Web Development Training Courses
Visio 2013 - Gateshead Visio Training Courses
Project 2016 - Gateshead Microsoft Project Training Courses
Crystal 2016 - Gateshead Crystal Reports Training Courses
Power Query Gateshead Training Courses
HTML Gateshead Training Courses
SQL Gateshead Training Courses
Crystal 2013 Gateshead Training Courses
Data Mining Gateshead Training Courses
VBA - Gateshead Excel Training Courses
PL/SQL - Gateshead SQL Training Courses
Excel Power Pivot - Gateshead Excel Training Courses
DAX Gateshead Training Courses

North - Possible Sql Server Reporting Services Training Course Locations

Pudsey, Keighley, Gateshead, Scunthorpe, Durham, Wetherby, Grimsby, York, Harrogate, Huddersfield, Batley, Sunderland, Hexham, Castleford, Hartlepool, South Shields, Doncaster, Wakefield, Newcastle Upon Tyne, Sheffield, Halifax, Dewsbury, Barnsley, Normanton, Yorkshire, Scarborough, Leeds, Bridlington, Rotherham, North East, Middlesbrough