Professional Training

Prerequisites

Familiarity with Visual Studio 2005 is helpful, but not required.

The Big Picture

SQL Server 2005 Reporting Services Features
The Reporting Services Key Components
Client Components
Web Components
Report Server Components
Database Components
Report Design Options
Visual Studio 2005 and Development Studio
Data Processing Extensions
Included Extensions
Custom Data Processing Extensions
Deployment Options
Key Considerations
Distribution Options
Rendering Extensions

The Report Wizard

Starting SQL Server Business Intelligence Development Studio
Creating a New Report Project
Welcome to the Report Wizard Dialog
Select the Data Source Dialog
Design the Query Dialog
Select the Report Type Dialog
Design the Table or Design the Matrix Dialog
Choose the Table Layout
Choose Table Style or Matrix Style Dialog
Completing the Wizard Dialog
Understanding What Just Happened
Previewing Reports
Publishing Reports
Accessing Reports via the Report Manager

The Report Designer

The Main Components of the Design Environment
Menus
Toolbars
Windows
Usability Features
Creating a Data Source and Dataset
Create a Data Source
Create a Dataset
Query tab
Fields tab
Data Options
Parameters
Filters
Using the Graphical Query Designer
Designing the Layout
The Layout View
The Toolbox
Adding a Table Data Region
Adding Data Fields to a Table Data Region
A Closer Look at Preview
Adding Textboxes
Changing Columns and Rows
Adding or Deleting
Resizing
Moving
Table Data Region Record Sorting
Using Expressions
Using the Expression Editor Dialog
Grouping Data
General
Filters
Sorting
Visibility
Data Output

Query and Report Parameters

Query vs. Report Parameters
Create a Report Query
Add Report Parameter to a Dataset
Previewing a Report with Parameters
Displaying Parameters in a Report
Dynamic Parameter Values (From Query)

Formatting Reports

Report Item Style Properties
Quick Formatting using Toolbar and Menu Options
Report Formatting Toolbar
Report Borders Toolbar
Formatting Textboxes with the Textbox Properties Dialog
General
Visibility
Navigation
Font
Format
Interactive Sort
Data Output
Managing Tables with the Table Properties Dialog
General
Visibility
Navigation
Sorting
Groups
Filters
Data Output
Setting the Report Properties
General
Layout
Code
Data Output
Drawing Lines and Rectangles

Administration

Managing Reporting Services
Using the Report Manager
Settings
Security
Other
SQL Server Management Studio Overview
The Management Studio Object Explorer
Managing Objects in Object Explorer
Server Properties
Web Folder Properties
Data Source Properties
Shared Schedules
Using the Reporting Services Configuration Manager
Tools for Managing Reports
Deploying Reports with Development Studio
Linked Reports
Managing Parameters

Subscriptions, Snapshots, and Caching

Understanding Subscriptions
Creating a Subscription
Static Subscription
Data-driven Subscription
Understanding Snapshots
History Properties
Understanding Caching
Execution Properties

Security

Security Model Concepts
Understanding System-level Roles
Adding System-level Roles
Understanding Item-level Roles
Adding an Item-Level Role
Understanding Users and Groups
Understanding Security Settings
Default Folder Structure
Current Classroom Folder Structure
Adding Groups and Users
Adding Groups to Reporting Services
Adding Users
Auditing and Management Reports
Execution Log Reports
Server Management Reports
Installing Auditing and Management Reports
Deploying the Auditing and Management Reports
Deploy Sample Reports to Report Server
Create a Database for Report Execution Data
Configure and Run the Job Package
Run the Sample Reports

Building Report Models

Understand the Report Model Architecture
Creating a Report Model Project
Creating a Report Model Data Source
Creating a Data Source View
Modifying the Data Source View
Toolbar
Diagram Pane
Diagram Organizer Pane
Tables Pane
Creating a Report Model File
Report Model Generation Rules
Model Statistics
Understanding the Model Designer
Model Designer Layout
Entities
Attributes
Identifying Field
Roles
Entity and Field Folders
Perspectives
Deploying a Report Model

Using Report Builder

Understanding Report Builder
Launching Report Builder
Report Builder Design Layout
Getting Started Pane
Report Toolbar
Explorer Pane
Design Area
Building a Table Report
Adding Fields to the Table Data Region
Report Groupings
Previewing a Report
Formatting
Report Filters
Clickthrough Reports
Saving a Report
Building a Matrix (Cross-tab) Report
Creating Formulas
Creating a Chart Report
Parts of the Chart
Chart Types
Chart Options