Next course begins April 8th

SQL Reporting Services Fundamentals

This 5 day course will give delegates a thorough study on using SQL Server Reporting Services (SSRS). The course will teach participants how to implement a Reporting Services solution.

What you'll learn

Participants will learn how to use the Reporting Services development tools to create reports and additionally how to use the Reporting Services management and administrative tools. The course will involve plenty of hands-on exercices to facilitate the learning process and enable participants to quickly gain confidence in using Reporting Services

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the SQL Server Reporting Services.

Course Content

What is Reporting Service

  • Who uses SSRS?
  • The 4 main Visual Studio Windows
  • Business Intelligence Reporting Solutions

Reporting Services Architecture

  • How Reporting Services works
  • Reporting Engine Architecture
  • Data Tier
  • Application Tier
  • Server Tier
  • SSRS Tools: Report Designer, Report Manager, Reporting Services Configuration Manager
  • SSRS Processors & Extensions:Processing & Rendering Extensions (HTML, CSV, XML, Image, PDF, Excel, Word)
  • SSRS Delivery Extensions
  • SSRS Databases: Report Server, Report ServerTempDB

Report Builder 3.0

  • Business Intelligence Design Studio
  • SQL Server Data Tools
  • SSRS Report Planning
  • Designing Reports with Wizards
  • Designing Custom Reports
  • Authoring a report
  • Using report items
  • Selecting and formatting report items
  • Report Function and Formatting
  • Images and Textboxes
  • Enterprise Ad-hoc Reports

Advanced Report Design

  • Headers and Footers
  • Table and Matrix Groups
  • Adding Totals to Table and Matrix Reports
  • How to create report templates
  • Text Boxes, Padding & Embedded Formatting
  • Designing Master/Detail Reports
  • Creating Drill down reports
  • Creating Sub Reports
  • Creating Drill through and Link Action Reports
  • Navigating Reports:Bookmarks, URLs
  • Expression Builder
  • Fields!Globals!Paramters! and Report Items
  • SSRS Operators:string concatenation, aritmetic, comparison
  • SSRS Functions: Maths, String, Data, IIf, Switch
  • Conditional Formatting
  • Using List Regions to combine Report Items

Report Layout and Formatting

  • Report Layout Types:Table, Matrix, List, Chart, Gauge, Dashboard
  • Tablix Regions
  • Tablix Properties
  • Table Groups
  • Group Expressions
  • Interactive Sort
  • Page Breaks
  • Drill Downs
  • Formatting Report Data
  • Dynamic Formatting
  • Multicolumn Reports
  • Gauge Reports

Implementing Interactive Sorting

  • Adding Fixed Headers
  • Working with Parameters
  • Prompting for User Input
  • Using a Report Parameter as a filter
  • Using a Dataset for Report Parameter values
  • Adding a Query Parameter to a Dataset
  • Creating Cascading Parameters
  • Displaying Parameter Selections in a Report

Developing Report Models

  • Preparing to Develop a Report Model
  • Generating a Report Model
  • Refining a Report Model
  • Managing a Report Model

Review of Deployment Options

  • Deploying a Report Project
  • Uploading a Report
  • Using Rs Utility
  • Using Folders to Organise Content
  • Creating a Linked Report
  • Configuring Data Source Properties
  • Configuring Report Execution Properties

Developing Expressions

  • Adding Calculations to a Report
  • Adding a Calculated Field
  • Creating a Text Box Expression
  • Using a Report Item Expression
  • Using Built In Fields
  • Using Aggregate Functions
  • Changing Report Item Properties by using Expressions
  • Working with Variables
  • Using Expressions for Dynamic Connections and Datasets
  • Developing Expressions for Hierarchical Data

Navigating around Report Manager

  • Organising Reports, Data Sources and Datasets
  • Adding Data Cells
  • Displaying or Hiding Report Manager Details
  • Running Reports
  • Managing Folders and Files
  • Managing Reports and Data Sources
  • Creating a Standard Subscription
  • Parts of a Subscription
  • Managing Reports and Data Sources
  • Managing Site Settings
  • Creating Linked Reports
  • Managing Generic-site Settings
  • Report Caching
  • Report Snapshots

Report Security

  • Configuring Report Server Security
  • Learn basic authentication
  • Assigning User Permissions
  • Implementing Data Security
  • Configuring Report Server Security Policies
  • Assigning User Permissions
  • Configuring Item-Level Security

Performing Administrative Tasks

  • Using Management Tools
  • Configuring the Report Server
  • Monitoring the Report Server

Upcoming Dates

LocationDatePrice
AbujaApril 8th, 2024₦350,000
KigaliMay 20th, 2024RF800,000
AbujaJune 17th, 2024₦350,000

Delivery Methods

Classroom Training

Unlock your potential with our classroom training courses. Our portfolio of business intelligence training courses are delivered by BI experts across Africa.

Online Training

Our online trainings (live instructor-led) are delivered by certified instructors and are designed to replicate a classroom experience which enables full interactions.

Onsite Training

Our onsite training team allows us to bring our skills and expertise to you. Onsite courses are developed in conjunction with you, ensuring your expectations are exceeded.

1-to-1 Training

With our one-to-one training you’ll not only receive the undivided attention of the trainer, but one-to-one training allows you to tailor the training to your specific needs.

From ₦350,000
C8000 | RF800,000

Certification

Refreshments

Training multiple people?

Empower your teams with business intelligence training courses delivered by subject matter experts.

Apply for SQL Reporting Services Fundamentals

Which date are you interested in?

Apply for SQL Reporting Services Fundamentals

Which date are you interested in?