SQL SERVER REPORTING SERVICES TRAINING COURSES CIL-Y-COED
About Enable Technology Cil-y-coed 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 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. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology training courses are delivered as instructor led courses. We can bring the equipment necessary to deliver SQL Server Reporting Services courses at your site. If delivery onsite is an issue we will organise a socially distanced venue near you in Cil-y-coed. Every SQL Server Reporting Services course can be modified to meet your bespoke requirements.
Taught SQL Server Reporting Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are EDF Energy PLC, Boots UK Limited, Nuclear Engineering Services, Shell UK Oil Products Ltd, Fujistu PLC, Canadian High Commission, West Bromwich Building Society and National Power PLC.
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Cil-y-coed
- 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 ... Overview
- See Training Course Details...
User Collection
Designing the Page Layout
Report Builder vs. Report Designer
Data Set Parameters
Data Bars
Create and Configure a Report Server Project
Preview Performance
Creating a Shared Data Source and Data Sets
Formatting Text Boxes from the Toolbars
Report Project Configurations Creating a New Report in the Report Designer
Exploring the Tablix Report Type
Providing a Drop-Down List for a Report Parameter
Work with Multivalued Parameters Enhancing Reports with Data Visualisations
Native Mode Architecture
Synchronized Data Alignment Using the Tablix Report Type
Shared Data Sources
Writing and Using Report Expressions
The Global Collections
Formatting Tablix Rows and Columns Making Reports Interactive
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Cil-y-coed
- 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 the differences between Report Builder 1.0 and Report Builder 2.0
- See Training Course Details...
Learn how to create data-driven report subscriptions
Find out how you can use conditional formatting to make your reports more dynamic
Learn about report variables and when you might need to use them
Learn how to create a basic report using the SQL Server Reporting Services Wizard
Explore the potential deployment and security issues that might arise when working with custom assemblies
Explore the basic architecture of SQL Server Reporting Services
Learn how to enable and control report caching
Learn about datasets and data regions
Learn how to enable basic authentication for reports and how to require SSL for report operations
Explore creating groups
Understand how to plan and configure for deployment
Learn how to create parameters in ad-hoc SQL
Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place
Gain a basic understanding of the components behind SQL Server Reporting Services
Snapshots and Subscriptions
Explore the use of Reporting Services gauges
Explore the storing of credentials within a data source
Discover how to add textboxes and other controls to reports
Learn how to call the Report Server Web Service
Learn how to work with rich text to produce mail merge style reports
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Cil-y-coed
- 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...
Formatting
Reporting Services 2005 Client Components
Completing the Wizard Dialog
Visibility
Sorting
Report Groupings
Creating a Subscription
The Reporting Services 2005 Layout View
Visual Studio 2005 and Development Studio
Building a Table Report
Deploying the Auditing and Management Reports
Model Statistics
Reporting Services 2005 Security
Web Folder Properties
Reporting Services 2005 Menus
Designing the Layout
Creating Formulas
Grouping Data
Report Builder Design Layout
Starting SQL Server Business Intelligence Development Studio
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Cil-y-coed
- 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 ... Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
- See Training Course Details...
Preparing data for mobile reports
Introduction to reporting services
Secure access to reports by using authentication, permissions, and SSL encryption.
Configuring data access with report builder
Using Datasets Creating Paginated Reports
Sorting and grouping
Schedules
Images and charts
Configuring data access with report designer
Databars, sparklines, indicators, gauges, and maps
Reporting services tools Reporting Services Data Sources
Data filters
Formatting data
Extend reporting services functionality with external assemblies.
Overview of mobile reports
Drilldown and drill through Sharing Reporting Services Reports
Implementing report filters and parameters Visualizsng Data with Report Services
Use report services configuration manager to reconfigure SSRS servers.
Mobile report publisher
Report subscription and delivery Administering Reporting Services
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Cil-y-coed
- 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 the Report Builder Interface
- See Training Course Details...
Visualizing Your Company Report Templates
Examining Parameters
Understanding Variances Between SQL Versions
Working with Datasets
Mastering Data Region(s)
SQL Server 2016 Report Builder Graphics
Creating Subreports and Drillthrough Reports
Formatting Reports
Introduction to SQL Server 2016 Report Builder
Exploring Gauges
SQL Server 2016 Report Builder Basic Reports
Exploring Subscriptions
Exploring Matrix
Examining Maps
SQL Server 2016 Report Builder Wizards
Using the List Object to Combine Other Items
Email us about this courses
Other Cil-y-coed Enable Technology Training Courses
Power BI - Cil-y-coed Microsoft Power BI Training Courses
CSS - Cil-y-coed Web Development Training Courses
Power Query - Cil-y-coed Excel Training Courses
HTML - Cil-y-coed Web Development Training Courses
Excel Intermediate - Cil-y-coed Excel Training Courses
PL/SQL - Cil-y-coed SQL Training Courses
SQL Cil-y-coed Training Courses
SSIS 2014 - Cil-y-coed SQL Server Integration Services Training Courses
Excel Basic Cil-y-coed Training Courses
Crystal 2016 Cil-y-coed Training Courses
JQuery Mobile Cil-y-coed Training Courses
Excel Power Pivot - Cil-y-coed Excel Training Courses
Mobile Cil-y-coed Training Courses
SSAS 2008 Cil-y-coed Training Courses
SSAS 2005 Cil-y-coed Training Courses