Enable Technology

SQL SERVER REPORTING SERVICES THORNTON-CLEVELEYS TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES THORNTON-CLEVELEYS




About Enable Technology Thornton-cleveleys SQL Server Reporting Services Training Courses

We are a company that provides short intensive SQL Server Reporting Services training courses. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive SQL Server Reporting Services training materials and practice files which are theirs to refer to after the course. Our policy is to provide open ended SQL Server Reporting Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

SQL Server Reporting Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver SQL Server Reporting Services courses onsite at your offices. You simply need to provide a suitable room. Another way we could deliver the SQL Server Reporting Services course is at a local socially distanced training site. We are happy to modify the SQL Server Reporting Services syllabus to match your teams training requirements.

We can also deliver SQL Server Reporting Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Unipart Group, Homeserve PLC, Aston University, Fujistu PLC, Lloyds TSB Bank PLC, Canadian High Commission, Norwich Union PLC and Carillion PLC.




SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Thornton-cleveleys
  • 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 ...
  • Create a Database for Report Execution Data
    Entities
    Understanding the Model Designer
    Fields tab
    Create a Dataset
    Formatting Textboxes with the Textbox Properties Dialog
    Adding Groups and Users
    Managing Objects in Object Explorer
    Quick Formatting using Toolbar and Menu Options
    Explorer Pane
    Introduction to Reporting Services 2005
    The Main Components of the Design Environment
    Design the Query Dialog
    General
    Creating a Data Source View
    Drawing Lines and Rectangles
    Model Statistics
    SQL Server 2005 Reporting Services Features
    Data-driven Subscription

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Thornton-cleveleys
  • 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 format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box 
    Learn how to calculate group totals and percentages 
    Learn how to create matrix reports 
    Explore the basic architecture of SQL Server Reporting Services 
    Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Find out how you can use conditional formatting to make your reports more dynamic 
    Investigate the scheduling of report snapshots 
    Explore creating groups 
    Discover interactive sorting 
    Explore the storing of credentials within a data source 
    Learn about report variables and when you might need to use them 
    Learn how to create custom functions using the Code window 
    Discover the classes and methods exposed by the Reporting Services Web Service API 
    Discover the various global collections that you can reference in your expressions 
    Snapshots and Subscriptions
    Dig into the use of unbound, multivalued, and cascading parameters 
    Investigate how to call a custom assembly from a report 

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Thornton-cleveleys
  • 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 ...
  • Schedules
    Preparing data for mobile reports
    Mobile report publisher
    Introduction to reporting services
    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
    Extend reporting services functionality with external assemblies.
    Overview of mobile reports
    Use report services configuration manager to reconfigure SSRS servers.
    Formatting data
    Data filters
    Using Datasets Creating Paginated Reports
    Reporting services components
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Add a drillthrough to a custom URL
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Drillthrough in mobile reports
    Sorting and grouping
    Report caching, snapshots, and comments
    Work with expressions and embedded code.
    Configuring data access with report designer

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Thornton-cleveleys
  • 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 Customer Contact List  Creating Ad Hoc Reports With Report Builder
    The Tablix Properties Dialogue Box
    Considering Report Layout Options
    Report Project Types  Working with Report Server Projects
    No Data Rows
    Using Charts in a Report
    Using Report Parts Shared Data Sets
    Create a Tabular Report  Using the Tablix Report Type
    Providing a Drop-Down List for a Report Parameter
    Parameters and Stored Procedures
    Data Bars
    Synchronized Data Alignment  Using the Tablix Report Type
    Create a Custom Function  Managing Page Layout and Adding Interactivity
    Shared Dataset Design View  Creating Ad Hoc Reports with Report Builder
    Create a Pie Chart with Point Labels
    Formatting a Chart  Visualising Performance with Data Bars, Sparklines and Indicators
    Report Project Configurations  Creating a New Report in the Report Designer
    Reporting Services Modes
    Introduction to Report Builder
    Work with Multivalued Parameters  Enhancing Reports with Data Visualisations
    Page Headers and Footers Report Formatting Options

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Thornton-cleveleys
  • 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 Security
    Utilizing Dynamic Headers and Footers
    SQL Server 2016 Report Builder Basic Reports
    Planning Your Reports
    Introduction to SQL Server 2016 Report Builder
    SQL Server 2016 Report Builder Graphics
    Examining Management
    Working with Expressions
    Understanding Visualizations
    Using Tables
    SQL Server 2016 Report Builder Wizards
    Exploring Gauges
    Examining Maps
    Working with Datasets
    Creating Subreports and Drillthrough Reports
    SQL Server 2016 Report Builder Advanced Reporting
    Understanding HTML5 and Textboxes
    Understanding Report Parts

  • See Training Course Details...



Email us about this courses



Other Thornton-cleveleys Enable Technology Training Courses

Project 2016 - Thornton-cleveleys Microsoft Project Training Courses
CSS - Thornton-cleveleys Web Development Training Courses
SSAS 2014 Thornton-cleveleys Training Courses
SSIS 2005 Thornton-cleveleys Training Courses
Microsoft Project Level 3 Thornton-cleveleys Training Courses
SSIS 2008 Thornton-cleveleys Training Courses
Oracle BI Thornton-cleveleys Training Courses
PowerPoint Basic - Thornton-cleveleys Office Training Courses
Access VBA Thornton-cleveleys Training Courses
Excel Intermediate - Thornton-cleveleys Excel Training Courses
Crystal XI Thornton-cleveleys Training Courses
SSAS 2008 - Thornton-cleveleys SQL Server Analysis Services Training Courses
PHP - Thornton-cleveleys PHP Training Courses
HTML - Thornton-cleveleys Web Development Training Courses
Crystal 2013 Thornton-cleveleys Training Courses