Publisher: Microsoft

Version: 2008
Length: 2 day s
Course-ID: SX675GRB

Course Overview

SQL Server 2008 Reporting Services provides a versatile and powerful reporting platform for data on Microsoft SQL Server 2008 or any other database system. In this course, you learn how to extract business intelligence from your data. In addition, you gain the knowledge and skills to produce compelling reports and deliver those reports.

Course Objective

Target student

Anyone designing, creating or delivering reports from relational databases with SQL Server 2008 Reporting Services.

Prerequisites

Previous exposure to any database system or spreadsheet data is assumed.


Introduction
  • Introduction to Reporting Services 2008
  • Overview
  • The Report Server Architecture
The Report Designer
  • Introduction to the Design Environment
  • Collecting the data
  • Parameters
  • Expressions
  • Functions
  • Layout
Data Access
  • Introduction to Data Access
  • Connecting to Data
  • Data Sets
  • Report Parameters
  • Tablix Reports
  • Cross Tab Reports
  • Freeform Reports
  • Interactive Reports
  • Drill Down
  • Sub-Reports
  • Charts and Gauges
  • Advanced Report Design
  • “Dynamic” columns
Report Management
  • The Manager and the Server
  • Managing Content
  • Managing Security
  • Reporting Services Security
  • SQL Server Security
  • Windows Security
Report Execution and Subscriptions
  • Execution
  • Subscriptions
  • Data Driven Subscription
Report Rendering
  • Delivering reports to the Report Manager
  • Delivering reports to ASP.NET pages
  • Accessing reports via URL’s