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 are company which specialises in short, two and three day intensive SQL Server Reporting Services technology training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a SQL Server Reporting Services course will be provided with training materials and practice files to retain after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Reporting Services queries. This support is open ended.

SQL Server Reporting Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver SQL Server Reporting Services courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in National. We offer the option of working with you to develop a bespoke SQL Server Reporting Services programme which precisely matches your organisations training requirements.

SQL Server Reporting Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are South Staffordshire Water PLC, Loughborough University, DHL Express, Birmingham City Council, Shell UK Oil Products Ltd, Barclays Bank PLC, Aston University and Canadian High Commission.




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 ...
  • Run the Sample Reports
    History Properties
    Reporting Services 2005 Web Components
    Configure and Run the Job Package
    Key Considerations
    Perspectives
    Previewing a Report
    Creating a Report Model File
    Linked Reports
    Resizing
    SQL Server Management Studio Overview
    Data Output
    Execution Reporting Services 2005 Log Reports
    Chart Options
    Reporting Services 2005 Client Components
    Displaying Parameters in a Report
    Clickthrough Reports
    Visibility
    Publishing Reporting Services 2005 Reports
    Table Data Region Record Sorting
    Sorting

  • 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 ...
  • Extend reporting services functionality with external assemblies.
    Databars, sparklines, indicators, gauges, and maps
    Publish a report to reporting services Working with Reporting Services Data
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Use report services configuration manager to reconfigure SSRS servers.
    Schedules
    Overview of mobile reports
    Reporting services components
    Using Datasets Creating Paginated Reports
    Configuring data access with report builder
    Creating a report with the report wizard
    Report sub-reports
    Formatting data
    Configuring data access with report designer
    Report parameters
    Preparing data for mobile reports
    Drilldown and drill through Sharing Reporting Services Reports
    Work with expressions and embedded code.
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Drillthrough in mobile reports
    Implementing report filters and parameters Visualizsng Data with Report Services

  • 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 ...
  • Shared Data Sources
    Using Unbound Parameters Understanding Report And Data Set Parameters
    Expression Operators
    Considering Report Layout Options
    Using Charts in a Report
    Create a Tabular Report  Using the Tablix Report Type
    Designing the Page Layout
    Using Parameters with Ad Hoc SQL
    Built-in Functions
    Reordering Report Parameters Using Drop-Down List Parameters
    Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
    Overview
    Introduction to SQL Server Reporting Services
    A Tour of the Report Builder Interface
    Create a Matrix Report
    Report Builder vs. Report Designer
    Report Project Configurations  Creating a New Report in the Report Designer
    Preview Performance
    Create a Pie Chart with Point Labels

  • 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 ...
  • Exploring Matrix
    Examining Parameters
    Working with Map Wizard
    Understanding HTML5 and Textboxes
    Exploring Gauges
    SQL Server 2016 Report Builder Wizards
    Exploring Table or Matrix Wizard
    Using the List Object to Combine Other Items
    Examining Management
    Exploring Subscriptions
    Planning Your Reports
    Utilizing Charts
    Understanding Variances Between SQL Versions
    Utilizing Chart Wizard
    Creating Subreports and Drillthrough Reports
    Understanding Report Parts
    Utilizing Dynamic Headers and Footers
    SQL Server 2016 Report Builder Basic Reports
    Visualizing Your Company Report Templates

  • See Training Course Details...


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 ...
  • Security
    Investigate what SQL Server Reporting Services can do 
    Learn how to work with rich text to produce mail merge style reports 
    Learn how to use URL to integrate Reporting Services reports into your applications 
    Managing Reporting Services
    Understand how to plan and configure for deployment 
    Explore how to create expressions in your reports using 
    Learn how to create parameters in ad-hoc SQL 
    Explore the basic architecture of SQL Server Reporting Services 
    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 
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Explore the maintenance of report history 
    Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box 
    Working with Parameters
    Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Advanced Reporting Services Programming
    Investigate Reporting Services charts 

  • See Training Course Details...



Email us about this courses



Other National Enable Technology Training Courses

HTML - National Web Development Training Courses
Crystal XI - National Crystal Reports Training Courses
Microsoft Project Level 2 - National Microsoft Project Training Courses
Excel Power Pivot - National Excel Training Courses
SSIS 2008 - National SQL Server Integration Services Training Courses
TSQL - National SQL Training Courses
Access 2016 - National Access Training Courses
PHP National Training Courses
Crystal 2008 - National Crystal Reports Training Courses
Power Graphics National Training Courses
Access VBA National Training Courses
Excel Advanced National Training Courses
JQuery Mobile National Training Courses
SSIS 2005 National Training Courses
PowerPoint Advanced National Training Courses