Business Booking Details

Payment Of Invoices

For bookings from established businesses, we do not require payment at the point of booking.

We will send you an invoice which you can submit to your accounts payable system.

Purchase Orders

If your employer uses a purchase order (P.O.) system to manage supplier invoices that is no problem.

  • If you already have a P.O. number when booking add it to the PO number box on the booking form, and we will include it on your invoice.
  • If you need an invoice to generate a P.O. number in your accounts system, please book the course as normal and add a note in the PO number box – to be provided
  • We will send you an invoice (without a P.O.) which you can use to generate a P.O..
  • We will then re-issue your invoice with your P.O. included when you provide us with it

PAYMENT METHODS:

You are not able to pay directly online at the time of booking, we issue an invoice for all bookings.

We accept payment either via direct bank transfer or card

Our invoices contain our bank details if you would like to pay by bank transfer and there is also information on how to pay by card.

Please note, if you are using a business card there is a surcharge of 2% to cover the payment processing charges.

Master the full reporting lifecycle of designing, managing, and accessing reports in a Microsoft SQL Server.

This is a hands-on course. It includes plenty of time to experiment with what you are being taught and try things out for yourself.

By the time you finish, you’ll be comfortable working independently in SSRS.

✔ A complete SSRS course that covers all of MS SQL Reporting Services.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.

What Will I Learn?

This course is in three discrete parts.

Days 1 & 2

You will become familiar with SQL Server Reporting Services’ (“SSRS”) development tools and learn to use them to create and author reports. Initially these are simple but the course soon progresses to more complex reports.

You will also learn about the data regions used in report design, including tables, matrices, lists, and charts.

Interactive features such as drilldown and drill-through reports are also covered in this section, as are the implementation and use of report parameters.

Day 3

You build on the knowledge gained over the previous two days by covering advanced report design concepts such as using Analysis Services as a data source, making your reports more dynamic (eg. allowing users to interactively select groups for a matrix through parameters), alternating background colours for table rows, and other handy tips to enable developers to design truly professional reports.

Day 4

The last day of the course deals specifically with the role of the Report Server itself. Here, you will learn how to deploy reports to a Report Server, manage Report Server content, handle subscriptions, and control access to reports.

Am I Ready For This Course?

No prior knowledge of SSRS is required for this course.

Ideally, you should already be familiar with basic programming concepts, and understand the fundamentals of relational databases and data normalization.

Some prior working knowledge of SQL Server and the use of SQL Server Management Studio is assumed. In addition, you should be familiar with the SQL query language and, in particular, the SELECT statement used for retrieving data.

The Training Day

Our courses run from 9.30am to roughly 4.15pm with refreshments throughout the day and a break for lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the best instructors on the planet.

Also, you’ll receive:

✔ A full-colour A4 manual covering everything in the course.
✔ A USB stick for the course exercises to let you practise more in your own time.
✔ A Certificate of Attendance.

Course details

  • Overview of Reporting Services
  • The Reporting Life Cycle
  • Reporting Services Architecture
  • Reporting Services Tools
  • Introduction to SQL Server Data Tools (SSDT)
  • Creating a Report Project
  • The Report Designer Environment
  • Table Reports
  • Grouping and Aggregating Data
  • Sorting Data
  • Using a Matrix
  • Using a List
  • Using Text Boxes, Lines, and Images
  • Formatting Reports
  • Page Breaks
  • Report Headers and Footers
  • Implementing Expressions
  • Using Variables
  • Controlling Layout with Rectangles
  • Interactive Sorting
  • Drill-Down Reports
  • Document Maps
  • Bookmarks
  • Using Parameters to Restrict Query Results
  • Using Parameters to Filter Report Data
  • Creating Dynamic Parameter Lists
  • Cascading Parameters
  • Displaying User Selected Parameters in a Report
  • Subreports
  • Drill-Through Reports
  • Working with Charts
  • Gauges
  • Indicators and KPIs
  • Data Bars
  • Spark Lines
  • Overview of Report Builder
  • Designing a Report in Report Builder
  • Implementing Report Parts
  • Using an Analysis Services Data Source
  • Implementing Maps with Spatial Data
  • Embedding Code in Reports
  • Implementing Custom Assemblies
  • Creating Templates
  • Using Parameters with a Stored Procedure
  • Dynamic Data Sources and Datasets
  • Dynamic Grouping
  • Hiding/Showing Columns
  • Adjacent Groups
  • Recursive Hierarchy Grouping
  • Alternating Background Colours
  • Compact Grouping Layout
  • Handling the Absence of Data in a Report
  • Other Report Design Tips and Tricks
  • Configuring Reporting Services
  • Deploying Reports
  • Introduction to the Report Manager
  • Executing Reports on Demand
  • Managing Report Server Content
  • Linked Reports
  • Managing Data Source Properties
  • Caching Reports
  • Report Snapshots
  • Report History
  • The My Reports Folder
  • Rendering Reports to Different Formats
  • Introduction to Report Subscriptions
  • Creating a Standard Subscription
  • Creating a Data-Driven Subscription
  • Managing Report Subscriptions
  • Securing Report Server Content
  • Implementing Data Security
  • Using URL Access to Display a Report

Online Training Requirements

To attend this MS SQL Server course online, you will need:

MS SQL Server Management Studio connected to a SQL database on your Windows PC/laptop with a camera, speakers & microphone
A stable internet connection capable of running Zoom
To be a confident computer user and able to use Zoom

If you have access to a second screen, we would encourage you to use it as it improves the experience.