SQL Server 2005 Reporting Services

Reporting Services Introduction

• Reporting Services Architecture
• Reporting Services usage scenarios
• Report authoring

Reporting Services Introduction

• Reporting Services Architecture
• Reporting Services usage scenarios

Report authoring

• Authoring basics
• Configuring data sources and datasets
• Grouping, filtering and sorting
• Formatting tips and tricks

Using data regions to create advanced reports

• Using multiple data regions in reports
• Fixed and freeform data regions

Manipulating datasets

• Using report parameters and query parameters
• Using recursive relationships in reports
• Using data from an OLAP Cube in a report

Building a managed reporting environment

• Introduction to Report Manager
• Publishing and deploying reports
• On-demand and subscription reports

Administering Security

• Reporting Services security model overview
• Item and system security with role assignments
• Securing the data within a report

Administering Reporting Services Components

• Using configuration files with Report Server
• Managing and logging report executions
• Administering Report Server databases

Programming Reporting Services

• When do you need to code?
• Retrieving Reporting Services information with code
• Rendering reports in a specific format
• Using the code to administer reports