SQL SERVER REPORTING SERVICES TRAINING COURSES NATIONAL
About Enable Technology National SQL Server Reporting Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Reporting Services technology training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a SQL Server Reporting Services course will be provided with training materials and practice files to retain after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Reporting Services queries. This support is open ended.
SQL Server Reporting Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver SQL Server Reporting Services courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in National. 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 available 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.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are South Staffordshire Water PLC, Loughborough University, DHL Express, Birmingham City Council, Shell UK Oil Products Ltd, Barclays Bank PLC, Aston University and Canadian High Commission.
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: National
- 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 ... Run the Sample Reports
- See Training Course Details...
History Properties
Reporting Services 2005 Web Components
Configure and Run the Job Package
Key Considerations
Perspectives
Previewing a Report
Creating a Report Model File
Linked Reports
Resizing
SQL Server Management Studio Overview
Data Output
Execution Reporting Services 2005 Log Reports
Chart Options
Reporting Services 2005 Client Components
Displaying Parameters in a Report
Clickthrough Reports
Visibility
Publishing Reporting Services 2005 Reports
Table Data Region Record Sorting
Sorting
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: National
- 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 ... Extend reporting services functionality with external assemblies.
- See Training Course Details...
Databars, sparklines, indicators, gauges, and maps
Publish a report to reporting services Working with Reporting Services Data
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Use report services configuration manager to reconfigure SSRS servers.
Schedules
Overview of mobile reports
Reporting services components
Using Datasets Creating Paginated Reports
Configuring data access with report builder
Creating a report with the report wizard
Report sub-reports
Formatting data
Configuring data access with report designer
Report parameters
Preparing data for mobile reports
Drilldown and drill through Sharing Reporting Services Reports
Work with expressions and embedded code.
Secure access to reports by using authentication, permissions, and SSL encryption.
Drillthrough in mobile reports
Implementing report filters and parameters Visualizsng Data with Report Services
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: National
- 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 ... Shared Data Sources
- See Training Course Details...
Using Unbound Parameters Understanding Report And Data Set Parameters
Expression Operators
Considering Report Layout Options
Using Charts in a Report
Create a Tabular Report Using the Tablix Report Type
Designing the Page Layout
Using Parameters with Ad Hoc SQL
Built-in Functions
Reordering Report Parameters Using Drop-Down List Parameters
Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
Overview
Introduction to SQL Server Reporting Services
A Tour of the Report Builder Interface
Create a Matrix Report
Report Builder vs. Report Designer
Report Project Configurations Creating a New Report in the Report Designer
Preview Performance
Create a Pie Chart with Point Labels
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: National
- 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 Matrix
- See Training Course Details...
Examining Parameters
Working with Map Wizard
Understanding HTML5 and Textboxes
Exploring Gauges
SQL Server 2016 Report Builder Wizards
Exploring Table or Matrix Wizard
Using the List Object to Combine Other Items
Examining Management
Exploring Subscriptions
Planning Your Reports
Utilizing Charts
Understanding Variances Between SQL Versions
Utilizing Chart Wizard
Creating Subreports and Drillthrough Reports
Understanding Report Parts
Utilizing Dynamic Headers and Footers
SQL Server 2016 Report Builder Basic Reports
Visualizing Your Company Report Templates
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: National
- 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 ... Security
- See Training Course Details...
Investigate what SQL Server Reporting Services can do
Learn how to work with rich text to produce mail merge style reports
Learn how to use URL to integrate Reporting Services reports into your applications
Managing Reporting Services
Understand how to plan and configure for deployment
Explore how to create expressions in your reports using
Learn how to create parameters in ad-hoc SQL
Explore the basic architecture of SQL Server Reporting Services
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
Understanding how Reporting Services parameters work with stored procedure parameters
Explore the maintenance of report history
Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box
Working with Parameters
Explore the potential deployment and security issues that might arise when working with custom assemblies
Advanced Reporting Services Programming
Investigate Reporting Services charts
Email us about this courses
Other National Enable Technology Training Courses
HTML - National Web Development Training Courses
Crystal XI - National Crystal Reports Training Courses
Microsoft Project Level 2 - National Microsoft Project Training Courses
Excel Power Pivot - National Excel Training Courses
SSIS 2008 - National SQL Server Integration Services Training Courses
TSQL - National SQL Training Courses
Access 2016 - National Access Training Courses
PHP National Training Courses
Crystal 2008 - National Crystal Reports Training Courses
Power Graphics National Training Courses
Access VBA National Training Courses
Excel Advanced National Training Courses
JQuery Mobile National Training Courses
SSIS 2005 National Training Courses
PowerPoint Advanced National Training Courses