Enable Technology

SQL SERVER REPORTING SERVICES LANCASHIRE TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES LANCASHIRE




About Enable Technology Lancashire SQL Server Reporting Services Training Courses

We are a company that offers short, practical, SQL Server Reporting Services hands on technology 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. Enable Technology offer post course help to all delegates. Participants on the SQL Server Reporting Services course can contact the tutor for as long as they like if they encounter SQL Server Reporting Services problems.

We provide instructor led training coupled with hands on training. While social distancing is in place we are only delivering SQL Server Reporting Services courses 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. The SQL Server Reporting Services syllabus can be modified to accommodate your specific training needs.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Dollond & Aitchison Limited, Canadian High Commission, Keele University, West Bromwich Building Society, University of Birmingham, Cadbury PLC, Boots UK Limited and South Staffordshire Water PLC.




SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Lancashire
  • 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 Report with Interactive Sorting Dynamic Reports with Parameters
    A Tour of the Report Builder Interface
    Preview Performance
    Work with Multivalued Parameters  Enhancing Reports with Data Visualisations
    Exploring the Tablix Report Type
    Report Designer and Data Windows Configuring Report Projects
    Create a Matrix Report
    Indicators
    Creating a Columnar Report
    Create Shared Data Sources and Data Sets
    Create a Data Source Connection
    Parameters and Stored Procedures
    Create and Configure a Report Server Project
    Reordering Report Parameters Using Drop-Down List Parameters
    The Report Designer Creating Reports with SQL Server Data Tools
    Rein in the Length of a Text Field
    Expression Operators
    Shared Data Sources
    Creating a Custom Age Function
    Create a Drop-Down List Parameter
    Report Project Files and Folders

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Lancashire
  • 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 ...
  • Explore the maintenance of report history 
    Learn how to calculate group totals and percentages 
    Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services 
    Learn how to create matrix reports 
    Learn how to call the Report Server Web Service 
    Investigate how to manage Reporting Services projects using Report Manager 
    Investigate what SQL Server Reporting Services can do 
    Calculation and Formatting
    Managing Reporting Services
    Investigate Reporting Services charts 
    Programming Reporting Services
    Discover the many application programming interfaces of Reporting Services 
    Learn how to create custom functions using the Code window 
    Investigate how Reporting Services secures access to reports and other Reporting Services resources 
    Learn how to work with rich text to produce mail merge style reports 
    Dig into the use of unbound, multivalued, and cascading parameters 
    Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services 
    Find out how you can use conditional formatting to make your reports more dynamic 

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Lancashire
  • 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 ...
  • General
    Parameters
    Introduction to Reporting Services 2005
    Report Filters
    Reporting Services 2005 Query and Report Parameters
    The Reporting Services 2005 Report Designer
    Reporting Services 2005 Security Model Concepts
    Deploying Reports with Development Studio
    Data Output
    Parts of the Chart
    Reporting Services 2005 Data Processing Extensions
    The Reporting Services 2005 Layout View
    Auditing and Management Reports
    Managing Tables with the Table Properties Dialog
    Changing Columns and Rows
    Reporting Services 2005 Security
    Understanding Reporting Services 2005 Subscriptions
    Sorting
    Deploy Sample Reports to Report Server
    Reporting Services 2005 Deployment Options

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Lancashire
  • 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 ...
  • SQL Server 2016 Report Builder Wizards
    Understanding Variances Between SQL Versions
    Filtering, Grouping, and Sorting
    Examining Management
    Exploring the Report Builder Interface
    Formatting Reports
    Utilizing Chart Wizard
    Working with Expressions
    Understanding Report Parts
    SQL Server 2016 Report Builder Advanced Reporting
    Examining Maps
    Understanding Visualizations
    SQL Server 2016 Report Builder Graphics
    Examining Parameters
    Understanding HTML5 and Textboxes
    Mastering Data Region(s)
    Working with Map Wizard
    Utilizing Dynamic Headers and Footers
    Using the List Object to Combine Other Items

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Lancashire
  • 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 ...
  • Sorting and grouping
    Databars, sparklines, indicators, gauges, and maps
    Work with expressions and embedded code.
    Introduction to reporting services
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Preparing data for mobile reports
    Schedules
    Create a report using report builder or report designer.
    Report subscription and delivery Administering Reporting Services
    Extend reporting services functionality with external assemblies.
    Publish a report to reporting services Working with Reporting Services Data
    Mobile report publisher
    Use report services configuration manager to reconfigure SSRS servers.
    Formatting data
    Report parameters
    Reporting services tools Reporting Services Data Sources
    Reporting services components
    Using Datasets Creating Paginated Reports
    Configuring data access with report designer
    Implementing report filters and parameters Visualizsng Data with Report Services
    Creating a report with the report wizard

  • See Training Course Details...



Email us about this courses



Other Lancashire Enable Technology Training Courses

Access VBA - Lancashire Access Training Courses
Oracle SQL Lancashire Training Courses
Crystal 2013 Lancashire Training Courses
SSIS 2008 Lancashire Training Courses
Excel Power Pivot Lancashire Training Courses
Crystal XI - Lancashire Crystal Reports Training Courses
PowerPoint Advanced Lancashire Training Courses
SSAS 2005 - Lancashire SQL Server Analysis Services Training Courses
Power Graphics Lancashire Training Courses
Power BI - Lancashire Microsoft Power BI Training Courses
Excel Advanced - Lancashire Excel Training Courses
SQL Lancashire Training Courses
Crystal 2016 Lancashire Training Courses
Project 2016 Lancashire Training Courses
DAX - Lancashire Excel Training Courses



North West - Possible Sql Server Reporting Services Training Course Locations


Birkenhead, Leigh, Merseyside, Eccles, Warrington, Lytham Urmston, Widnes, Macclesfield, Wythenshawe, Burnley, Leyland, Liverpool, Kirkby, Middleton, Hyde, Ashton-under-Lyne, Stretford, Southport, Manchester, Skelmersdale, Lancaster, Winsford, Saddleworth, Salford, Rochdale, Chester, Barrow-in-Furness, Thornton-Cleveleys, Bury, Crewe, Denton, Prestwich, Farnworth, Bolton, Preston, Crosby, Wallasey, Runcorn, Wigan, North West, Northwich, Chadderton, Accrington, Cheshire, Chorley, Morecambe, Oldham, Carlisle, Blackburn, Bootle, Altrincham, Ellesmere Port, Blackpool, Lancashire, Huyton, Stockport, Sale