SQL SERVER REPORTING SERVICES TRAINING COURSES RUGELEY
About Enable Technology Rugeley SQL Server Reporting Services Training Courses
We are a company that provides short intensive SQL Server Reporting Services training courses. All of our tutors are Microsoft Certified Professionals. Each course participant will be issued with training SQL Server Reporting Services resources which they can continue to use after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Reporting Services queries.
SQL Server Reporting Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Our delivery method during the Covid 19 period is online virtual classrooms. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the SQL Server Reporting Services course exercises. All SQL Server Reporting Services courses can be customised to meet your particular requirements.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Dollond & Aitchison Limited, EDF Energy PLC, Royal Air Force, Queen's Medical Centre Nottingham, Fujistu PLC, DHL Express, Canadian High Commission and South Staffordshire Water PLC.
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Rugeley
- 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 ... Creating a Shared Data Source and Data Sets
- See Training Course Details...
Parameters and Stored Procedures
Indicators
Creating a Columnar Report
Native Mode Architecture
Sparkline
Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
Null Handling
Formatting a Chart Visualising Performance with Data Bars, Sparklines and Indicators
Shared Dataset Design View Creating Ad Hoc Reports with Report Builder
Preview Performance
Report Builder vs. Report Designer
Globals Collection Creating Custom Functions
Service Architecture Report Building Tools
Reordering Report Parameters Using Drop-Down List Parameters
Create a Pie Chart with Point Labels
Variable Collection
Using Report Parts Shared Data Sets
Built-in Functions
Building a List Report Configuring Tablix Properties and Groups
Overview
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Rugeley
- 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 ... Formatting Reports
- See Training Course Details...
Exploring Matrix
Utilizing Dynamic Headers and Footers
Visualizing Your Company Report Templates
Examining Security
Utilizing Chart Wizard
Exploring Gauges
Working with Expressions
Creating Subreports and Drillthrough Reports
Exploring the Report Builder Interface
Working with Map Wizard
Understanding Report Parts
Understanding Variances Between SQL Versions
Utilizing Data Sources
SQL Server 2016 Report Builder Wizards
Examining Parameters
Filtering, Grouping, and Sorting
Examining Management
Using Tables
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Rugeley
- 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 ... Discover the many application programming interfaces of Reporting Services
- See Training Course Details...
Learn how to create data-driven report subscriptions
Investigate how to manage Reporting Services projects using Report Manager
Investigate how Reporting Services secures access to reports and other Reporting Services resources
Dig into the use of unbound, multivalued, and cascading parameters
Find out how to use Report Manager to manage user accounts and roles
Ad-Hoc Reporting with Report Builder 2.0
Discover the various global collections that you can reference in your expressions
Learn how to create matrix reports
Learn how to create a basic report using the SQL Server Reporting Services Wizard
Find out how you can use conditional formatting to make your reports more dynamic
Learn about report variables and when you might need to use them
Working with Parameters
Snapshots and Subscriptions
Learn how to enable basic authentication for reports and how to require SSL for report operations
Security
Discover the classes and methods exposed by the Reporting Services Web Service API
Gain a basic understanding of the components behind SQL Server Reporting Services
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Rugeley
- 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 ... Creating a report with the report wizard
- See Training Course Details...
Reporting services tools Reporting Services Data Sources
Mobile report publisher
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
Data filters
Introduction to reporting services
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Using Datasets Creating Paginated Reports
Drilldown and drill through Sharing Reporting Services Reports
Use report services configuration manager to reconfigure SSRS servers.
Drillthrough in mobile reports
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Extend reporting services functionality with external assemblies.
Reporting services components
Databars, sparklines, indicators, gauges, and maps
Secure access to reports by using authentication, permissions, and SSL encryption.
Create a report using report builder or report designer.
Images and charts
Formatting data
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Rugeley
- 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 ... Default Folder Structure
- See Training Course Details...
Reporting Services 2005 Data Options
Query tab
Creating a Data Source View
Filters
Tables Pane
The Reporting Services 2005 Layout View
Reporting Services 2005 Menus
Reporting Services 2005 Web Components
Launching Report Builder
Understanding Users and Groups
Reporting Services 2005 Deployment Options
Changing Columns and Rows
Adding System-level Roles
A Closer Look at Preview
Understanding Snapshots
Building Report Models in Reporting Services 2005
Static Subscription
Email us about this courses
Other Rugeley Enable Technology Training Courses
VBA Rugeley Training Courses
PowerPoint Advanced Rugeley Training Courses
Data Mining - Rugeley Data Analytics Training Courses
Project 2016 L1 - Rugeley Microsoft Project Training Courses
SSIS 2008 Rugeley Training Courses
PHP - Rugeley PHP Training Courses
SSAS 2014 - Rugeley SQL Server Analysis Services Training Courses
PowerPoint Basic Rugeley Training Courses
Crystal 2008 Rugeley Training Courses
Access VBA Rugeley Training Courses
Oracle SQL Rugeley Training Courses
CSS Rugeley Training Courses
Project 2016 Rugeley Training Courses
SSAS Tabular - Rugeley SQL Server Analysis Services Training Courses
PL/SQL - Rugeley SQL Training Courses
Midlands - Possible Sql Server Reporting Services Training Course Locations
Leamington Spa, Shropshire, Stoke On Trent, West Bromwich, Hereford, Wolverhampton, Malvern, Black Country, Shrewsbury, Chester, Solihull, Birmingham, Sandwell, Derby, Burton On Trent, Coventry, Midlands, Bromsgrove, Stratford Upon Avon, Oswestry, Worcestershire, Atherstone, Newcastle Under Lyme, Milton Keynes, Walsall, Tamworth, Bridgnorth, Crewe, Worcester, Stafford, Cannock, Warwickshire, Droitwich, Stourbridge, Rugeley, Dudley, Lichfield, Rowley, Redditch, Wednesbury, Staffordshire, Telford, Nottingham, Cheltenham, Leek, Tipton, Halesowen, Herefordshire, East Midlands, Nuneaton, Leicestershire, Leicester, Kenilworth, Northhampton, Oxford, Kidderminster, Rugby, Bedworth, Smethwick, West Midlands, Evesham, Kidsgrove, Stourbridge, Warwick, Staffordshire, Uttoxeter