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
- See Training Course Details...
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
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
- See Training Course Details...
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
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
- See Training Course Details...
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
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
- See Training Course Details...
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
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
- See Training Course Details...
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
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