Enable Technology

SQL SERVER REPORTING SERVICES CIL-Y-COED TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES CIL-Y-COED




About Enable Technology Cil-y-coed SQL Server Reporting Services Training Courses

We are a company that provides short intensive SQL Server Reporting Services training courses. The tutor delivering the course will be a Microsoft certified expert. Every person attending a SQL Server Reporting Services course will be provided with training materials and practice files to retain after the course. We also provide an ongoing support service to people attending our SQL Server Reporting Services courses. Delegates can contact the course tutor with specific SQL Server Reporting Services questions for as long as they need following the course.

Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. Another option is we can organise a local socially distanced training site in Cil-y-coed. We will work with you prior to the course to tailor the SQL Server Reporting Services syllabus to match your requirements.

We also deliver this 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.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Norwich Union PLC, Cadbury PLC, Countrywide Homes Limited, Nationwide Building Society Limited, Keele University, Vodafone Group Services, Birmingham City University and West Bromwich Building Society.




SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Cil-y-coed
  • 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 ...
  • Creating a New Report Project
    Reporting Services 2005 Administration
    Usability Features
    Reporting Services 2005 Security
    Auditing and Management Reports
    Creating a Report Model Data Source
    Report Builder Design Layout
    Shared Schedules
    Execution Properties
    Interactive Sort
    SQL Server 2005 Reporting Services Features
    Linked Reports
    Design the Query Dialog
    Drawing Lines and Rectangles
    Adding Groups to Reporting Services
    Using the Reporting Services Configuration Manager
    Previewing Reporting Services 2005 Reports
    Understanding Users and Groups
    Entity and Field Folders
    Model Designer Layout

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Cil-y-coed
  • 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 ...
  • Investigate the list data region 
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Managing Reporting Services
    Discover the classes and methods exposed by the Reporting Services Web Service API 
    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 create custom functions using the Code window 
    Advanced Reporting Services Programming
    Investigate how to call a custom assembly from a report 
    Find out how to create drill-down reports 
    Learn how to solve common parameter issues 
    Creating Tabular and List Reports
    Find out how to display parameter values in report headers 
    Discover how to create standard report subscriptions 
    Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services 
    Working with Parameters
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 
    Explore the use of Reporting Services gauges 
    Explore creating linked reports 
    Creating Matrix Reports and Charts

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Cil-y-coed
  • 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 ...
  • The Global Collections
    Report Builder vs. Report Designer
    Reporting Services Modes
    Building a List Report Configuring Tablix  Properties and Groups
    Exploring the Tablix Report Type
    Service Architecture  Report Building Tools
    Page Headers and Footers Report Formatting Options
    Groups before Row Headers
    Report Parameters
    Displaying the Parameter Value and Label for a Drop-Down List Parameter
    Considering Report Layout Options
    Variable Collection
    Building a Report with Report Builder
    Setting Report Project Properties
    Working with Maps and Spatial Data  Enhancing Reports with Data Visualisation
    Synchronized Data Alignment  Using the Tablix Report Type
    Report Items Collection
    Work with Multivalued Parameters  Enhancing Reports with Data Visualisations
    Formatting Text Boxes in the Text Box Properties Dialogue Box
    Create a Custom Function  Managing Page Layout and Adding Interactivity
    Page Structure Properties

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Cil-y-coed
  • 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 ...
  • Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Report caching, snapshots, and comments
    Data filters
    Report subscription and delivery Administering Reporting Services
    Report parameters
    Creating a report with the report wizard
    Databars, sparklines, indicators, gauges, and maps
    Work with expressions and embedded code.
    Reporting services tools Reporting Services Data Sources
    Create a report using report builder or report designer.
    Formatting data
    Extend reporting services functionality with external assemblies.
    Drilldown and drill through Sharing Reporting Services Reports
    Report sub-reports
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Topics include Introduction to Reporting Services
    Implementing report filters and parameters Visualizsng Data with Report Services
    Sorting and grouping
    Schedules
    Images and charts
    Drillthrough in mobile reports

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Cil-y-coed
  • 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 Data Sources
    Exploring Subscriptions
    SQL Server 2016 Report Builder Wizards
    Understanding Report Parts
    Filtering, Grouping, and Sorting
    Introduction to SQL Server 2016 Report Builder
    SQL Server 2016 Report Builder Graphics
    SQL Server 2016 Report Builder Advanced Reporting
    Using Tables
    Utilizing Charts
    Working with Expressions
    Mastering Data Region(s)
    Working with Datasets
    Utilizing Chart Wizard
    Utilizing Dynamic Headers and Footers
    SQL Server 2016 Report Builder Basic Reports
    Exploring the Report Builder Interface
    Working with Map Wizard

  • See Training Course Details...



Email us about this courses



Other Cil-y-coed Enable Technology Training Courses

Excel Power Pivot - Cil-y-coed Excel Training Courses
Crystal 2011 Cil-y-coed Training Courses
Microsoft Project Level 3 Cil-y-coed Training Courses
SQL Cil-y-coed Training Courses
CSS Cil-y-coed Training Courses
Oracle SQL Cil-y-coed Training Courses
Microsoft Project Level 2 Cil-y-coed Training Courses
Crystal 2016 - Cil-y-coed Crystal Reports Training Courses
VBA Cil-y-coed Training Courses
SSAS 2017 - Cil-y-coed SQL Server Analysis Services Training Courses
Crystal 2008 - Cil-y-coed Crystal Reports Training Courses
Excel Basic Cil-y-coed Training Courses
Access 2016 Cil-y-coed Training Courses
PL/SQL - Cil-y-coed SQL Training Courses
JavaScript Cil-y-coed Training Courses