01483 688488 01483 688488 Request a callback Email us
Microsoft
Office 365Office 365
AccessAccess
ExcelExcel
OutlookOutlook
Power AutomatePower Automate
Power BIPower BI
PowerPointPowerPoint
ProjectProject
SharePointSharePoint
VisioVisio
WordWord
Adobe
After EffectsAfter Effects
CaptivateCaptivate
Creative CloudCreative Cloud
IllustratorIllustrator
InDesignInDesign
PhotoshopPhotoshop
Premiere ProPremiere Pro
CAD
AutoCADAutoCAD
RevitRevit
SketchUpSketchUp
SolidWorksSolidWorks
Technical
Crystal ReportsCrystal Reports
HTML & CSSHTML & CSS
MapInfoMapInfo
RR
SPSSSPSS
SQLSQL
WordPressWordPress
Finance
Finance CoursesFinance Courses
XeroXero
Professional Development
ResilienceResilience
Training: 90 Minute Blitz Training: 90 Minute Blitz
Soft Skills
AssertivenessAssertiveness
Chairing MeetingsChairing Meetings
Minute TakingMinute Taking
Team LeaderTeam Leader
Time ManagementTime Management
Executive Coaching
Deliver Confident & Impactful Presentations Training
MS SQL Server Reporting Services (“SSRS”) Course

MS SQL Server Reporting Services (“SSRS”) Course

4.9 / 10 reviews

Introduction

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 so that you can recap.
✔ 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 (these can be downloaded for free from the Microsoft website) 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 to attend the course

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