<< Back To Training Homepage

Download (.pdf)

SSRS Training Outline

SSRS Training - Day 1

1. Introduction to the SSRS Architecture:

• IIS vs. HTTP.sys
• Data Warehousing
• Report Types(Matrix, Tabular)
• Report Server
• Architecture

2. Introduction to SSRS Environment

• Creating a Project
• Design Pane
• Preview Pane
• Solution Explorer
• Report Wizard
• Shared Data Sources
• Data Sets
• Report Data Window
• Basic Report with a Table
• Lab: Build Report with a Table using Wizard

3. Report Builder

• Deploying
• Using Report Builder
• Report Models
• Lab: Build a report with report builder

4. Data Retrieval

• Queries
• Query Builder(edit as text)
• Stored procedure
• Parameters in a Query
• Parameters in a Stored Procedures
• Options
• Time Outs
• Lab: Build a Report with one Parameter
• Group Lab 1

SSRS Training - Day 2

5. Toolbox Items

• Text Box
• Line
• Table
• Rectangle
• List
• Image
• Sub report
• Actions (Drill downs. Open web pages)
• Lab: Build Report using Toolbox Items

6. Advanced Parameters

• Stored Procedure Parameters
• Cascading Parameters
• Default Values
• Multi value
• Dropdown menu
• Lab: Build a report with Cascading parameters(Year, Month, Quarter)

7. Tablix and Matrix

• Tablix
• Matrix
• Lab: Create a report with a matrix

SSRS Training - Day 3

8. Expressions, Functions, and Custom Code

• Introduction to expression builder in reporting services
• Using expressions to create dynamic reports
• Using reporting services functions with expressions
• Extending reports with custom code
• Lab: Create a dynamic report using expressions and custom code

9. Grouping filtering and sorting

• Grouping
• Filters
• Sorting options
• Lab: Create a report with sorting options
• Group Lab 2

10. Querying MDX/Cubes

• Analysis Services
• MDX
• Cubes
• Data Warehousing
• Lab: Create a report off a cube

11. Dashboards

• Charts
• Gauges
• Calendar
• Maps
• Lab: Create a dashboard

SSRS Training - Day 4

12. Administration

• Report Manager portal
• Report Server
• Deploying
• Configuration for email
• Configuration for Web
• Security
• Performance (Web farm)
• Lab: Deploy a report and set up users to view the report

13. Subscriptions

• Scheduled
• Data Driven
• Report Delivery Options
• Lab: Schedule a report to run and deliver the report

14. User Interfaces

• Report Viewer
• SharePoint
• Deploying
• Report Center
• Lab: Deploy reports to the different interfaces
• Group Lab 3 - Create a dashboard