SQL SERVER REPORTING SERVICES TRAINING COURSES ALTRINCHAM
About Enable Technology Altrincham SQL Server Reporting Services Training Courses
We offer intensive two and three days SQL Server Reporting Services courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and SQL Server Reporting Services course resources that can be referenced post training. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. This SQL Server Reporting Services course is available online during the Covid 19 crisis. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor. We are happy to modify the SQL Server Reporting Services syllabus to match your teams training requirements.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Fujistu PLC, Dollond & Aitchison Limited, Countrywide Homes Limited, Homeserve PLC, Birmingham City University, Cadbury PLC, Queen's Medical Centre Nottingham and Vodafone Group Services.
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Altrincham
- 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 ... Data filters
- See Training Course Details...
Mobile report publisher
Secure access to reports by using authentication, permissions, and SSL encryption.
Databars, sparklines, indicators, gauges, and maps
Sorting and grouping
Create a report using report builder or report designer.
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Topics include Introduction to Reporting Services
Introduction to reporting services
Report subscription and delivery Administering Reporting Services
Reporting services tools Reporting Services Data Sources
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Overview of mobile reports
Schedules
Images and charts
Configuring data access with report builder
Drillthrough in mobile reports
Publish a report to reporting services Working with Reporting Services Data
Using Datasets Creating Paginated Reports
Implementing report filters and parameters Visualizsng Data with Report Services
Work with expressions and embedded code.
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Altrincham
- 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 various global collections that you can reference in your expressions
- See Training Course Details...
Dig into the use of unbound, multivalued, and cascading parameters
Learn how to use URL to integrate Reporting Services reports into your applications
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
Find out how you can use conditional formatting to make your reports more dynamic
Master the Reporting Services Grouping pane
Find out how to display parameter values in report headers
Learn how to call the Report Server Web Service
Snapshots and Subscriptions
Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services
Learn about datasets and data regions
Introducing SQL Server Reporting Services
Learn how to solve common parameter issues
Learn how to create data-driven report subscriptions
Explore the storing of credentials within a data source
Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server
Programming Reporting Services
Learn how to calculate group totals and percentages
Learn how to enable and control report caching
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Altrincham
- 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 ... Using the List Object to Combine Other Items
- See Training Course Details...
Introduction to SQL Server 2016 Report Builder
Exploring the Report Builder Interface
Examining Maps
Creating Subreports and Drillthrough Reports
Utilizing Lists
Exploring Subscriptions
Exploring Table or Matrix Wizard
Visualizing Your Company Report Templates
Examining Security
Mastering Data Region(s)
Understanding Variances Between SQL Versions
Filtering, Grouping, and Sorting
Understanding HTML5 and Textboxes
Exploring Gauges
Utilizing Charts
SQL Server 2016 Report Builder Basic Reports
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Altrincham
- 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 ... Reporting Services Modes
- See Training Course Details...
Creating Report Parameters
Report Designer and Data Windows Configuring Report Projects
Create A Shared DataSet for Northwind
Create a Shared Data Source and Two Data Sets
Service Architecture Report Building Tools
Shared Dataset Design View Creating Ad Hoc Reports with Report Builder
Formatting Text Boxes in the Text Box Properties Dialogue Box
Cascading Parameters
The Tablix Component
Setting Report Project Properties
Create a Pie Chart with Point Labels
Formatting Text Boxes in the Properties Window
Report Project Configurations Creating a New Report in the Report Designer
Creating a Custom Age Function
User Collection
Introduction to Report Builder
Globals Collection Creating Custom Functions
Null Handling
Data Set Parameters
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Altrincham
- 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 ... Navigation
- See Training Course Details...
Adding a Table Data Region
Security
Adding Reporting Services 2005 Users
Drawing Lines and Rectangles
Navigation
Identifying Field
Creating a Subscription
Adding Data Fields to a Table Data Region
Server Management Reports
The Reporting Services 2005 Report Wizard
Entities
Understanding Security Settings
Building a Matrix (Cross-tab) Report
Starting SQL Server Business Intelligence Development Studio
Understanding Reporting Services 2005 Caching
Reporting Services 2005 Query and Report Parameters
Resizing
Current Classroom Folder Structure
Report Design Options
Using the Expression Editor Dialog
Email us about this courses
Other Altrincham Enable Technology Training Courses
SSAS 2005 - Altrincham SQL Server Analysis Services Training Courses
DAX Altrincham Training Courses
JQuery Mobile Altrincham Training Courses
Excel Power Pivot Altrincham Training Courses
Data Warehouse - Altrincham SQL Training Courses
Crystal 2011 - Altrincham Crystal Reports Training Courses
Excel Basic Altrincham Training Courses
PL/SQL Altrincham Training Courses
Power BI - Altrincham Microsoft Power BI Training Courses
Power Query - Altrincham Excel Training Courses
TSQL Altrincham Training Courses
Excel Advanced Altrincham Training Courses
SSAS 2017 - Altrincham SQL Server Analysis Services Training Courses
Crystal 2008 Altrincham Training Courses
Mobile Altrincham Training Courses
North West - Possible Sql Server Reporting Services Training Course Locations
Cheshire, Kirkby, Eccles, Skelmersdale, Preston, Denton, Ellesmere Port, Salford, Northwich, Middleton, Winsford, Crosby, Chadderton, Accrington, Lancaster, North West, Lancashire, Bury, Blackburn, Warrington, Bootle, Hyde, Burnley, Rochdale, Huyton, Runcorn, Saddleworth, Leigh, Wallasey, Wigan, Prestwich, Manchester, Merseyside, Thornton-Cleveleys, Stretford, Chorley, Sale, Wythenshawe, Blackpool, Southport, Stockport, Morecambe, Liverpool, Birkenhead, Carlisle, Bolton, Lytham Urmston, Leyland, Altrincham, Farnworth, Oldham, Widnes, Barrow-in-Furness, Ashton-under-Lyne, Crewe, Chester, Macclesfield