SQL SERVER REPORTING SERVICES TRAINING COURSES NATIONAL
About Enable Technology National SQL Server Reporting Services Training Courses
Enable Technology provides practical SQL Server Reporting Services skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training SQL Server Reporting Services resources which they can continue to use after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Reporting Services for as long as they need.
Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver SQL Server Reporting Services courses at your site. Alternatively we could schedule a course at a local socially distanced venue in National. Every SQL Server Reporting Services course can be modified to meet your bespoke requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Reporting Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Royal & Sun Alliance Group PLC, National Power PLC, Norfolk Police Constabulary, Wolverhampton City Council, Carillion PLC, Unipart Group, University of Birmingham and Total Telecommunications Limited.
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 ... Providing a Drop-Down List for a Report Parameter
- See Training Course Details...
Tablix Cell Content and Scope Building a Tablix Report
Built-in Functions
Using Parameters with Ad Hoc SQL
Designing the Page Layout
Creating a Columnar Report
Displaying the Parameter Value and Label for a Drop-Down List Parameter
Report Builder Installation and Execution Options
Introducing SQL Server Data Tools
Data Bars
Data Set Parameters
Page Headers and Footers Report Formatting Options
Reporting Services Modes
Reordering Report Parameters Using Drop-Down List Parameters
Field Collection
Using Unbound Parameters Understanding Report And Data Set Parameters
Multivalued Parameters Dynamic Reports with Parameters
Building a List Report Configuring Tablix Properties and Groups
Introduction to SQL Server Reporting Services
Considering Report Layout Options
Create a Parameterised Report
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 ... Utilizing Data Sources
- See Training Course Details...
SQL Server 2016 Report Builder Basic Reports
Exploring Matrix
Working with Map Wizard
Utilizing Lists
Understanding Variances Between SQL Versions
Understanding Visualizations
Using Tables
SQL Server 2016 Report Builder Graphics
Utilizing Chart Wizard
Examining Management
Introduction to SQL Server 2016 Report Builder
Exploring Subscriptions
Planning Your Reports
Examining Security
Working with Datasets
Exploring the Report Builder Interface
Exploring Table or Matrix Wizard
Using the List Object to Combine Other Items
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 ... Investigate Reporting Services charts
- See Training Course Details...
Creating Matrix Reports and Charts
Explore the maintenance of report history
Discover how to improve parameter prompts using drop-down list parameters
Learn how to solve common parameter issues
Find out how to create drill-down reports
Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services
Ad-Hoc Reporting with Report Builder 2.0
Discover the many application programming interfaces of Reporting Services
Learn about report variables and when you might need to use them
Managing Reporting Services
Investigate how Reporting Services secures access to reports and other Reporting Services resources
Learn how to enable basic authentication for reports and how to require SSL for report operations
Learn how to work with rich text to produce mail merge style reports
Grouping and Sorting
Learn how to calculate group totals and percentages
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 ... Report subscription and delivery Administering Reporting Services
- See Training Course Details...
Use databars, sparklines, and indicators in reports Summarising Report Data
Data filters
Configuring data access with report builder
Implementing report filters and parameters Visualizsng Data with Report Services
Creating a report with the report wizard
Drillthrough in mobile reports
Formatting data
Reporting services components
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Secure access to reports by using authentication, permissions, and SSL encryption.
Preparing data for mobile reports
Introduction to reporting services
Work with expressions and embedded code.
Sorting and grouping
Using Datasets Creating Paginated Reports
Report caching, snapshots, and comments
Report parameters
Overview of mobile reports
Configuring data access with report designer
Images and charts
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 ... Filters
- See Training Course Details...
Previewing Reporting Services 2005 Reports
Parts of the Chart
Understanding Reporting Services 2005 Subscriptions
Managing Parameters
Adding Textboxes
Reporting Services 2005 Client Components
Deploy Sample Reports to Report Server
Creating a Report Model Data Source
Displaying Parameters in a Report
Data Output
Report Filters
Creating a Report Model File
Deploying a Report Model
Designing the Layout
Included Reporting Services 2005 Extensions
Creating a Subscription
Diagram Organizer Pane
Report Formatting Toolbar
Email us about this courses
Other National Enable Technology Training Courses
Microsoft Project Level 2 - National Microsoft Project Training Courses
JQuery - National JavaScript Training Courses
Visio 2013 - National Visio Training Courses
Excel Intermediate - National Excel Training Courses
Oracle BI - National Data Analytics Training Courses
Power Query - National Excel Training Courses
Excel Power Pivot - National Excel Training Courses
SSAS 2005 - National SQL Server Analysis Services Training Courses
Data Mining National Training Courses
SSAS 2017 National Training Courses
Crystal XI National Training Courses
HTML National Training Courses
JavaScript National Training Courses
Oracle SQL National Training Courses
PHP - National PHP Training Courses