SQL SERVER REPORTING SERVICES TRAINING COURSES THORNTON-CLEVELEYS
About Enable Technology Thornton-cleveleys SQL Server Reporting Services Training Courses
We are a company that provides short intensive SQL Server Reporting Services training courses. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive SQL Server Reporting Services training materials and practice files which are theirs to refer to 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.
SQL Server Reporting Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver SQL Server Reporting Services courses onsite at your offices. You simply need to provide a suitable room. Another way we could deliver the SQL Server Reporting Services course is at a local socially distanced training site. We are happy to modify the SQL Server Reporting Services syllabus to match your teams training requirements.
We can also deliver SQL Server Reporting Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Unipart Group, Homeserve PLC, Aston University, Fujistu PLC, Lloyds TSB Bank PLC, Canadian High Commission, Norwich Union PLC and Carillion PLC.
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Thornton-cleveleys
- 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 ... Create a Database for Report Execution Data
- See Training Course Details...
Entities
Understanding the Model Designer
Fields tab
Create a Dataset
Formatting Textboxes with the Textbox Properties Dialog
Adding Groups and Users
Managing Objects in Object Explorer
Quick Formatting using Toolbar and Menu Options
Explorer Pane
Introduction to Reporting Services 2005
The Main Components of the Design Environment
Design the Query Dialog
General
Creating a Data Source View
Drawing Lines and Rectangles
Model Statistics
SQL Server 2005 Reporting Services Features
Data-driven Subscription
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Thornton-cleveleys
- 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 format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box
- See Training Course Details...
Learn how to calculate group totals and percentages
Learn how to create matrix reports
Explore the basic architecture of SQL Server Reporting Services
Explore the potential deployment and security issues that might arise when working with custom assemblies
Find out how you can use conditional formatting to make your reports more dynamic
Investigate the scheduling of report snapshots
Explore creating groups
Discover interactive sorting
Explore the storing of credentials within a data source
Learn about report variables and when you might need to use them
Learn how to create custom functions using the Code window
Discover the classes and methods exposed by the Reporting Services Web Service API
Discover the various global collections that you can reference in your expressions
Snapshots and Subscriptions
Dig into the use of unbound, multivalued, and cascading parameters
Investigate how to call a custom assembly from a report
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Thornton-cleveleys
- 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 ... Schedules
- See Training Course Details...
Preparing data for mobile reports
Mobile report publisher
Introduction to reporting services
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Creating a report with the report wizard
Extend reporting services functionality with external assemblies.
Overview of mobile reports
Use report services configuration manager to reconfigure SSRS servers.
Formatting data
Data filters
Using Datasets Creating Paginated Reports
Reporting services components
Secure access to reports by using authentication, permissions, and SSL encryption.
Add a drillthrough to a custom URL
Use databars, sparklines, and indicators in reports Summarising Report Data
Drillthrough in mobile reports
Sorting and grouping
Report caching, snapshots, and comments
Work with expressions and embedded code.
Configuring data access with report designer
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Thornton-cleveleys
- 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 ... Creating a Customer Contact List Creating Ad Hoc Reports With Report Builder
- See Training Course Details...
The Tablix Properties Dialogue Box
Considering Report Layout Options
Report Project Types Working with Report Server Projects
No Data Rows
Using Charts in a Report
Using Report Parts Shared Data Sets
Create a Tabular Report Using the Tablix Report Type
Providing a Drop-Down List for a Report Parameter
Parameters and Stored Procedures
Data Bars
Synchronized Data Alignment Using the Tablix Report Type
Create a Custom Function Managing Page Layout and Adding Interactivity
Shared Dataset Design View Creating Ad Hoc Reports with Report Builder
Create a Pie Chart with Point Labels
Formatting a Chart Visualising Performance with Data Bars, Sparklines and Indicators
Report Project Configurations Creating a New Report in the Report Designer
Reporting Services Modes
Introduction to Report Builder
Work with Multivalued Parameters Enhancing Reports with Data Visualisations
Page Headers and Footers Report Formatting Options
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Thornton-cleveleys
- 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 Security
Utilizing Dynamic Headers and Footers
SQL Server 2016 Report Builder Basic Reports
Planning Your Reports
Introduction to SQL Server 2016 Report Builder
SQL Server 2016 Report Builder Graphics
Examining Management
Working with Expressions
Understanding Visualizations
Using Tables
SQL Server 2016 Report Builder Wizards
Exploring Gauges
Examining Maps
Working with Datasets
Creating Subreports and Drillthrough Reports
SQL Server 2016 Report Builder Advanced Reporting
Understanding HTML5 and Textboxes
Understanding Report Parts
Email us about this courses
Other Thornton-cleveleys Enable Technology Training Courses
Project 2016 - Thornton-cleveleys Microsoft Project Training Courses
CSS - Thornton-cleveleys Web Development Training Courses
SSAS 2014 Thornton-cleveleys Training Courses
SSIS 2005 Thornton-cleveleys Training Courses
Microsoft Project Level 3 Thornton-cleveleys Training Courses
SSIS 2008 Thornton-cleveleys Training Courses
Oracle BI Thornton-cleveleys Training Courses
PowerPoint Basic - Thornton-cleveleys Office Training Courses
Access VBA Thornton-cleveleys Training Courses
Excel Intermediate - Thornton-cleveleys Excel Training Courses
Crystal XI Thornton-cleveleys Training Courses
SSAS 2008 - Thornton-cleveleys SQL Server Analysis Services Training Courses
PHP - Thornton-cleveleys PHP Training Courses
HTML - Thornton-cleveleys Web Development Training Courses
Crystal 2013 Thornton-cleveleys Training Courses