Faysal AzizEnquire
FA-0471DevOps, Cloud & InfrastructureData & Analytics

Course Outline for SQL Server Reporting Services

Introduction

Why this course

SSRS or SQL Server Reporting Services is a server based reporting tool that helps design both tabular and Matrix style reports. The tool of choice for this is Microsoft SQl Server (Community edition). This is a hands-on two day course meant to cover everything from level zero. There are however certain prerequisites.

Course Outcome

By the end of this course, the learner may be expected to:

  • Create Reports using SSRS
  • Write Expressions
  • Use Images Inside your Report
  • Use Built-In Functions of SSRS
  • Apply Grouping and SubTotals to your Reports
  • Create Parameterized Reports
  • Create Drill-Down Reports
  • Create Reports with Cascading Parameters
  • Implement Inter Active Sorting
  • Work with Gauge, DataBar, KPI Indicator, Data Bar Controls
  • Create Matrix Reports
  • Learn The Deployment Mechanism
  • Cache and SnapShot reports
Prerequisites

Prerequisites

In order to be able to participate in this course, the learners need to fulfill the following requirements:

  • Understanding of the OS they will be using, especially the foiling system.
  • Basic SQL.
  • Basic understanding of how RDBMS works.
  • Fluency in English.
  • Access to at least two screens.
  • At least 1MBPS net connection.
Training outline

6 modules

·
01Module 18 topics
  1. Creating a Report with a wizard
  2. Creating a Report Manually Using Table Data Region
  3. Creating a Shared DataSource and Shared DataSet
  4. Creating a Report Manually Using List Data Region
  5. Creating a MailMerge Report Using List Data Region
  6. Using Embedded Images
  7. Using External Images
  8. Using DataBound Images
02Module 29 topics
  1. Creating Simple Expressions
  2. Using IIF Function
  3. Using Switch Function
  4. Writing Custom Code Functions
  5. Report with Grouping and SubTotals using Wizard
  6. Report With Grouping and SubTotals Manually
  7. Creating Running Totals for a Report
  8. Creating Running Totals for each Group of a Report
  9. Working with Built-In Fields
03Module 39 topics
  1. Creating a Simple Parameterized Report
  2. Creating a Report with DropDown Parameter
  3. Creating a Report with Multi-Valued Parameter
  4. Creating a Parameterized Report On Date Columns
  5. Creating a Report Using UnBound Parameters
  6. Parameterized Sorting
  7. Parameterized Sorting Using Dynamic SQL
  8. Creating a Report Using Cascading Parameters
  9. Creating a Parameterized Report with Boolean Columns
04Module 411 topics
  1. Implementing InterActive Sorting
  2. Implementing InterActive Sorting Using Groups
  3. Implementing Drill-Down Reports
  4. Implementing Dynamic Column Visibility
  5. Implementing Conditional Formatting
  6. Implementing Document Map Functionality
  7. Repeating and Freezing Column Headers
  8. Using BookMark Action
  9. Using GoTo Report Action
  10. Using GoTo URL Action
  11. Using Embedded HTML Feature
05Module 511 topics
  1. Creating a Basic Matrix Report
  2. Adding Row Groups
  3. Adding Column Groups
  4. Adding Data Cells
  5. Working with Gauge Control
  6. Working with Indicator Control
  7. Working with SparkLine Control
  8. Working with DataBar Control
  9. Creating Column Graph
  10. Creating PIE Graph
  11. Creating Bar Graph
06Module 66 topics
  1. Configuring Reporting Services
  2. Deploying Reports
  3. Adhoc Query
  4. Working with Stored Procedures
  5. Creating Cached Reports
  6. Creating Parameterized Cached Reports
  1. ASSESSMENT

A programme built around your team.

Share your training goals and requirements.

Training enquiry

Course Outline for SQL Server Reporting Services
FA-0471

Share your requirements for this programme.

Training enquiry

Course Outline for SQL Server Reporting Services