SQL Server 2005 Reporting Services

This course has been superseded

We suggest the following instead:
SQL Server Reporting Services

Course Description

In this course, participants will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. Participants will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. Participants will explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. Participants will explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. Participants will gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. Participants will also discover how to integrate reports into your ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, participants will learn how to create ad-hoc reports using Report Builder and Report Model projects. <BR> <BR> <a href='/it_training/database_microsoft_sql.htm'> Click here for other MS SQL Courses</a> <BR>
3 days
Contact us for pricing
 

Prerequisites

Familiarity with databases and the SQL language. Knowledge of SQL Server, Visual Studio .NET/2005, C# or VB helpful, but not required.

Introducing SQL Server Reporting Services

Tour of Features
Reporting Services Architecture and Terminology
Reporting Services Editions
Taking Reporting Services for a Spin

Creating Reports

Deconstructing Reporting Services
Shared Data Sources
Creating Reports from Scratch

Calculations and Formatting

Creating Expressions
Using the Global Collections
Formatting Items
Conditional Formatting

Grouping and Sorting

Creating Groups
Calculating Totals and Percentages
Interactive Sorting
Creating Drill-Down Reportss

Report Parameters

Creating Report Parameters
Creating Drop-Down Parameters
Multi-Valued Parameters
Debugging Parameter Issues

Creating Matrix Reports and Charts

Creating a Basic Matrix Report
Matrix Subtotals
Creating a Basic Chart
Exploring the Charting Possibilities

Managing Reporting Services

Deploying Reports and Data Sources
Exporting Reports and Printing
Using the Web-Based Report Manager
Using SQL Server Management Studio-based Reporting Services Manager

Reporting Services Security

Two Parts to Reporting Services Security
Securing Access to Reports
Data Source Security

Programming Reporting Services

The Many Reporting Services APIs
Integrating Reporting Services into Applications using URL Access
Using the Report Viewer Controls

Advanced Reporting Services Programming

Using the Reporting Services Web Service
Working with Custom Assemblies

Snapshots and Subscriptions

Caching and Snapshots
Creating Standard Subscriptions
Creating Data-Driven Subscriptions
Managing Subscriptions

Ad-Hoc Reporting with Report Builder

The Report Builder Architecture
Creating Report Model Projects
Running Report Builder
Reporting ServicesSQL ServerSQL Server 2005