SQL SERVER REPORTING SERVICES TRAINING COURSES WEDNESBURY
About Enable Technology Wednesbury SQL Server Reporting Services Training Courses
We offer intensive two and three days SQL Server Reporting Services courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training SQL Server Reporting Services resources which they can continue to use after the training. Our policy is to provide open ended SQL Server Reporting Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
We provide instructor led training coupled with hands on training. This taught SQL Server Reporting Services course is available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic. We are happy to modify the SQL Server Reporting Services syllabus to match your teams training requirements.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are National Power PLC, Aston University, Loughborough University, Yell Group PLC, Norfolk Police Constabulary, Halfords Group PLC, South Staffordshire Water PLC and Wolverhampton City Council.
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Wednesbury
- 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...
Visualizing Your Company Report Templates
Working with Datasets
Working with Map Wizard
Mastering Data Region(s)
Filtering, Grouping, and Sorting
Exploring Subscriptions
SQL Server 2016 Report Builder Graphics
Using the List Object to Combine Other Items
Examining Management
Examining Maps
Creating Subreports and Drillthrough Reports
Examining Parameters
Utilizing Charts
Introduction to SQL Server 2016 Report Builder
Utilizing Dynamic Headers and Footers
Exploring the Report Builder Interface
SQL Server 2016 Report Builder Advanced Reporting
Exploring Matrix
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Wednesbury
- 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 ... Synchronized Data Alignment Using the Tablix Report Type
- See Training Course Details...
Using Parameters with Ad Hoc SQL
Parameters and Stored Procedures
No Data Rows
Using the Expression Editor Using Built-in Report Operators and Functions
Installing SQL Server Data Tools
Create a Matrix Report
Setting Report Project Properties
Report Definition Language (RDL)
Formatting Text Boxes in the Properties Window
Data Bars
Work with Multivalued Parameters Enhancing Reports with Data Visualisations
Creating a Custom Age Function
Shared Data Sources
Create a Form-Like Report from a list Calculations Using Expressions And Functions
Field Collection
Sparkline
Create Shared Data Sources and Data Sets
Report Items Collection
Designing the Page Layout
Shared Dataset Design View Creating Ad Hoc Reports with Report Builder
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Wednesbury
- 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 ... Using Datasets Creating Paginated Reports
- See Training Course Details...
Report sub-reports
Report subscription and delivery Administering Reporting Services
Overview of mobile reports
Data filters
Introduction to reporting services
Creating a report with the report wizard
Reporting services components
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Topics include Introduction to Reporting Services
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Add a drillthrough to a custom URL
Publish a report to reporting services Working with Reporting Services Data
Work with expressions and embedded code.
Formatting data
Drilldown and drill through Sharing Reporting Services Reports
Drillthrough in mobile reports
Create a report using report builder or report designer.
Use report services configuration manager to reconfigure SSRS servers.
Report parameters
Schedules
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Wednesbury
- 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 ... Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box
- See Training Course Details...
Investigate the scheduling of report snapshots
Learn how to create a tabular report from scratch
Explore creating linked reports
Discover the many application programming interfaces of Reporting Services
Investigate how to manage Reporting Services projects using Report Manager
Investigate how to call a custom assembly from a report
Discover interactive sorting
Learn how to create matrix reports
Ad-Hoc Reporting with Report Builder 2.0
Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services
Master the Reporting Services Grouping pane
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
Discover how to improve parameter prompts using drop-down list parameters
Understand how to plan and configure for deployment
Explore the use of Reporting Services gauges
Creating Matrix Reports and Charts
Investigate the list data region
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Wednesbury
- 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 ... Usability Features
- See Training Course Details...
Reporting Services 2005 Diagram Pane
Creating a New Report Project
Create a Database for Report Execution Data
Settings
Included Reporting Services 2005 Extensions
Designing the Layout
Report Model Generation Rules
Creating a Report Model Project
Changing Columns and Rows
Reporting Services 2005 Menus
The Main Components of the Design Environment
Displaying Parameters in a Report
The Reporting Services 2005 Layout View
Adding Fields to the Table Data Region
Understanding the Model Designer
Design the Query Dialog
Visibility
Managing Reporting Services
Create a Data Source
The Management Studio Object Explorer
Email us about this courses
Other Wednesbury Enable Technology Training Courses
Crystal 2016 Wednesbury Training Courses
Data Warehouse - Wednesbury SQL Training Courses
Excel Advanced Wednesbury Training Courses
Microsoft Project Level 2 Wednesbury Training Courses
Excel Basic Wednesbury Training Courses
Crystal 2011 Wednesbury Training Courses
VBA - Wednesbury Excel Training Courses
Power Query Wednesbury Training Courses
Access VBA Wednesbury Training Courses
SSIS 2005 - Wednesbury SQL Server Integration Services Training Courses
PHP - Wednesbury PHP Training Courses
Crystal XI Wednesbury Training Courses
SSAS 2017 Wednesbury Training Courses
SSAS 2005 - Wednesbury SQL Server Analysis Services Training Courses
SSAS 2008 - Wednesbury SQL Server Analysis Services Training Courses
Midlands - Possible Sql Server Reporting Services Training Course Locations
Stourbridge, Cannock, Chester, Lichfield, Stafford, Kidsgrove, Northhampton, Stratford Upon Avon, East Midlands, Worcester, West Bromwich, Redditch, Herefordshire, Tipton, Warwick, Droitwich, Stoke On Trent, Oxford, Burton On Trent, Nottingham, Derby, Newcastle Under Lyme, West Midlands, Rugeley, Smethwick, Leicestershire, Wednesbury, Staffordshire, Kenilworth, Solihull, Kidderminster, Shrewsbury, Bridgnorth, Bromsgrove, Halesowen, Rowley, Leamington Spa, Hereford, Worcestershire, Uttoxeter, Midlands, Crewe, Shropshire, Bedworth, Coventry, Stourbridge, Dudley, Milton Keynes, Wolverhampton, Nuneaton, Sandwell, Black Country, Cheltenham, Leek, Walsall, Leicester, Rugby, Oswestry, Evesham, Malvern, Atherstone, Tamworth, Warwickshire, Birmingham, Telford, Staffordshire