Enable Technology

SQL SERVER REPORTING SERVICES CIL-Y-COED TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES CIL-Y-COED




About Enable Technology Cil-y-coed SQL Server Reporting Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Reporting Services technology training courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a SQL Server Reporting Services course receives learning resources which also serves as a reference source after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology training courses are delivered as instructor led courses. We can bring the equipment necessary to deliver SQL Server Reporting Services courses at your site. If delivery onsite is an issue we will organise a socially distanced venue near you in Cil-y-coed. Every SQL Server Reporting Services course can be modified to meet your bespoke requirements.

Taught SQL Server Reporting Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are EDF Energy PLC, Boots UK Limited, Nuclear Engineering Services, Shell UK Oil Products Ltd, Fujistu PLC, Canadian High Commission, West Bromwich Building Society and National Power PLC.




SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Cil-y-coed
  • 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 ...
  • Overview
    User Collection
    Designing the Page Layout
    Report Builder vs. Report Designer
    Data Set Parameters
    Data Bars
    Create and Configure a Report Server Project
    Preview Performance
    Creating a Shared Data Source and Data Sets
    Formatting Text Boxes from the Toolbars
    Report Project Configurations  Creating a New Report in the Report Designer
    Exploring the Tablix Report Type
    Providing a Drop-Down List for a Report Parameter
    Work with Multivalued Parameters  Enhancing Reports with Data Visualisations
    Native Mode Architecture
    Synchronized Data Alignment  Using the Tablix Report Type
    Shared Data Sources
    Writing and Using Report Expressions
    The Global Collections
    Formatting Tablix Rows and Columns Making Reports Interactive

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Cil-y-coed
  • 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 the differences between Report Builder 1.0 and Report Builder 2.0 
    Learn how to create data-driven report subscriptions 
    Find out how you can use conditional formatting to make your reports more dynamic 
    Learn about report variables and when you might need to use them 
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 
    Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Explore the basic architecture of SQL Server Reporting Services 
    Learn how to enable and control report caching 
    Learn about datasets and data regions 
    Learn how to enable basic authentication for reports and how to require SSL for report operations 
    Explore creating groups 
    Understand how to plan and configure for deployment 
    Learn how to create parameters in ad-hoc SQL 
    Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place 
    Gain a basic understanding of the components behind SQL Server Reporting Services 
    Snapshots and Subscriptions
    Explore the use of Reporting Services gauges 
    Explore the storing of credentials within a data source 
    Discover how to add textboxes and other controls to reports 
    Learn how to call the Report Server Web Service 
    Learn how to work with rich text to produce mail merge style reports 

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Cil-y-coed
  • 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 ...
  • Adding Data Fields to a Table Data Region
    Formatting
    Reporting Services 2005 Client Components
    Completing the Wizard Dialog
    Visibility
    Sorting
    Report Groupings
    Creating a Subscription
    The Reporting Services 2005 Layout View
    Visual Studio 2005 and Development Studio
    Building a Table Report
    Deploying the Auditing and Management Reports
    Model Statistics
    Reporting Services 2005 Security
    Web Folder Properties
    Reporting Services 2005 Menus
    Designing the Layout
    Creating Formulas
    Grouping Data
    Report Builder Design Layout
    Starting SQL Server Business Intelligence Development Studio

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Cil-y-coed
  • 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 ...
  • Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Preparing data for mobile reports
    Introduction to reporting services
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Configuring data access with report builder
    Using Datasets Creating Paginated Reports
    Sorting and grouping
    Schedules
    Images and charts
    Configuring data access with report designer
    Databars, sparklines, indicators, gauges, and maps
    Reporting services tools Reporting Services Data Sources
    Data filters
    Formatting data
    Extend reporting services functionality with external assemblies.
    Overview of mobile reports
    Drilldown and drill through Sharing Reporting Services Reports
    Implementing report filters and parameters Visualizsng Data with Report Services
    Use report services configuration manager to reconfigure SSRS servers.
    Mobile report publisher
    Report subscription and delivery Administering Reporting Services

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Cil-y-coed
  • 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 the Report Builder Interface
    Visualizing Your Company Report Templates
    Examining Parameters
    Understanding Variances Between SQL Versions
    Working with Datasets
    Mastering Data Region(s)
    SQL Server 2016 Report Builder Graphics
    Creating Subreports and Drillthrough Reports
    Formatting Reports
    Introduction to SQL Server 2016 Report Builder
    Exploring Gauges
    SQL Server 2016 Report Builder Basic Reports
    Exploring Subscriptions
    Exploring Matrix
    Examining Maps
    SQL Server 2016 Report Builder Wizards
    Using the List Object to Combine Other Items

  • See Training Course Details...



Email us about this courses



Other Cil-y-coed Enable Technology Training Courses

Power BI - Cil-y-coed Microsoft Power BI Training Courses
CSS - Cil-y-coed Web Development Training Courses
Power Query - Cil-y-coed Excel Training Courses
HTML - Cil-y-coed Web Development Training Courses
Excel Intermediate - Cil-y-coed Excel Training Courses
PL/SQL - Cil-y-coed SQL Training Courses
SQL Cil-y-coed Training Courses
SSIS 2014 - Cil-y-coed SQL Server Integration Services Training Courses
Excel Basic Cil-y-coed Training Courses
Crystal 2016 Cil-y-coed Training Courses
JQuery Mobile Cil-y-coed Training Courses
Excel Power Pivot - Cil-y-coed Excel Training Courses
Mobile Cil-y-coed Training Courses
SSAS 2008 Cil-y-coed Training Courses
SSAS 2005 Cil-y-coed Training Courses