SQL SERVER REPORTING SERVICES TRAINING COURSES HEREFORD
About Enable Technology Hereford SQL Server Reporting Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Reporting Services skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant is given SQL Server Reporting Services courseware which they can refer to 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.
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 crisis we can deliver this course online. Delegates participate in a virtual SQL Server Reporting Services class and can both talk to and share their screen with the tutor. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Reporting Services course to some extent is bespoke and tailored to your needs.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Norfolk Police Constabulary, EDF Energy PLC, Halfords Group PLC, Total Telecommunications Limited, Cadbury PLC, University of Birmingham, Keele University and Boots UK Limited.
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Hereford
- 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 ... Dig into the use of unbound, multivalued, and cascading parameters
- See Training Course Details...
Learn how to deploy Reporting Services projects and individual reports and data sources
Understand how to plan and configure for deployment
Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box
Investigate the scheduling of report snapshots
Calculation and Formatting
Explore the basic architecture of SQL Server Reporting Services
Master the Reporting Services Grouping pane
Learn how to create a tabular report from scratch
Investigate what SQL Server Reporting Services can do
Learn how to create custom functions using the Code window
Ad-Hoc Reporting with Report Builder 2.0
Explore how to create expressions in your reports using
Learn how to work with rich text to produce mail merge style reports
Investigate the list data region
Understand scope as it applies to aggregate functions
Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Hereford
- 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 ... Understanding Report Parts
- See Training Course Details...
Understanding Visualizations
Planning Your Reports
Mastering Data Region(s)
Filtering, Grouping, and Sorting
Creating Subreports and Drillthrough Reports
SQL Server 2016 Report Builder Wizards
Formatting Reports
Exploring Table or Matrix Wizard
Working with Map Wizard
Working with Datasets
Understanding Variances Between SQL Versions
Exploring Matrix
Examining Parameters
Utilizing Data Sources
Utilizing Chart Wizard
Examining Security
Using the List Object to Combine Other Items
SQL Server 2016 Report Builder Graphics
Examining Management
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Hereford
- 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 ... Clickthrough Reports
- See Training Course Details...
Sorting
Changing Columns and Rows
Dynamic Parameter Values (From Query)
Create a Data Source
Included Reporting Services 2005 Extensions
Rendering Extensions
Data Output
Chart Options
Create a Database for Report Execution Data
Building a Table Report
Previewing a Report with Parameters
Choose Table Style or Matrix Style Dialog
Reporting Services 2005 Administration
Creating a Data Source and Dataset
Chart Types
History Properties
Understanding Users and Groups
Reporting Services 2005 Query vs. Report Parameters
The Reporting Services 2005 Report Wizard
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Hereford
- 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 ... Drillthrough in mobile reports
- See Training Course Details...
Configuring data access with report designer
Add a drillthrough to a custom URL
Formatting data
Secure access to reports by using authentication, permissions, and SSL encryption.
Extend reporting services functionality with external assemblies.
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Reporting services tools Reporting Services Data Sources
Report sub-reports
Data filters
Configuring data access with report builder
Creating a report with the report wizard
Introduction to reporting services
Publish a report to reporting services Working with Reporting Services Data
Work with expressions and embedded code.
Images and charts
Create a report using report builder or report designer.
Topics include Introduction to Reporting Services
Using Datasets Creating Paginated Reports
Drilldown and drill through Sharing Reporting Services Reports
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Hereford
- 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 ... Preview Performance
- See Training Course Details...
Building a Report with Report Builder
Reordering Report Parameters Using Drop-Down List Parameters
Synchronized Data Alignment Using the Tablix Report Type
Report Project Types Working with Report Server Projects
A Tour of the Report Builder Interface
Creating a Shared Data Source and Data Sets
Rein in the Length of a Text Field
Using Parameters with Ad Hoc SQL
Create Shared Data Sources and Data Sets
Formatting Text Boxes from the Toolbars
Create a Data Source Connection
Introducing SQL Server Data Tools
No Data Rows
Using Report Parts Shared Data Sets
Working with Maps and Spatial Data Enhancing Reports with Data Visualisation
Considering Report Layout Options
Create a Report with Interactive Sorting Dynamic Reports with Parameters
Create a Tabular Report Using the Tablix Report Type
User Collection
Email us about this courses
Other Hereford Enable Technology Training Courses
JQuery - Hereford JavaScript Training Courses
Excel Intermediate - Hereford Excel Training Courses
PowerPoint Advanced Hereford Training Courses
PowerPoint Basic Hereford Training Courses
SQL Hereford Training Courses
SSIS 2005 Hereford Training Courses
HTML Hereford Training Courses
Mobile Hereford Training Courses
CSS Hereford Training Courses
PL/SQL - Hereford SQL Training Courses
SSAS 2008 - Hereford SQL Server Analysis Services Training Courses
JQuery Mobile - Hereford JavaScript Training Courses
Crystal XI - Hereford Crystal Reports Training Courses
Crystal 2016 - Hereford Crystal Reports Training Courses
JavaScript Hereford Training Courses
Midlands - Possible Sql Server Reporting Services Training Course Locations
Northhampton, Hereford, Leicester, Redditch, Atherstone, Smethwick, Bedworth, West Midlands, Wednesbury, Coventry, Oxford, Cannock, Burton On Trent, Stourbridge, Birmingham, Staffordshire, Nuneaton, Warwickshire, Chester, Leamington Spa, Herefordshire, Uttoxeter, Derby, Rowley, Stoke On Trent, Shrewsbury, Bromsgrove, Worcester, Leek, Oswestry, Staffordshire, Wolverhampton, Black Country, Telford, Worcestershire, Newcastle Under Lyme, Leicestershire, Droitwich, Kidsgrove, Stourbridge, Milton Keynes, Kidderminster, Cheltenham, Midlands, Rugeley, Stafford, Kenilworth, Walsall, Rugby, Sandwell, Tamworth, Crewe, Bridgnorth, Warwick, Nottingham, Shropshire, Solihull, Evesham, Lichfield, Halesowen, Tipton, Malvern, West Bromwich, East Midlands, Stratford Upon Avon, Dudley