SQL SERVER REPORTING SERVICES TRAINING COURSES ASHTON-UNDER-LYNE
About Enable Technology Ashton-under-lyne SQL Server Reporting Services Training Courses
We are a company that offers short, practical, SQL Server Reporting Services hands on technology courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a SQL Server Reporting Services course receives learning resources which also serves as a reference source after the course. 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.
Courses are instructor led and groups sizes small. This instructor led course is available online only during the current lockdown. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Reporting Services training needs.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Unipart Group, National Power PLC, Norwich Union PLC, Countrywide Homes Limited, TalkTalk Direct Limited, Birmingham City University, Norfolk Police Constabulary and Vodafone Group Services.
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Ashton-under-lyne
- 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 ... Grouping and Sorting
- See Training Course Details...
Investigate the list data region
Dig into the use of unbound, multivalued, and cascading parameters
Explore creating linked reports
Learn the differences between Report Builder 1.0 and Report Builder 2.0
Learn how to create a basic report using the SQL Server Reporting Services Wizard
Learn how to create a tabular report from scratch
Programming Reporting Services
Learn how to calculate group totals and percentages
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
Working with Parameters
Creating Tabular and List Reports
Learn how to work with rich text to produce mail merge style reports
Explore the maintenance of report history
Learn how to enable basic authentication for reports and how to require SSL for report operations
Learn how to create custom functions using the Code window
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Ashton-under-lyne
- 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 ... Creating Subreports and Drillthrough Reports
- See Training Course Details...
Working with Map Wizard
Exploring Gauges
Visualizing Your Company Report Templates
Exploring Subscriptions
Understanding HTML5 and Textboxes
Formatting Reports
Mastering Data Region(s)
Utilizing Charts
Utilizing Dynamic Headers and Footers
SQL Server 2016 Report Builder Advanced Reporting
Working with Expressions
Utilizing Data Sources
Using the List Object to Combine Other Items
Exploring Table or Matrix Wizard
Examining Maps
Exploring the Report Builder Interface
SQL Server 2016 Report Builder Graphics
Utilizing Lists
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Ashton-under-lyne
- 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 ... Using Reporting Services 2005 Expressions
- See Training Course Details...
Reporting Services 2005 Windows
Drawing Lines and Rectangles
Visibility
General
Creating a Subscription
Data Output
Filters
The Reporting Services 2005 Key Components
Resizing
The Reporting Services 2005 Report Wizard
Report Item Style Properties
Using the Reporting Services 2005 Graphical Query Designer
Report Formatting Toolbar
Reporting Services 2005 Query and Report Parameters
Creating a Chart Report
Filters
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Ashton-under-lyne
- 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 ... Considering Report Layout Options
- See Training Course Details...
Create a Shared Data Source and Two Data Sets
Introduction to Report Builder
No Data Rows
Create a Report with Interactive Sorting Dynamic Reports with Parameters
Creating a Customer Contact List Creating Ad Hoc Reports With Report Builder
Using Report Parts Shared Data Sets
Create a Parameterised Report
Building a Tabular Report
Rein in the Length of a Text Field
Report Definition Language (RDL)
Report Parameters
Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
Create a Data Source Connection
Shared Data Sources
Tablix Cell Content and Scope Building a Tablix Report
Report Project Types Working with Report Server Projects
Building a Matrix Report
Create a Report Based on a Shared Data Set Creating Reports With SQL Server Data Tools
Creating a Custom Age Function
Page Structure Properties
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Ashton-under-lyne
- 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 ... Overview of mobile reports
- See Training Course Details...
Drilldown and drill through Sharing Reporting Services Reports
Databars, sparklines, indicators, gauges, and maps
Report sub-reports
Secure access to reports by using authentication, permissions, and SSL encryption.
Extend reporting services functionality with external assemblies.
Creating a report with the report wizard
Topics include Introduction to Reporting Services
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Data filters
Publish a report to reporting services Working with Reporting Services Data
Introduction to reporting services
Configuring data access with report builder
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Mobile report publisher
Use report services configuration manager to reconfigure SSRS servers.
Report subscription and delivery Administering Reporting Services
Preparing data for mobile reports
Use databars, sparklines, and indicators in reports Summarising Report Data
Drillthrough in mobile reports
Using Datasets Creating Paginated Reports
Email us about this courses
Other Ashton-under-lyne Enable Technology Training Courses
Excel Basic - Ashton-under-lyne Excel Training Courses
VBA - Ashton-under-lyne Excel Training Courses
Project 2016 L1 Ashton-under-lyne Training Courses
Crystal XI Ashton-under-lyne Training Courses
TSQL Ashton-under-lyne Training Courses
Data Mining Ashton-under-lyne Training Courses
DAX - Ashton-under-lyne Excel Training Courses
Crystal 2011 Ashton-under-lyne Training Courses
Project 2016 - Ashton-under-lyne Microsoft Project Training Courses
Power Graphics - Ashton-under-lyne Data Analytics Training Courses
Crystal 2008 - Ashton-under-lyne Crystal Reports Training Courses
Oracle BI Ashton-under-lyne Training Courses
SSIS 2008 - Ashton-under-lyne SQL Server Integration Services Training Courses
SSIS 2005 - Ashton-under-lyne SQL Server Integration Services Training Courses
Data Warehouse - Ashton-under-lyne SQL Training Courses