SQL SERVER REPORTING SERVICES TRAINING COURSES OLDHAM
About Enable Technology Oldham 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. Each course participant will be issued with training SQL Server Reporting Services resources which they can continue to use after the training. It is our company policy to provide SQL Server Reporting Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Reporting Services course can contact the Tutor for as long as they need assistance after the training.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Reporting Services onsite. If you prefer we can offer an offsite socially distanced training location in Oldham. We offer the option of working with you to develop a bespoke SQL Server Reporting Services programme which precisely matches your organisations training requirements.
SQL Server Reporting Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Carillion PLC, Unipart Group, Loughborough University, EDF Energy PLC, Barclays Bank PLC, Capita Group PLC, West Bromwich Building Society and Birmingham Heartlands Hospital.
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Oldham
- 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 Report Designer Creating Reports with SQL Server Data Tools
- See Training Course Details...
Using the Expression Editor Using Built-in Report Operators and Functions
Report Items Collection
Using Report Parts Shared Data Sets
Building a Tabular Report
Globals Collection
Create a Shared Data Source and Two Data Sets
Create a Custom Function Managing Page Layout and Adding Interactivity
Null Handling
Globals Collection Creating Custom Functions
Create a Pie Chart with Point Labels
Report Project Types Working with Report Server Projects
Create a Tabular Report Using the Tablix Report Type
Data Set Parameters
Formatting Tablix Rows and Columns Making Reports Interactive
The Global Collections
Cascading Parameters
Shared Data Sources
Indicators
No Data Rows
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Oldham
- 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 scheduling of report snapshots
- See Training Course Details...
Learn about datasets and data regions
Find out how you can use conditional formatting to make your reports more dynamic
Learn how to enable basic authentication for reports and how to require SSL for report operations
Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services
Creating Matrix Reports and Charts
Learn how to create parameters in ad-hoc SQL
Explore the basic architecture of SQL Server Reporting Services
Investigate how to manage Reporting Services projects using Report Manager
Gain a basic understanding of the components behind SQL Server Reporting Services
Understanding how Reporting Services parameters work with stored procedure parameters
Calculation and Formatting
Learn how to deploy Reporting Services projects and individual reports and data sources
Explore the storing of credentials within a data source
Learn the differences between Report Builder 1.0 and Report Builder 2.0
Learn how to create a tabular report from scratch
Explore the maintenance of report history
Investigate how to call a custom assembly from a report
Learn how to use URL to integrate Reporting Services reports into your applications
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Oldham
- 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 ... Use databars, sparklines, and indicators in reports Summarising Report Data
- See Training Course Details...
Report sub-reports
Data filters
Implementing report filters and parameters Visualizsng Data with Report Services
Reporting services components
Work with expressions and embedded code.
Add a drillthrough to a custom URL
Drillthrough in mobile reports
Drilldown and drill through Sharing Reporting Services Reports
Introduction to reporting services
Schedules
Publish a report to reporting services Working with Reporting Services Data
Extend reporting services functionality with external assemblies.
Create a report using report builder or report designer.
Sorting and grouping
Using Datasets Creating Paginated Reports
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Databars, sparklines, indicators, gauges, and maps
Configuring data access with report builder
Creating a report with the report wizard
Preparing data for mobile reports
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Oldham
- 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 ... Reporting Services 2005 Diagram Pane
- See Training Course Details...
Data Output
Reporting Services 2005 Menus
Managing Objects in Object Explorer
General
Attributes
Completing the Wizard Dialog
Add Report Parameter to a Dataset
Explorer Pane
Creating a Report Model Project
Design the Query Dialog
Tools for Managing Reports
Formatting Reporting Services 2005 Reports
Formatting
Create a Data Source
Web Folder Properties
Understanding Reporting Services 2005 Caching
Report Builder Design Layout
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Oldham
- 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 ... Exploring Subscriptions
- See Training Course Details...
Exploring Gauges
Working with Map Wizard
Working with Expressions
Examining Security
Understanding Variances Between SQL Versions
Understanding Visualizations
Exploring Table or Matrix Wizard
Planning Your Reports
Examining Parameters
Using the List Object to Combine Other Items
Introduction to SQL Server 2016 Report Builder
Exploring the Report Builder Interface
Filtering, Grouping, and Sorting
Examining Maps
Examining Management
Utilizing Lists
SQL Server 2016 Report Builder Basic Reports
Working with Datasets
Exploring Matrix
SQL Server 2016 Report Builder Wizards
Email us about this courses
Other Oldham Enable Technology Training Courses
TSQL - Oldham SQL Training Courses
Oracle SQL Oldham Training Courses
Project 2016 - Oldham Microsoft Project Training Courses
HTML - Oldham Web Development Training Courses
SSIS 2005 Oldham Training Courses
JQuery - Oldham JavaScript Training Courses
Excel Intermediate - Oldham Excel Training Courses
Excel Advanced Oldham Training Courses
Crystal 2016 - Oldham Crystal Reports Training Courses
SSAS 2008 - Oldham SQL Server Analysis Services Training Courses
SSIS 2008 Oldham Training Courses
PowerPoint Advanced Oldham Training Courses
Crystal 2011 - Oldham Crystal Reports Training Courses
Power Query Oldham Training Courses
SSAS 2017 Oldham Training Courses
North West - Possible Sql Server Reporting Services Training Course Locations
Lytham Urmston Sql Server Reporting Services Training Courses Lytham Urmston, Merseyside, Ellesmere Port, Bolton, Runcorn, Cheshire, Crewe, Farnworth, Bury, Northwich, Carlisle, Middleton, Chester, Kirkby, Warrington, Saddleworth, Morecambe, Winsford, Chorley, Sale, Leigh, Birkenhead, Rochdale, Lancaster, Bootle, Prestwich, Crosby, Skelmersdale, Leyland, Eccles, Accrington, Salford, Stretford, Manchester, Chadderton, North West, Preston, Widnes, Altrincham, Hyde, Wigan, Ashton-under-lyne, Blackpool, Huyton, Wallasey, Stockport, Liverpool, Lancashire, Oldham, Thornton-cleveleys, Southport, Burnley, Denton, Wythenshawe, Blackburn, Barrow-in-furness, Macclesfield
Merseyside Sql Server Reporting Services Training Courses
Ellesmere Port Sql Server Reporting Services Training Courses
Bolton Sql Server Reporting Services Training Courses
Runcorn Sql Server Reporting Services Training Courses
Cheshire Sql Server Reporting Services Training Courses
Crewe Sql Server Reporting Services Training Courses
Farnworth Sql Server Reporting Services Training Courses
Bury Sql Server Reporting Services Training Courses
Northwich Sql Server Reporting Services Training Courses
Carlisle Sql Server Reporting Services Training Courses
Middleton Sql Server Reporting Services Training Courses
Chester Sql Server Reporting Services Training Courses
Kirkby Sql Server Reporting Services Training Courses
Warrington Sql Server Reporting Services Training Courses
Saddleworth Sql Server Reporting Services Training Courses
Morecambe Sql Server Reporting Services Training Courses
Winsford Sql Server Reporting Services Training Courses
Chorley Sql Server Reporting Services Training Courses
Sale Sql Server Reporting Services Training Courses
Leigh Sql Server Reporting Services Training Courses
Birkenhead Sql Server Reporting Services Training Courses
Rochdale Sql Server Reporting Services Training Courses
Lancaster Sql Server Reporting Services Training Courses
Bootle Sql Server Reporting Services Training Courses
Prestwich Sql Server Reporting Services Training Courses
Crosby Sql Server Reporting Services Training Courses
Skelmersdale Sql Server Reporting Services Training Courses
Leyland Sql Server Reporting Services Training Courses
Eccles Sql Server Reporting Services Training Courses
Accrington Sql Server Reporting Services Training Courses
Salford Sql Server Reporting Services Training Courses
Stretford Sql Server Reporting Services Training Courses
Manchester Sql Server Reporting Services Training Courses
Chadderton Sql Server Reporting Services Training Courses
North West Sql Server Reporting Services Training Courses
Preston Sql Server Reporting Services Training Courses
Widnes Sql Server Reporting Services Training Courses
Altrincham Sql Server Reporting Services Training Courses
Hyde Sql Server Reporting Services Training Courses
Wigan Sql Server Reporting Services Training Courses
Ashton-under-Lyne Sql Server Reporting Services Training Courses
Blackpool Sql Server Reporting Services Training Courses
Huyton Sql Server Reporting Services Training Courses
Wallasey Sql Server Reporting Services Training Courses
Stockport Sql Server Reporting Services Training Courses
Liverpool Sql Server Reporting Services Training Courses
Lancashire Sql Server Reporting Services Training Courses
Oldham Sql Server Reporting Services Training Courses
Thornton-Cleveleys Sql Server Reporting Services Training Courses
Southport Sql Server Reporting Services Training Courses
Burnley Sql Server Reporting Services Training Courses
Denton Sql Server Reporting Services Training Courses
Wythenshawe Sql Server Reporting Services Training Courses
Blackburn Sql Server Reporting Services Training Courses
Barrow-in-Furness Sql Server Reporting Services Training Courses
Macclesfield Sql Server Reporting Services Training Courses