SQL SERVER REPORTING SERVICES TRAINING COURSES ABERDARE
About Enable Technology Aberdare SQL Server Reporting Services Training Courses
We offer intensive two and three days SQL Server Reporting Services courses. The tutor delivering the course will be 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.
Delegates are taught by an experienced Microsoft professional. SQL Server Reporting Services courses are delivered through a mix of practical hands on exercises and walk throughs. This SQL Server Reporting Services course is delivered online during the current Covid 19 restrictions Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen. We are happy to modify the SQL Server Reporting Services syllabus to match your teams training requirements.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Fujistu PLC, Birmingham Heartlands Hospital, GKN PLC, Keele University, Birmingham City Council, DHL Express, Carillion PLC and Yell Group PLC.
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Aberdare
- 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 ... Managing Objects in Object Explorer
- See Training Course Details...
Creating a Data Source View
Deploy Sample Reports to Report Server
Understanding Security Settings
General
Resizing
Navigation
Usability Features
Dynamic Parameter Values (From Query)
Managing Tables with the Table Properties Dialog
Reporting Services 2005 Deployment Options
Using Reporting Services 2005 Expressions
Reporting Services 2005 Security Model Concepts
Designing the Layout
History Properties
Understanding the Model Designer
Understanding Snapshots
Static Subscription
Creating a New Report Project
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Aberdare
- 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 ... Create a Shared Data Source and Two Data Sets
- See Training Course Details...
Field Collection
Using Unbound Parameters Understanding Report And Data Set Parameters
A Tour of the Report Builder Interface
Report Builder vs. Report Designer
Installing and Configuring Reporting Services Reporting Services Architecture
Globals Collection
Formatting Tablix Rows and Columns Making Reports Interactive
Using Parameters with Ad Hoc SQL
Using Charts in a Report
Building a Matrix Report
Report Project Types Working with Report Server Projects
Formatting a Chart Visualising Performance with Data Bars, Sparklines and Indicators
Create Shared Data Sources and Data Sets
Creating a Customer Contact List Creating Ad Hoc Reports With Report Builder
Create a Drop-Down List Parameter
Create a Form-Like Report from a list Calculations Using Expressions And Functions
Create a Tabular Report Using the Tablix Report Type
Preview Performance
No Data Rows
Creating a Columnar Report
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Aberdare
- 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...
Using Datasets Creating Paginated Reports
Use report services configuration manager to reconfigure SSRS servers.
Configuring data access with report builder
Extend reporting services functionality with external assemblies.
Drillthrough in mobile reports
Preparing data for mobile reports
Reporting services components
Report parameters
Creating a report with the report wizard
Mobile report publisher
Configuring data access with report designer
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Images and charts
Create a report using report builder or report designer.
Use databars, sparklines, and indicators in reports Summarising Report Data
Report caching, snapshots, and comments
Report subscription and delivery Administering Reporting Services
Formatting data
Publish a report to reporting services Working with Reporting Services Data
Reporting services tools Reporting Services Data Sources
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Aberdare
- 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 ... Advanced Reporting Services Programming
- See Training Course Details...
Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services
Find out how to create drill-down reports
Discover interactive sorting
Explore how to create expressions in your reports using
Working with Parameters
Security
Learn how to create a basic report using the SQL Server Reporting Services Wizard
Calculation and Formatting
Discover the many application programming interfaces of Reporting Services
Learn how to work with rich text to produce mail merge style reports
Managing Reporting Services
Find out how you can use conditional formatting to make your reports more dynamic
Investigate what SQL Server Reporting Services can do
Learn how to enable and control report caching
Explore the use of Reporting Services gauges
Explore creating linked reports
Find out how to display parameter values in report headers
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Aberdare
- 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 Lists
- See Training Course Details...
Using the List Object to Combine Other Items
SQL Server 2016 Report Builder Graphics
Exploring Matrix
Understanding Report Parts
Planning Your Reports
Working with Map Wizard
Exploring Subscriptions
Examining Maps
SQL Server 2016 Report Builder Basic Reports
Using Tables
Working with Datasets
Utilizing Charts
SQL Server 2016 Report Builder Advanced Reporting
Utilizing Chart Wizard
Utilizing Dynamic Headers and Footers
SQL Server 2016 Report Builder Wizards
Email us about this courses
Other Aberdare Enable Technology Training Courses
SSIS 2005 Aberdare Training Courses
JavaScript - Aberdare JavaScript Training Courses
Microsoft Project Level 3 - Aberdare Microsoft Project Training Courses
Access 2016 - Aberdare Access Training Courses
CSS - Aberdare Web Development Training Courses
Crystal 2011 - Aberdare Crystal Reports Training Courses
TSQL - Aberdare SQL Training Courses
VBA - Aberdare Excel Training Courses
Excel Power Pivot - Aberdare Excel Training Courses
Crystal 2013 Aberdare Training Courses
DAX - Aberdare Excel Training Courses
Excel Intermediate Aberdare Training Courses
Project 2016 - Aberdare Microsoft Project Training Courses
PowerPoint Advanced - Aberdare Office Training Courses
PL/SQL - Aberdare SQL Training Courses
Wales - Possible Sql Server Reporting Services Training Course Locations
Blackwood, Rhosllanerchrugog, Prestatyn, Ystrad Mynach, Gorseinon, Milford Haven, Mid Glamorgan, Wales, Bryn Pydew, Wrexham, Powys, Llandudno, Abergavenny, Llantwit Major, Carmarthen, Llanelli, Abertillery, Cardiff, Llanrumney, Monmouth, Bedwas, South Glamorgan, Clwyd, Splott, Caerphilly, Pontypridd, Rhyl, Bargoed, Aberdare, Flint, Bangor, Maesteg, Neath, Swansea, Treharris, Mountain Ash, Ammanford, Dyfed, Colwyn Bay, Pyle, Gwent, Porthcawl, Cil-y-coed, Llantrisant, Buckley, Tredegar, Holyhead, Risca, Merthyr Tydfil, Aberystwyth, Newport, West Glamorgan, Newtown, Bridgend, Cwmbran, Barry, Tonypandy, Mold, Haverfordwest, Gwynedd, Penarth