Enable Technology

SQL SERVER REPORTING SERVICES LEIGH TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES LEIGH




About Enable Technology Leigh SQL Server Reporting Services Training Courses

We have a twenty year history of providing skills based SQL Server Reporting Services industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. 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.

Courses are instructor led and groups sizes small. 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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Birmingham City University, Nuclear Engineering Services, Cadbury PLC, TalkTalk Direct Limited, Total Telecommunications Limited, Royal & Sun Alliance Group PLC, Fujistu PLC and Shell UK Oil Products Ltd.




SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Leigh
  • 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 ...
  • Adding Data Fields to a Table Data Region
    Design the Table or Design the Matrix Dialog
    Creating a Report Model Project
    Perspectives
    History Properties
    Reporting Services 2005 Toolbars
    Adding or Deleting
    Execution Reporting Services 2005 Log Reports
    Filters
    Create a Dataset
    Explorer Pane
    Understanding Reporting Services 2005 Caching
    Understanding Security Settings
    Reporting Services 2005 Distribution Options
    Adding System-level Roles
    Changing Columns and Rows
    Dynamic Parameter Values (From Query)
    General
    SQL Server 2005 Reporting Services Features
    Creating a Report Model File
    Adding Groups to Reporting Services

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Leigh
  • 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 how to call the Report Server Web Service 
    Ad-Hoc Reporting with Report Builder 2.0
    Learn how to create custom functions using the Code window 
    Learn how to create matrix reports 
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Introducing SQL Server Reporting Services
    Learn how to deploy Reporting Services projects and individual reports and data sources 
    Learn the differences between Report Builder 1.0 and Report Builder 2.0 
    Explore how to create expressions in your reports using 
    Security
    Learn how to create a tabular report from scratch 
    Learn how to work with rich text to produce mail merge style reports 
    Learn how to enable basic authentication for reports and how to require SSL for report operations 
    Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server 
    Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box 
    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 
    Explore creating linked reports 

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Leigh
  • 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 ...
  • Utilizing Dynamic Headers and Footers
    Utilizing Lists
    Planning Your Reports
    Mastering Data Region(s)
    Working with Datasets
    Formatting Reports
    Creating Subreports and Drillthrough Reports
    Working with Expressions
    Understanding HTML5 and Textboxes
    Examining Parameters
    SQL Server 2016 Report Builder Graphics
    Working with Map Wizard
    Using Tables
    SQL Server 2016 Report Builder Wizards
    Exploring Table or Matrix Wizard
    Understanding Report Parts
    Visualizing Your Company Report Templates

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Leigh
  • 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 ...
  • Report Definition Language (RDL)
    Using Report Parts Shared Data Sets
    Indicators
    Providing a Drop-Down List for a Report Parameter
    Introduction to SQL Server Reporting Services
    Build a Simple Report
    Create A Shared DataSet for Northwind
    No Data Rows
    Using Charts in a Report
    Interactive Sorting
    Create a Report Based on a Shared Data Set  Creating Reports With  SQL Server Data Tools
    Report Parameters
    Create a Data Source Connection
    Writing and Using Report Expressions
    Formatting Text Boxes in the Text Box Properties Dialogue Box
    The Tablix Component
    Shared Dataset Design View  Creating Ad Hoc Reports with Report Builder
    Displaying the Parameter Value and Label for a Drop-Down List Parameter
    The Report Designer Creating Reports with SQL Server Data Tools
    Using the Expression Editor  Using Built-in Report Operators and Functions
    Sparkline

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Leigh
  • 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 ...
  • Introduction to reporting services
    Use report services configuration manager to reconfigure SSRS servers.
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Create a report using report builder or report designer.
    Extend reporting services functionality with external assemblies.
    Reporting services tools Reporting Services Data Sources
    Add a drillthrough to a custom URL
    Reporting services components
    Report caching, snapshots, and comments
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Sorting and grouping
    Publish a report to reporting services Working with Reporting Services Data
    Drilldown and drill through Sharing Reporting Services Reports
    Configuring data access with report designer
    Data filters
    Mobile report publisher
    Databars, sparklines, indicators, gauges, and maps
    Drillthrough in mobile reports
    Images and charts
    Preparing data for mobile reports

  • See Training Course Details...



Email us about this courses



Other Leigh Enable Technology Training Courses

Data Mining - Leigh Data Analytics Training Courses
HTML - Leigh Web Development Training Courses
Access VBA Leigh Training Courses
PL/SQL - Leigh SQL Training Courses
Excel Power Pivot - Leigh Excel Training Courses
Crystal 2013 Leigh Training Courses
SSAS 2017 - Leigh SQL Server Analysis Services Training Courses
Oracle BI - Leigh Data Analytics Training Courses
TSQL - Leigh SQL Training Courses
Microsoft Project Level 3 - Leigh Microsoft Project Training Courses
Crystal 2016 Leigh Training Courses
Visio 2013 - Leigh Visio Training Courses
SSAS 2008 Leigh Training Courses
Mobile - Leigh Web Development Training Courses
Crystal 2008 Leigh Training Courses



North West - Possible Sql Server Reporting Services Training Course Locations


North West, Barrow-in-Furness, Wythenshawe, Middleton, Runcorn, Thornton-Cleveleys, Lytham Urmston, Bury, Eccles, Ellesmere Port, Lancaster, Bolton, Morecambe, Macclesfield, Leyland, Wallasey, Hyde, Kirkby, Warrington, Stretford, Denton, Crewe, Widnes, Huyton, Cheshire, Chadderton, Preston, Merseyside, Saddleworth, Northwich, Blackpool, Winsford, Skelmersdale, Rochdale, Chorley, Lancashire, Carlisle, Bootle, Crosby, Sale, Oldham, Stockport, Birkenhead, Blackburn, Altrincham, Leigh, Prestwich, Accrington, Burnley, Southport, Ashton-under-Lyne, Chester, Liverpool, Salford, Manchester, Wigan, Farnworth