Enable Technology

SQL SERVER REPORTING SERVICES NATIONAL TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES NATIONAL




About Enable Technology National SQL Server Reporting Services Training Courses

We have a twenty year history of providing skills based SQL Server Reporting Services industry training. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given SQL Server Reporting Services courseware which they can refer to after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Reporting Services queries. This support is open ended.

Enable Technology training courses are delivered as instructor led courses. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Reporting Services onsite. Another way we could deliver the SQL Server Reporting Services course is at a local socially distanced training site. The SQL Server Reporting Services syllabus can be modified to accommodate your specific training needs.

This instructor led SQL Server Reporting Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are EDF Energy PLC, Lloyds TSB Bank PLC, Nuclear Engineering Services, Keele University, Royal & Sun Alliance Group PLC, Fujistu PLC, Canadian High Commission and Homeserve PLC.




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 ...
  • Discover how to add textboxes and other controls to reports 
    Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box 
    Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server 
    Learn how to deploy Reporting Services projects and individual reports and data sources 
    Dig into the use of unbound, multivalued, and cascading parameters 
    Discover the various global collections that you can reference in your expressions 
    Ad-Hoc Reporting with Report Builder 2.0
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Learn how to enable and control report caching 
    Explore the storing of credentials within a data source 
    Understand how to plan and configure for deployment 
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 
    Advanced Reporting Services Programming
    Investigate how to manage Reporting Services projects using Report Manager 
    Explore the maintenance of report history 
    Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Investigate Reporting Services charts 
    Discover interactive sorting 

  • See Training Course Details...


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 Dynamic Headers and Footers
    Exploring the Report Builder Interface
    Examining Management
    Working with Datasets
    Using Tables
    SQL Server 2016 Report Builder Wizards
    Exploring Matrix
    Exploring Gauges
    Understanding Variances Between SQL Versions
    Working with Map Wizard
    Understanding HTML5 and Textboxes
    Utilizing Data Sources
    SQL Server 2016 Report Builder Basic Reports
    Filtering, Grouping, and Sorting
    Formatting Reports
    Exploring Subscriptions
    Examining Maps
    Understanding Report Parts
    Creating Subreports and Drillthrough Reports

  • See Training Course Details...


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 ...
  • Preparing data for mobile reports
    Implementing report filters and parameters Visualizsng Data with Report Services
    Report parameters
    Drilldown and drill through Sharing Reporting Services Reports
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Configuring data access with report designer
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Schedules
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Data filters
    Extend reporting services functionality with external assemblies.
    Images and charts
    Creating a report with the report wizard
    Publish a report to reporting services Working with Reporting Services Data
    Use report services configuration manager to reconfigure SSRS servers.
    Report subscription and delivery Administering Reporting Services
    Overview of mobile reports
    Reporting services components
    Topics include Introduction to Reporting Services
    Configuring data access with report builder
    Secure access to reports by using authentication, permissions, and SSL encryption.

  • See Training Course Details...


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 ...
  • Report Design Options
    Auditing and Management Reports
    Entity and Field Folders
    Managing Objects in Object Explorer
    Building a Matrix (Cross-tab) Report
    The Reporting Services 2005 Key Components
    Adding Reporting Services 2005 Users
    Included Reporting Services 2005 Extensions
    Quick Formatting using Toolbar and Menu Options
    Adding Groups to Reporting Services
    Execution Properties
    Modifying the Data Source View
    Tools for Managing Reports
    Drawing Lines and Rectangles
    Table Data Region Record Sorting
    Using the Reporting Services Configuration Manager
    Identifying Field
    Grouping Data
    Deploying a Report Model
    Data Output

  • See Training Course Details...


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 ...
  • Create a Tabular Report  Using the Tablix Report Type
    Report Designer and Data Windows Configuring Report Projects
    Sparkline
    Overview
    Create a Report with Interactive Sorting Dynamic Reports with Parameters
    Introduction to SQL Server Reporting Services
    Working with Maps and Spatial Data  Enhancing Reports with Data Visualisation
    Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
    Create a Shared Data Source and Two Data Sets
    Create Shared Data Sources and Data Sets
    Providing a Drop-Down List for a Report Parameter
    Installing and Configuring Reporting Services Reporting Services Architecture
    Building a Tabular Report
    The Tablix Properties Dialogue Box
    Rein in the Length of a Text Field
    Report Definition Language (RDL)
    The Global Collections
    Preview Performance
    Null Handling
    Installing SQL Server Data Tools

  • See Training Course Details...



Email us about this courses



Other National Enable Technology Training Courses

SSIS 2008 National Training Courses
JQuery Mobile - National JavaScript Training Courses
SSIS 2014 National Training Courses
Power Query - National Excel Training Courses
SSAS 2014 National Training Courses
SSAS 2008 National Training Courses
CSS National Training Courses
Data Mining National Training Courses
Microsoft Project Level 3 National Training Courses
Excel Intermediate National Training Courses
SSAS Tabular - National SQL Server Analysis Services Training Courses
Project 2016 - National Microsoft Project Training Courses
SSAS 2005 - National SQL Server Analysis Services Training Courses
PowerPoint Basic National Training Courses
Crystal XI National Training Courses