Enable Technology

SQL SERVER REPORTING SERVICES LANCASTER TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES LANCASTER




About Enable Technology Lancaster SQL Server Reporting Services Training Courses

Enable Technology provides practical SQL Server Reporting Services skills based technology training. The tutor delivering the course will be a Microsoft certified expert. Each person attending a course takes away SQL Server Reporting Services courseware which can be used as reference materials after the training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Reporting Services course can contact the tutor for as long as they like if they encounter SQL Server Reporting Services problems.

SQL Server Reporting Services courses are taught by a Microsoft Certified Solutions Expert. During the current lockdown this course is delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Reporting Services course, watch the tutor demonstrate tasks, ask questions and share their own screen. The SQL Server Reporting Services syllabus can be modified to accommodate your specific training needs.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Homeserve PLC, University of Birmingham, Yell Group PLC, Canadian High Commission, Capita Group PLC, Nuclear Engineering Services, Wolverhampton City Council and Royal Air Force.




SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Lancaster
  • 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 ...
  • Reporting Services 2005 Subscriptions, Snapshots, and Caching
    Understanding Users and Groups
    Adding Groups and Users
    Create a Data Source
    Designing the Layout
    Adding Fields to the Table Data Region
    Sorting
    Using Reporting Services 2005 Expressions
    Rendering Extensions
    Entities
    Deploying the Auditing and Management Reports
    Reporting Services 2005 Data Options
    Server Properties
    Auditing and Management Reports
    Diagram Organizer Pane
    Creating a Data Source and Dataset
    Reporting Services 2005 Data Processing Extensions
    Report Filters

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Lancaster
  • 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 Chart Wizard
    Examining Management
    Examining Security
    Understanding HTML5 and Textboxes
    Visualizing Your Company Report Templates
    Mastering Data Region(s)
    Understanding Visualizations
    Filtering, Grouping, and Sorting
    Utilizing Charts
    Creating Subreports and Drillthrough Reports
    Understanding Report Parts
    Planning Your Reports
    Utilizing Dynamic Headers and Footers
    Exploring Gauges
    Examining Parameters
    Understanding Variances Between SQL Versions
    SQL Server 2016 Report Builder Wizards
    Utilizing Data Sources
    Examining Maps

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Lancaster
  • 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 ...
  • Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Using Datasets Creating Paginated Reports
    Databars, sparklines, indicators, gauges, and maps
    Topics include Introduction to Reporting Services
    Images and charts
    Drillthrough in mobile reports
    Configuring data access with report builder
    Data filters
    Extend reporting services functionality with external assemblies.
    Publish a report to reporting services Working with Reporting Services Data
    Configuring data access with report designer
    Implementing report filters and parameters Visualizsng Data with Report Services
    Schedules
    Reporting services tools Reporting Services Data Sources
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Report parameters
    Report sub-reports
    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.
    Sorting and grouping
    Drilldown and drill through Sharing Reporting Services Reports

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Lancaster
  • 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 datasets and data regions 
    Learn how to create custom functions using the Code window 
    Grouping and Sorting
    Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box 
    Creating Matrix Reports and Charts
    Investigate what SQL Server Reporting Services can do 
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Learn how to call the Report Server Web Service 
    Calculation and Formatting
    Learn how to enable and control report caching 
    Explore the maintenance of report history 
    Security
    Learn how to create matrix reports 
    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 
    Learn how to calculate group totals and percentages 
    Investigate the scheduling of report snapshots 
    Investigate how to call a custom assembly from a report 
    Discover how to add textboxes and other controls to reports 

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Lancaster
  • 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 ...
  • Indicators
    Variable Collection
    Preview Performance
    Using Charts in a Report
    The Global Collections
    Sparkline
    Creating Report Parameters
    Using Report Parts Shared Data Sets
    Formatting Text Boxes from the Toolbars
    Using Unbound Parameters Understanding Report And Data Set Parameters
    Creating a Columnar Report
    Introduction to SQL Server Reporting Services
    Data Set Parameters
    Report Parameters
    Rein in the Length of a Text Field
    Null Handling
    The Tablix Component
    Using Parameters with Ad Hoc SQL
    Synchronized Data Alignment  Using the Tablix Report Type
    Overview
    Report Project Configurations  Creating a New Report in the Report Designer

  • See Training Course Details...



Email us about this courses



Other Lancaster Enable Technology Training Courses

PL/SQL Lancaster Training Courses
Crystal 2016 - Lancaster Crystal Reports Training Courses
VBA Lancaster Training Courses
PowerPoint Advanced - Lancaster Office Training Courses
CSS Lancaster Training Courses
Access VBA - Lancaster Access Training Courses
HTML Lancaster Training Courses
Access 2016 Lancaster Training Courses
DAX - Lancaster Excel Training Courses
TSQL Lancaster Training Courses
Project 2016 L1 Lancaster Training Courses
Crystal 2008 Lancaster Training Courses
Data Warehouse - Lancaster SQL Training Courses
Power Graphics - Lancaster Data Analytics Training Courses
Visio 2013 - Lancaster Visio Training Courses



North West - Possible Sql Server Reporting Services Training Course Locations


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