MS SQL server reporting services (SSRS)

The SQL Server Reporting Services (SSRS) training course teaches Delegates on how to implement a Reporting Services solution in an organization. The course discusses on how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

By attending SQL Server Reporting Services workshop, Delegates will learn to:

  • Create tabular and list reports
  • Build expressions and how they are used within SSRS
  • Use global, field and parameter collections
  • Create Groups using the grouping pane for Details Group and Row Groups
  • Use parameters with stored procedures, with values on reports and unbound parameters
  • Create Matrix reports and see the new features of Matrix reports for SSRS 2008
  • Deploy reports and use the report manager
  • Use SSRS Security, SSL and Data Source Security

COURSE AGENDA

  • Report Models
  • Report Builder 3.0
  • Ad-Hoc Reporting
  • Charts
    • Pie Chart
    • Bar Chart
    • Line Chart
    • Sparkline
    • Maps
  • Subscriptions
    • Scheduled
    • Shared Subscriptions
    • Tracking errors in a Scheduled Report Job
    • Data Driven
    • Report Delivery Options
  • Administration
    • Report Manager portal
    • Report Server
    • Deploying
    • Configuration for email
  • Create Roles
  • Security
  • SharePoint Integration
  • Common Issues and Solutions
  • Grouping filtering and sorting
    • Grouping - Columns and Rows
    • Expanding/Collapsing Groups - Columns and Rows
    • Filters vs Parameters
    • Sorting options
    • Interactive Sorting
  • 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 and Variables
    • Adding external references
  • Report Design using Sub Reports
  • Configuring Reporting Services
  • Publishing Report
    • Project Properties
    • Deployment Properties
    • Report Center
  • Reporting Services Architecture
  • Report Life Cycle
  • Report Execution Process
  • Reporting Services Installation
  • Understanding BIDS Environment
    • Creating a Project
    • Design Pane
    • Preview Pane
    • Solution Explorer
    • Report Data Window
  • The Basics of Reporting: Creating the First Report
    • Report Wizard
    • Report Item
  • Creating Data Source
    • Private Data Source
    • Shared Data Source
  • Report Layouts
    • Report Items
    • Table Regions
  • Data Retrieval
    • Queries
    • Query Builder(edit as text)
    • Stored procedure
  • Caching and Report Parameters
    • Query Parameters
    • Report Parameters
    • Cascading Parameters
  • Filtering Options
    • Query Level Filter
    • Report Level Filter
  • Matrix Reports