Enable Technology

SQL SERVER REPORTING SERVICES UTTOXETER TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES UTTOXETER




About Enable Technology Uttoxeter SQL Server Reporting Services Training Courses

We offer intensive two and three days SQL Server Reporting Services courses. The training will be delivered by a Microsoft professional with development experience. Every course participant will receives course practice files and SQL Server Reporting Services course resources that can be referenced post training. 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.

We provide instructor led training coupled with hands on training. During the current lockdown this course is delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Reporting Services course, watch the tutor demonstrate tasks, ask questions and share their own screen. Every SQL Server Reporting Services course can me modified to meet your bespoke requirements.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Capita Group PLC, TalkTalk Direct Limited, Loughborough University, Fujistu PLC, Halfords Group PLC, DHL Express, Queen's Medical Centre Nottingham and EDF Energy PLC.




SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Uttoxeter
  • 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 ...
  • Formatting
    Add Report Parameter to a Dataset
    Accessing Reports via the Report Manager
    Reporting Services 2005 Security
    Completing the Wizard Dialog
    Clickthrough Reports
    Saving a Report
    Design Area
    Explorer Pane
    Visual Studio 2005 and Development Studio
    Designing the Layout
    Building a Matrix (Cross-tab) Report
    Understanding System-level Roles
    Report Filters
    Creating a Data Source View
    Reporting Services 2005 Data Options
    Grouping Data
    Navigation
    Create a Reporting Services 2005 Report Query

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Uttoxeter
  • 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 ...
  • Understanding Visualizations
    Filtering, Grouping, and Sorting
    Exploring Subscriptions
    Examining Security
    Working with Expressions
    Formatting Reports
    Understanding Variances Between SQL Versions
    Utilizing Dynamic Headers and Footers
    Using the List Object to Combine Other Items
    Understanding HTML5 and Textboxes
    Exploring Gauges
    Exploring the Report Builder Interface
    SQL Server 2016 Report Builder Graphics
    Mastering Data Region(s)
    Exploring Table or Matrix Wizard
    SQL Server 2016 Report Builder Basic Reports
    Utilizing Lists

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Uttoxeter
  • 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 ...
  • Creating a Columnar Report
    Create A Shared DataSet for Northwind
    Preview Performance
    Building a List Report Configuring Tablix  Properties and Groups
    Building a Matrix Report
    Data Set Parameters
    The Tablix Properties Dialogue Box
    Create a  Parameterised Report
    Data Bars
    Drilldown Reports Managing Page Layout and Adding Interactivity
    The Global Collections
    Designing the Page Layout
    Displaying the Parameter Value and Label for a Drop-Down List Parameter
    Report Builder Installation and Execution Options
    Report Project Files and Folders
    Tablix Cell Content and Scope Building a Tablix Report
    Using the Expression Editor  Using Built-in Report Operators and Functions
    Create a Form-Like Report from a list Calculations Using Expressions And Functions
    Indicators
    Service Architecture  Report Building Tools

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Uttoxeter
  • 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 ...
  • Create a report using report builder or report designer.
    Topics include Introduction to Reporting Services
    Implementing report filters and parameters Visualizsng Data with Report Services
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Databars, sparklines, indicators, gauges, and maps
    Reporting services components
    Mobile report publisher
    Data filters
    Publish a report to reporting services Working with Reporting Services Data
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Creating a report with the report wizard
    Configuring data access with report builder
    Report caching, snapshots, and comments
    Work with expressions and embedded code.
    Using Datasets Creating Paginated Reports
    Report parameters
    Sorting and grouping
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Report subscription and delivery Administering Reporting Services
    Add a drillthrough to a custom URL
    Report sub-reports

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Uttoxeter
  • 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 how to create custom functions using the Code window 
    Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place 
    Understand how to plan and configure for deployment 
    Find out how you can use conditional formatting to make your reports more dynamic 
    Find out how to create drill-down reports 
    Learn how to use URL to integrate Reporting Services reports into your applications 
    Investigate how to call a custom assembly from a report 
    Learn how to create parameters in ad-hoc SQL 
    Snapshots and Subscriptions
    Discover how to add textboxes and other controls to reports 
    Explore creating linked reports 
    Learn how to create matrix reports 
    Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Advanced Reporting Services Programming
    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 
    Investigate the scheduling of report snapshots 
    Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services 
    Introducing SQL Server Reporting Services
    Learn how to calculate group totals and percentages 

  • See Training Course Details...



Email us about this courses



Other Uttoxeter Enable Technology Training Courses

Crystal 2016 Uttoxeter Training Courses
HTML - Uttoxeter Web Development Training Courses
Excel Intermediate - Uttoxeter Excel Training Courses
Excel Power Pivot Uttoxeter Training Courses
Project 2016 L1 - Uttoxeter Microsoft Project Training Courses
SQL Uttoxeter Training Courses
Crystal XI - Uttoxeter Crystal Reports Training Courses
Project 2016 - Uttoxeter Microsoft Project Training Courses
Access VBA Uttoxeter Training Courses
Oracle BI Uttoxeter Training Courses
SSAS 2017 Uttoxeter Training Courses
Access 2016 Uttoxeter Training Courses
Excel Basic - Uttoxeter Excel Training Courses
Mobile - Uttoxeter Web Development Training Courses
Microsoft Project Level 3 Uttoxeter Training Courses



Midlands - Possible Sql Server Reporting Services Training Course Locations


Stoke On Trent, Shropshire, Nottingham, West Bromwich, Smethwick, Warwickshire, Cheltenham, Oswestry, Oxford, Rugeley, Leek, Rowley, Burton On Trent, Atherstone, Herefordshire, Derby, Tipton, Staffordshire, Chester, Stratford Upon Avon, Cannock, Evesham, Stafford, Leamington Spa, Coventry, Kenilworth, Birmingham, Northhampton, Worcestershire, Malvern, Midlands, Bedworth, East Midlands, Sandwell, Tamworth, Kidderminster, Dudley, Worcester, Droitwich, Bromsgrove, Wolverhampton, Warwick, Stourbridge, West Midlands, Stourbridge, Lichfield, Hereford, Rugby, Halesowen, Wednesbury, Crewe, Redditch, Uttoxeter, Leicestershire, Kidsgrove, Staffordshire, Telford, Walsall, Bridgnorth, Leicester, Black Country, Nuneaton, Solihull, Shrewsbury, Milton Keynes, Newcastle Under Lyme