Publisher: Microsoft

Version: 2005
Length: 2 day s
Course-ID: SX676GRB

Course Overview

Students will learn how to use the Report Designer, set up data access and work with many types of reports

Prerequisites

Students should have a basic knowledge of SQL Querying.


Introduction
  • Introduction to Reporting Services 2005
  • 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
  • Tabular Reports
  • Cross Tab Reports
  • Freeform Reports
  • Interactive Reports
  • Drill-Down
  • Sub-Reports
  • Charts
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