Enable Technology

SQL SERVER REPORTING SERVICES PONTYPRIDD TRAINING COURSES 

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
    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

  • See Training Course Details...


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 
    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 

  • See Training Course Details...


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
    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

  • See Training Course Details...


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)
    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

  • See Training Course Details...


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
    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

  • See Training Course Details...



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