Enable Technology

SQL SERVER REPORTING SERVICES HARROGATE TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES HARROGATE




About Enable Technology Harrogate SQL Server Reporting Services Training Courses

We offer intensive two and three days SQL Server Reporting Services courses. The course will always be taught by a Microsoft Certified Professional (MCP). All course participants are issued SQL Server Reporting Services training manuals they can refer to after the course. If delegates have have questions about SQL Server Reporting Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Enable Technology training courses are delivered as instructor led courses. This SQL Server Reporting Services course is available online during the Covid 19 crisis. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor. We are happy to modify the SQL Server Reporting Services syllabus to match your teams training requirements.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Halfords Group PLC, Queen's Medical Centre Nottingham, Wolverhampton City Council, Keele University, Barclays Bank PLC, Norwich Union PLC, Dollond & Aitchison Limited and Royal & Sun Alliance Group PLC.




SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Harrogate
  • 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 ...
  • Snapshots and Subscriptions
    Understand how to plan and configure for deployment 
    Investigate what SQL Server Reporting Services can do 
    Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services 
    Learn how to work with rich text to produce mail merge style reports 
    Learn how to create parameters in ad-hoc SQL 
    Learn about datasets and data regions 
    Explore how to use Report Builder to build ad-hoc tabular, matrix and chart reports Discover how to create Report Builder reports without using the wizards 
    Creating Matrix Reports and Charts
    Learn how to create data-driven report subscriptions 
    Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services 
    Investigate the scheduling of report snapshots 
    Learn how to enable basic authentication for reports and how to require SSL for report operations 
    Learn how to create custom functions using the Code window 
    Understand scope as it applies to aggregate functions 
    Working with Parameters
    Grouping and Sorting

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Harrogate
  • 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 ...
  • Databars, sparklines, indicators, gauges, and maps
    Configuring data access with report designer
    Use report services configuration manager to reconfigure SSRS servers.
    Data filters
    Creating a report with the report wizard
    Drilldown and drill through Sharing Reporting Services Reports
    Publish a report to reporting services Working with Reporting Services Data
    Report caching, snapshots, and comments
    Report parameters
    Topics include Introduction to Reporting Services
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Sorting and grouping
    Schedules
    Reporting services tools Reporting Services Data Sources
    Preparing data for mobile reports
    Overview of mobile reports
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Drillthrough in mobile reports
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Report subscription and delivery Administering Reporting Services

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Harrogate
  • 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 ...
  • Create a  Parameterised Report
    Groups before Row Headers
    Null Handling
    Introduction to SQL Server Reporting Services
    Report Designer and Data Windows Configuring Report Projects
    Shared Dataset Design View  Creating Ad Hoc Reports with Report Builder
    Create a Map Report
    Variable Collection
    Field Collection
    Working with Maps and Spatial Data  Enhancing Reports with Data Visualisation
    Displaying the Parameter Value and Label for a Drop-Down List Parameter
    Formatting Text Boxes from the Toolbars
    Create a Data Source Connection
    Create and Configure a Report Server Project
    Report Definition Language (RDL)
    Report Builder vs. Report Designer
    Considering Report Layout Options
    Globals Collection
    A Tour of the Report Builder Interface
    The Tablix Properties Dialogue Box
    Report Items Collection

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Harrogate
  • 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 Gauges
    Examining Security
    Understanding Variances Between SQL Versions
    Using the List Object to Combine Other Items
    Working with Datasets
    Utilizing Lists
    Working with Map Wizard
    Exploring Table or Matrix Wizard
    Understanding Report Parts
    Utilizing Dynamic Headers and Footers
    Introduction to SQL Server 2016 Report Builder
    Planning Your Reports
    Examining Management
    Examining Maps
    Filtering, Grouping, and Sorting
    Examining Parameters
    Exploring Subscriptions
    Formatting Reports
    Exploring the Report Builder Interface

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Harrogate
  • 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 ...
  • Building a Matrix (Cross-tab) Report
    SQL Server Management Studio Overview
    Design the Query Dialog
    Adding a Table Data Region
    Filters
    Custom Data Processing Extensions
    Adding or Deleting
    Diagram Organizer Pane
    Previewing a Report with Parameters
    Saving a Report
    Sorting
    Reporting Services 2005 Web Components
    Model Designer Layout
    Accessing Reports via the Report Manager
    Select the Report Type Dialog
    Parts of the Chart

  • See Training Course Details...



Email us about this courses



Other Harrogate Enable Technology Training Courses

Data Warehouse Harrogate Training Courses
Power Query Harrogate Training Courses
Oracle SQL - Harrogate SQL Training Courses
Access 2016 Harrogate Training Courses
Power Graphics - Harrogate Data Analytics Training Courses
Crystal 2016 - Harrogate Crystal Reports Training Courses
SSAS 2014 - Harrogate SQL Server Analysis Services Training Courses
HTML Harrogate Training Courses
PL/SQL - Harrogate SQL Training Courses
VBA - Harrogate Excel Training Courses
SSAS 2005 - Harrogate SQL Server Analysis Services Training Courses
JavaScript - Harrogate JavaScript Training Courses
Access VBA Harrogate Training Courses
Excel Intermediate Harrogate Training Courses
Microsoft Project Level 3 - Harrogate Microsoft Project Training Courses



North - Possible Sql Server Reporting Services Training Course Locations


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

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