SQL SERVER REPORTING SERVICES TRAINING COURSES PONTYPRIDD
About Enable Technology Pontypridd SQL Server Reporting Services Training Courses
We are a company that provides short intensive SQL Server Reporting Services training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Everyone attending a SQL Server Reporting Services course receives learning resources which also serves as a reference source after the course. We also provide an ongoing support service to people attending our SQL Server Reporting Services courses. Delegates can contact the course tutor with specific SQL Server Reporting Services questions for as long as they need following the course.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. During the Covid 19 period we are delivering 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. We are happy to modify the SQL Server Reporting Services syllabus to match your teams training requirements.
We have operated primarily in the West Midlands for twenty years. Some of our clients are University of Birmingham, Birmingham City Council, Royal Air Force, Lloyds TSB Bank PLC, TalkTalk Direct Limited, West Bromwich Building Society, Countrywide Homes Limited and Vodafone Group Services.
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Pontypridd
- 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 ... Report Builder Installation and Execution Options
- See Training Course Details...
Overview
Creating a Customer Contact List Creating Ad Hoc Reports With Report Builder
No Data Rows
Create a Shared Data Source and Two Data Sets
Service Architecture Report Building Tools
Installing SQL Server Data Tools
Built-in Functions
Formatting Text Boxes in the Properties Window
Report Builder vs. Report Designer
Create a Data Source Connection
Parameters and Stored Procedures
Create a Pie Chart with Point Labels
Synchronized Data Alignment Using the Tablix Report Type
Sparkline
Page Structure Properties
Formatting Text Boxes in the Text Box Properties Dialogue Box
Create a Map Report
Providing a Drop-Down List for a Report Parameter
Create a Form-Like Report from a list Calculations Using Expressions And Functions
Displaying the Parameter Value and Label for a Drop-Down List Parameter
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Pontypridd
- 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 ... Discover how to create standard report subscriptions
- See Training Course Details...
Investigate the list data region
Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box
Creating Tabular and List Reports
Learn how to create data-driven report subscriptions
Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place
Master the Reporting Services Grouping pane
Learn how to create parameters in ad-hoc SQL
Grouping and Sorting
Explore the storing of credentials within a data source
Snapshots and Subscriptions
Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server
Learn how to calculate group totals and percentages
Explore creating linked reports
Discover how to improve parameter prompts using drop-down list parameters
Learn how to use URL to integrate Reporting Services reports into your applications
Discover the many application programming interfaces of Reporting Services
Discover the various global collections that you can reference in your expressions
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Pontypridd
- 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 ... Formatting data
- See Training Course Details...
Report caching, snapshots, and comments
Implementing report filters and parameters Visualizsng Data with Report Services
Preparing data for mobile reports
Create a report using report builder or report designer.
Using Datasets Creating Paginated Reports
Configuring data access with report designer
Schedules
Extend reporting services functionality with external assemblies.
Configuring data access with report builder
Secure access to reports by using authentication, permissions, and SSL encryption.
Overview of mobile reports
Publish a report to reporting services Working with Reporting Services Data
Drilldown and drill through Sharing Reporting Services Reports
Sorting and grouping
Add a drillthrough to a custom URL
Images and charts
Reporting services tools Reporting Services Data Sources
Use databars, sparklines, and indicators in reports Summarising Report Data
Report sub-reports
Report parameters
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Pontypridd
- 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 ... Dynamic Parameter Values (From Query)
- See Training Course Details...
The Reporting Services 2005 Report Wizard
Building Report Models in Reporting Services 2005
Current Classroom Folder Structure
Add Report Parameter to a Dataset
Creating a New Report Project
Understanding Reporting Services 2005 Subscriptions
Adding Data Fields to a Table Data Region
Filters
Report Borders Toolbar
Saving a Report
Server Management Reports
Create a Reporting Services 2005 Report Query
The Toolbox
Managing Parameters
Table Data Region Record Sorting
Reporting Services 2005 Query vs. Report Parameters
Adding Groups and Users
Reporting Services 2005 Distribution Options
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Pontypridd
- 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 ... Planning Your Reports
- See Training Course Details...
Using Tables
Working with Datasets
Using the List Object to Combine Other Items
Utilizing Chart Wizard
Mastering Data Region(s)
Exploring Matrix
Creating Subreports and Drillthrough Reports
Working with Expressions
Examining Security
Understanding Report Parts
SQL Server 2016 Report Builder Wizards
Examining Management
Formatting Reports
Introduction to SQL Server 2016 Report Builder
Examining Parameters
Examining Maps
Exploring Table or Matrix Wizard
Email us about this courses
Other Pontypridd Enable Technology Training Courses
Power Query Pontypridd Training Courses
Microsoft Project Level 2 - Pontypridd Microsoft Project Training Courses
DAX - Pontypridd Excel Training Courses
HTML Pontypridd Training Courses
HTML - Pontypridd Web Development Training Courses
SSAS 2017 - Pontypridd SQL Server Analysis Services Training Courses
Crystal 2013 Pontypridd Training Courses
Mobile Pontypridd Training Courses
JavaScript - Pontypridd JavaScript Training Courses
Oracle BI - Pontypridd Data Analytics Training Courses
TSQL Pontypridd Training Courses
Crystal 2016 - Pontypridd Crystal Reports Training Courses
CSS - Pontypridd Web Development Training Courses
Excel Power Pivot Pontypridd Training Courses
SQL Pontypridd Training Courses
Wales - Possible Sql Server Reporting Services Training Course Locations
Gorseinon, South Glamorgan, Milford Haven, Pyle, Aberdare, Gwent, Llantwit Major, Aberystwyth, Bryn Pydew, Clwyd, Merthyr Tydfil, Powys, Mountain Ash, Pontypridd, Haverfordwest, Ystrad Mynach, West Glamorgan, Llanrumney, Abertillery, Buckley, Cil-y-coed, Gwynedd, Blackwood, Holyhead, Bedwas, Tredegar, Splott, Penarth, Llantrisant, Cardiff, Colwyn Bay, Monmouth, Carmarthen, Porthcawl, Newport, Llanelli, Bangor, Abergavenny, Ammanford, Wales, Cwmbran, Newtown, Prestatyn, Flint, Bridgend, Bargoed, Rhosllanerchrugog, Treharris, Mold, Barry, Llandudno, Neath, Maesteg, Mid Glamorgan, Dyfed, Caerphilly, Tonypandy, Rhyl, Risca, Wrexham, Swansea