Enable Technology

SQL SERVER REPORTING SERVICES SHEFFIELD TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES SHEFFIELD




About Enable Technology Sheffield SQL Server Reporting Services Training Courses

Enable Technology has twenty year track record of providing short intensive SQL Server Reporting Services skills based training courses. All Enable Technology tutors are Microsoft certified experts. Everyone attending a SQL Server Reporting Services course receives learning resources which also serves as a reference source after the course. If delegates have have questions about SQL Server Reporting Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Courses are instructor led and groups sizes small. We are delivering this instructor led SQL Server Reporting Services training online during the current crisis. Participants can se the tutors screen, ask questions and share their screen with the tutor. The SQL Server Reporting Services syllabus can be modified to accommodate your specific training needs.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are University of Birmingham, Yell Group PLC, Capita Group PLC, TalkTalk Direct Limited, Aston University, Halfords Group PLC, Dollond & Aitchison Limited and Wolverhampton City Council.




SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Sheffield
  • 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 ...
  • Web Folder Properties
    Changing Columns and Rows
    Chart Options
    Deploy Sample Reports to Report Server
    Run the Sample Reports
    Linked Reports
    Completing the Wizard Dialog
    Clickthrough Reports
    Understanding Reporting Services 2005 Caching
    Adding or Deleting
    Understanding Reporting Services 2005 Subscriptions
    Formatting Reporting Services 2005 Reports
    Add Report Parameter to a Dataset
    Tables Pane
    Reporting Services 2005 Administration
    Explorer Pane
    Default Folder Structure
    Reporting Services 2005 Query vs. Report Parameters

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Sheffield
  • 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
    Using Tables
    Examining Management
    Understanding Visualizations
    Exploring Matrix
    Exploring Subscriptions
    Working with Map Wizard
    Utilizing Lists
    Working with Datasets
    SQL Server 2016 Report Builder Advanced Reporting
    Exploring the Report Builder Interface
    Understanding Report Parts
    Examining Parameters
    Utilizing Charts
    Working with Expressions
    Exploring Table or Matrix Wizard
    Visualizing Your Company Report Templates

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Sheffield
  • 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 ...
  • Introduction to reporting services
    Add a drillthrough to a custom URL
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Drilldown and drill through Sharing Reporting Services Reports
    Reporting services components
    Publish a report to reporting services Working with Reporting Services Data
    Configuring data access with report builder
    Implementing report filters and parameters Visualizsng Data with Report Services
    Mobile report publisher
    Report sub-reports
    Use report services configuration manager to reconfigure SSRS servers.
    Using Datasets Creating Paginated Reports
    Sorting and grouping
    Schedules
    Report caching, snapshots, and comments
    Databars, sparklines, indicators, gauges, and maps
    Extend reporting services functionality with external assemblies.
    Formatting data
    Images and charts
    Reporting services tools Reporting Services Data Sources
    Preparing data for mobile reports

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Sheffield
  • 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 the many application programming interfaces of Reporting Services 
    Security
    Discover the classes and methods exposed by the Reporting Services Web Service API 
    Find out how to display parameter values in report headers 
    Discover how to improve parameter prompts using drop-down list parameters 
    Find out how to create drill-down reports 
    Explore how to use Report Builder to build ad-hoc tabular, matrix and chart reports Discover how to create Report Builder reports without using the wizards 
    Snapshots and Subscriptions
    Learn the differences between Report Builder 1.0 and Report Builder 2.0 
    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 matrix reports 
    Explore the use of Reporting Services gauges 
    Discover how to add textboxes and other controls to reports 
    Investigate what SQL Server Reporting Services can do 
    Learn how to enable and control report caching 
    Learn how to create a basic report using the SQL Server Reporting Services Wizard 
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Discover the various global collections that you can reference in your expressions 
    Learn how to create custom functions using the Code window 

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Sheffield
  • 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 ...
  • Building a Matrix Report
    Create a Report Based on a Shared Data Set  Creating Reports With  SQL Server Data Tools
    Interactive Sorting
    Overview
    Building a Report with Report Builder
    Create A Shared DataSet for Northwind
    Data Set Parameters
    Built-in Functions
    Cascading Parameters
    Installing and Configuring Reporting Services Reporting Services Architecture
    Building a Tabular Report
    Using the Expression Editor  Using Built-in Report Operators and Functions
    Using Charts in a Report
    Introducing SQL Server Data Tools
    Writing and Using Report Expressions
    Report Items Collection
    Create a Custom Function  Managing Page Layout and Adding Interactivity
    Drilldown Reports Managing Page Layout and Adding Interactivity
    Parameters and Stored Procedures
    Data Bars
    Expression Operators

  • See Training Course Details...



Email us about this courses



Other Sheffield Enable Technology Training Courses

SSAS Tabular - Sheffield SQL Server Analysis Services Training Courses
PowerPoint Basic Sheffield Training Courses
Power Graphics Sheffield Training Courses
Access 2016 - Sheffield Access Training Courses
TSQL Sheffield Training Courses
Visio 2013 Sheffield Training Courses
PowerPoint Advanced Sheffield Training Courses
Microsoft Project Level 2 Sheffield Training Courses
SSIS 2005 Sheffield Training Courses
SSIS 2014 - Sheffield SQL Server Integration Services Training Courses
Access VBA - Sheffield Access Training Courses
SSIS 2008 Sheffield Training Courses
PHP - Sheffield PHP Training Courses
Crystal 2016 - Sheffield Crystal Reports Training Courses
CSS Sheffield Training Courses



North - Possible Sql Server Reporting Services Training Course Locations


Durham, Yorkshire, Scarborough, Middlesbrough, Batley, Hartlepool, Scunthorpe, Grimsby, Hexham, Dewsbury, Sheffield, Leeds, Harrogate, Halifax, Barnsley, North East, Keighley, Pudsey, York, Wakefield, South Shields, Newcastle Upon Tyne, Gateshead, Wetherby, Sunderland, Huddersfield, Castleford, Bridlington, Normanton, Rotherham, Doncaster