Enable Technology

SQL SERVER REPORTING SERVICES LEICESTERSHIRE TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES LEICESTERSHIRE




About Enable Technology Leicestershire SQL Server Reporting Services Training Courses

Enable Technology offer short intensive skills based SQL Server Reporting Services training courses. The course will always be taught by a Microsoft Certified Professional (MCP). We provide every candidate with SQL Server Reporting Services training materials which they keep 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.

SQL Server Reporting Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. 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. All SQL Server Reporting Services courses can be customised to meet your particular requirements.

In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Nuclear Engineering Services, National Power PLC, Norwich Union PLC, DHL Express, Birmingham City Council, TalkTalk Direct Limited, Loughborough University and EDF Energy PLC.




SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Leicestershire
  • 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 Builder Installation and Execution Options
    Service Architecture  Report Building Tools
    Overview
    Report Designer and Data Windows Configuring Report Projects
    Introduction to Report Builder
    Create a Report Based on a Shared Data Set  Creating Reports With  SQL Server Data Tools
    A Tour of the Report Builder Interface
    Overview
    Null Handling
    Installing SQL Server Data Tools
    Introduction to SQL Server Reporting Services
    Formatting Tablix Rows and Columns Making Reports Interactive
    Tablix Cell Content and Scope Building a Tablix Report
    Create a Data Source Connection
    Multivalued Parameters Dynamic Reports with Parameters
    Create a  Parameterised Report
    Report Items Collection
    Formatting a Chart  Visualising Performance with Data Bars, Sparklines and Indicators
    Writing and Using Report Expressions
    Globals Collection

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Leicestershire
  • 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 databars, sparklines, and indicators in reports Summarising Report Data
    Preparing data for mobile reports
    Configuring data access with report designer
    Create a report using report builder or report designer.
    Report sub-reports
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Formatting data
    Publish a report to reporting services Working with Reporting Services Data
    Implementing report filters and parameters Visualizsng Data with Report Services
    Data filters
    Schedules
    Drilldown and drill through Sharing Reporting Services Reports
    Using Datasets Creating Paginated Reports
    Mobile report publisher
    Drillthrough in mobile reports
    Add a drillthrough to a custom URL
    Configuring data access with report builder
    Work with expressions and embedded code.
    Report subscription and delivery Administering Reporting Services
    Creating a report with the report wizard

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Leicestershire
  • 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 ...
  • Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Explore creating groups 
    Investigate Reporting Services charts 
    Creating Matrix Reports and Charts
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 
    Learn how to use URL to integrate Reporting Services reports into your applications 
    Investigate the list data region 
    Learn about report variables and when you might need to use them 
    Learn the differences between Report Builder 1.0 and Report Builder 2.0 
    Discover how to add textboxes and other controls to reports 
    Learn how to calculate group totals and percentages 
    Find out how to use Report Manager to manage user accounts and roles 
    Learn how to enable and control report caching 
    Learn how to create a tabular report from scratch 
    Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services 
    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 work with rich text to produce mail merge style reports 
    Discover the many application programming interfaces of Reporting Services 
    Learn how to create data-driven report subscriptions 

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Leicestershire
  • 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
    Understanding Report Parts
    Examining Maps
    Exploring Subscriptions
    Utilizing Dynamic Headers and Footers
    Working with Datasets
    Exploring Table or Matrix Wizard
    SQL Server 2016 Report Builder Basic Reports
    Utilizing Data Sources
    Working with Expressions
    Understanding Variances Between SQL Versions
    SQL Server 2016 Report Builder Graphics
    Mastering Data Region(s)
    Visualizing Your Company Report Templates
    Working with Map Wizard
    Examining Security
    Creating Subreports and Drillthrough Reports
    Examining Parameters
    Understanding HTML5 and Textboxes

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Leicestershire
  • 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
    Report Builder Design Layout
    Changing Columns and Rows
    SQL Server Management Studio Overview
    Design the Query Dialog
    Understanding Snapshots
    Add Report Parameter to a Dataset
    Usability Features
    Execution Properties
    Creating a Report Model File
    Sorting
    Reporting Services 2005 Distribution Options
    Sorting
    Creating a Report Model Project
    Understanding Item-level Roles
    Choose the Table Layout
    Model Designer Layout
    Understanding What Just Happened
    Adding Data Fields to a Table Data Region

  • See Training Course Details...



Email us about this courses



Other Leicestershire Enable Technology Training Courses

Excel Basic - Leicestershire Excel Training Courses
Oracle BI Leicestershire Training Courses
Power Query Leicestershire Training Courses
CSS - Leicestershire Web Development Training Courses
Microsoft Project Level 3 - Leicestershire Microsoft Project Training Courses
Data Warehouse Leicestershire Training Courses
Mobile - Leicestershire Web Development Training Courses
SSAS 2005 - Leicestershire SQL Server Analysis Services Training Courses
SSIS 2014 - Leicestershire SQL Server Integration Services Training Courses
Access VBA - Leicestershire Access Training Courses
PowerPoint Basic Leicestershire Training Courses
Data Mining Leicestershire Training Courses
Power BI Leicestershire Training Courses
HTML Leicestershire Training Courses
Crystal 2016 Leicestershire Training Courses



Midlands - Possible Sql Server Reporting Services Training Course Locations


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