SQL SERVER REPORTING SERVICES TRAINING COURSES LANCASHIRE
About Enable Technology Lancashire SQL Server Reporting Services Training Courses
We are a company that offers short, practical, SQL Server Reporting Services hands on technology courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a SQL Server Reporting Services course receives learning resources which also serves as a reference source after the course. Enable Technology offer post course help to all delegates. Participants on the SQL Server Reporting Services course can contact the tutor for as long as they like if they encounter SQL Server Reporting Services problems.
We provide instructor led training coupled with hands on training. 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. The SQL Server Reporting Services syllabus can be modified to accommodate your specific training needs.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Dollond & Aitchison Limited, Canadian High Commission, Keele University, West Bromwich Building Society, University of Birmingham, Cadbury PLC, Boots UK Limited and South Staffordshire Water PLC.
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Lancashire
- 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 ... Create a Report with Interactive Sorting Dynamic Reports with Parameters
- See Training Course Details...
A Tour of the Report Builder Interface
Preview Performance
Work with Multivalued Parameters Enhancing Reports with Data Visualisations
Exploring the Tablix Report Type
Report Designer and Data Windows Configuring Report Projects
Create a Matrix Report
Indicators
Creating a Columnar Report
Create Shared Data Sources and Data Sets
Create a Data Source Connection
Parameters and Stored Procedures
Create and Configure a Report Server Project
Reordering Report Parameters Using Drop-Down List Parameters
The Report Designer Creating Reports with SQL Server Data Tools
Rein in the Length of a Text Field
Expression Operators
Shared Data Sources
Creating a Custom Age Function
Create a Drop-Down List Parameter
Report Project Files and Folders
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Lancashire
- 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 ... Explore the maintenance of report history
- See Training Course Details...
Learn how to calculate group totals and percentages
Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services
Learn how to create matrix reports
Learn how to call the Report Server Web Service
Investigate how to manage Reporting Services projects using Report Manager
Investigate what SQL Server Reporting Services can do
Calculation and Formatting
Managing Reporting Services
Investigate Reporting Services charts
Programming Reporting Services
Discover the many application programming interfaces of Reporting Services
Learn how to create custom functions using the Code window
Investigate how Reporting Services secures access to reports and other Reporting Services resources
Learn how to work with rich text to produce mail merge style reports
Dig into the use of unbound, multivalued, and cascading parameters
Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services
Find out how you can use conditional formatting to make your reports more dynamic
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Lancashire
- 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 ... General
- See Training Course Details...
Parameters
Introduction to Reporting Services 2005
Report Filters
Reporting Services 2005 Query and Report Parameters
The Reporting Services 2005 Report Designer
Reporting Services 2005 Security Model Concepts
Deploying Reports with Development Studio
Data Output
Parts of the Chart
Reporting Services 2005 Data Processing Extensions
The Reporting Services 2005 Layout View
Auditing and Management Reports
Managing Tables with the Table Properties Dialog
Changing Columns and Rows
Reporting Services 2005 Security
Understanding Reporting Services 2005 Subscriptions
Sorting
Deploy Sample Reports to Report Server
Reporting Services 2005 Deployment Options
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Lancashire
- 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 ... SQL Server 2016 Report Builder Wizards
- See Training Course Details...
Understanding Variances Between SQL Versions
Filtering, Grouping, and Sorting
Examining Management
Exploring the Report Builder Interface
Formatting Reports
Utilizing Chart Wizard
Working with Expressions
Understanding Report Parts
SQL Server 2016 Report Builder Advanced Reporting
Examining Maps
Understanding Visualizations
SQL Server 2016 Report Builder Graphics
Examining Parameters
Understanding HTML5 and Textboxes
Mastering Data Region(s)
Working with Map Wizard
Utilizing Dynamic Headers and Footers
Using the List Object to Combine Other Items
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Lancashire
- 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 ... Sorting and grouping
- See Training Course Details...
Databars, sparklines, indicators, gauges, and maps
Work with expressions and embedded code.
Introduction to reporting services
Secure access to reports by using authentication, permissions, and SSL encryption.
Preparing data for mobile reports
Schedules
Create a report using report builder or report designer.
Report subscription and delivery Administering Reporting Services
Extend reporting services functionality with external assemblies.
Publish a report to reporting services Working with Reporting Services Data
Mobile report publisher
Use report services configuration manager to reconfigure SSRS servers.
Formatting data
Report parameters
Reporting services tools Reporting Services Data Sources
Reporting services components
Using Datasets Creating Paginated Reports
Configuring data access with report designer
Implementing report filters and parameters Visualizsng Data with Report Services
Creating a report with the report wizard
Email us about this courses
Other Lancashire Enable Technology Training Courses
Access VBA - Lancashire Access Training Courses
Oracle SQL Lancashire Training Courses
Crystal 2013 Lancashire Training Courses
SSIS 2008 Lancashire Training Courses
Excel Power Pivot Lancashire Training Courses
Crystal XI - Lancashire Crystal Reports Training Courses
PowerPoint Advanced Lancashire Training Courses
SSAS 2005 - Lancashire SQL Server Analysis Services Training Courses
Power Graphics Lancashire Training Courses
Power BI - Lancashire Microsoft Power BI Training Courses
Excel Advanced - Lancashire Excel Training Courses
SQL Lancashire Training Courses
Crystal 2016 Lancashire Training Courses
Project 2016 Lancashire Training Courses
DAX - Lancashire Excel Training Courses
North West - Possible Sql Server Reporting Services Training Course Locations
Birkenhead, Leigh, Merseyside, Eccles, Warrington, Lytham Urmston, Widnes, Macclesfield, Wythenshawe, Burnley, Leyland, Liverpool, Kirkby, Middleton, Hyde, Ashton-under-Lyne, Stretford, Southport, Manchester, Skelmersdale, Lancaster, Winsford, Saddleworth, Salford, Rochdale, Chester, Barrow-in-Furness, Thornton-Cleveleys, Bury, Crewe, Denton, Prestwich, Farnworth, Bolton, Preston, Crosby, Wallasey, Runcorn, Wigan, North West, Northwich, Chadderton, Accrington, Cheshire, Chorley, Morecambe, Oldham, Carlisle, Blackburn, Bootle, Altrincham, Ellesmere Port, Blackpool, Lancashire, Huyton, Stockport, Sale