SQL SERVER REPORTING SERVICES TRAINING COURSES LEIGH
About Enable Technology Leigh SQL Server Reporting Services Training Courses
We have a twenty year history of providing skills based SQL Server Reporting Services industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each course participant will be issued with training SQL Server Reporting Services resources which they can continue to use 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.
Courses are instructor led and groups sizes small. While social distancing is in place we are only delivering SQL Server Reporting Services courses via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance. We will work with you prior to the course to tailor the SQL Server Reporting Services syllabus to match your requirements.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Birmingham City University, Nuclear Engineering Services, Cadbury PLC, TalkTalk Direct Limited, Total Telecommunications Limited, Royal & Sun Alliance Group PLC, Fujistu PLC and Shell UK Oil Products Ltd.
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Leigh
- 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 ... Adding Data Fields to a Table Data Region
- See Training Course Details...
Design the Table or Design the Matrix Dialog
Creating a Report Model Project
Perspectives
History Properties
Reporting Services 2005 Toolbars
Adding or Deleting
Execution Reporting Services 2005 Log Reports
Filters
Create a Dataset
Explorer Pane
Understanding Reporting Services 2005 Caching
Understanding Security Settings
Reporting Services 2005 Distribution Options
Adding System-level Roles
Changing Columns and Rows
Dynamic Parameter Values (From Query)
General
SQL Server 2005 Reporting Services Features
Creating a Report Model File
Adding Groups to Reporting Services
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Leigh
- 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 call the Report Server Web Service
- See Training Course Details...
Ad-Hoc Reporting with Report Builder 2.0
Learn how to create custom functions using the Code window
Learn how to create matrix reports
Understanding how Reporting Services parameters work with stored procedure parameters
Introducing SQL Server Reporting Services
Learn how to deploy Reporting Services projects and individual reports and data sources
Learn the differences between Report Builder 1.0 and Report Builder 2.0
Explore how to create expressions in your reports using
Security
Learn how to create a tabular report from scratch
Learn how to work with rich text to produce mail merge style reports
Learn how to enable basic authentication for reports and how to require SSL for report operations
Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server
Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box
Learn how to create a basic report using the SQL Server Reporting Services Wizard
Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services
Explore creating linked reports
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Leigh
- 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 Dynamic Headers and Footers
- See Training Course Details...
Utilizing Lists
Planning Your Reports
Mastering Data Region(s)
Working with Datasets
Formatting Reports
Creating Subreports and Drillthrough Reports
Working with Expressions
Understanding HTML5 and Textboxes
Examining Parameters
SQL Server 2016 Report Builder Graphics
Working with Map Wizard
Using Tables
SQL Server 2016 Report Builder Wizards
Exploring Table or Matrix Wizard
Understanding Report Parts
Visualizing Your Company Report Templates
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Leigh
- 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 ... Report Definition Language (RDL)
- See Training Course Details...
Using Report Parts Shared Data Sets
Indicators
Providing a Drop-Down List for a Report Parameter
Introduction to SQL Server Reporting Services
Build a Simple Report
Create A Shared DataSet for Northwind
No Data Rows
Using Charts in a Report
Interactive Sorting
Create a Report Based on a Shared Data Set Creating Reports With SQL Server Data Tools
Report Parameters
Create a Data Source Connection
Writing and Using Report Expressions
Formatting Text Boxes in the Text Box Properties Dialogue Box
The Tablix Component
Shared Dataset Design View Creating Ad Hoc Reports with Report Builder
Displaying the Parameter Value and Label for a Drop-Down List Parameter
The Report Designer Creating Reports with SQL Server Data Tools
Using the Expression Editor Using Built-in Report Operators and Functions
Sparkline
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Leigh
- 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 ... Introduction to reporting services
- See Training Course Details...
Use report services configuration manager to reconfigure SSRS servers.
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Create a report using report builder or report designer.
Extend reporting services functionality with external assemblies.
Reporting services tools Reporting Services Data Sources
Add a drillthrough to a custom URL
Reporting services components
Report caching, snapshots, and comments
Secure access to reports by using authentication, permissions, and SSL encryption.
Use databars, sparklines, and indicators in reports Summarising Report Data
Sorting and grouping
Publish a report to reporting services Working with Reporting Services Data
Drilldown and drill through Sharing Reporting Services Reports
Configuring data access with report designer
Data filters
Mobile report publisher
Databars, sparklines, indicators, gauges, and maps
Drillthrough in mobile reports
Images and charts
Preparing data for mobile reports
Email us about this courses
Other Leigh Enable Technology Training Courses
Data Mining - Leigh Data Analytics Training Courses
HTML - Leigh Web Development Training Courses
Access VBA Leigh Training Courses
PL/SQL - Leigh SQL Training Courses
Excel Power Pivot - Leigh Excel Training Courses
Crystal 2013 Leigh Training Courses
SSAS 2017 - Leigh SQL Server Analysis Services Training Courses
Oracle BI - Leigh Data Analytics Training Courses
TSQL - Leigh SQL Training Courses
Microsoft Project Level 3 - Leigh Microsoft Project Training Courses
Crystal 2016 Leigh Training Courses
Visio 2013 - Leigh Visio Training Courses
SSAS 2008 Leigh Training Courses
Mobile - Leigh Web Development Training Courses
Crystal 2008 Leigh Training Courses
North West - Possible Sql Server Reporting Services Training Course Locations
North West, Barrow-in-Furness, Wythenshawe, Middleton, Runcorn, Thornton-Cleveleys, Lytham Urmston, Bury, Eccles, Ellesmere Port, Lancaster, Bolton, Morecambe, Macclesfield, Leyland, Wallasey, Hyde, Kirkby, Warrington, Stretford, Denton, Crewe, Widnes, Huyton, Cheshire, Chadderton, Preston, Merseyside, Saddleworth, Northwich, Blackpool, Winsford, Skelmersdale, Rochdale, Chorley, Lancashire, Carlisle, Bootle, Crosby, Sale, Oldham, Stockport, Birkenhead, Blackburn, Altrincham, Leigh, Prestwich, Accrington, Burnley, Southport, Ashton-under-Lyne, Chester, Liverpool, Salford, Manchester, Wigan, Farnworth