Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

SQL Server 2005 Reporting Services

3 day course

View Detailed Outline in PDF Format
Get Adobe Reader

In this course, you will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports.  You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio.  You'll 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.  You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats.  You'll gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies.  You'll 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, you'll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects.

Course Topics:

(for a full detailed outline, visit our PDF link above)

Intro to SQL Server Reporting Services

  • Features
  • Reporting Services architecture
  • Reporting Services 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 reports

Report Parameters

  • Creating report parameters
  • 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

  • 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