A couple of months ago I finished writing and recording a great new set of self-paced videos on SQL Server 2005 Reporting Services in a partnership with AppDev. A few notes on the course:

  • Over 9 hours of media run time
  • Over 500 pages of printable courseware, but if you prefer we can provide a nicely bound version of the coursebook for a nominal extra charge.
  • Step-by-step hands-on-labs for each module.
  • Lots of sample code

The deal: you can buy the class directly from AppDev or you can buy it from me (or more correctly my training company Deep Training) at a nice 40% discount. (Yes, since I am the course's author I was able to negotiate a great discount so that I could resell the courseware to Deep Training customers). If you are interested, check out the outline (below) and go here to learn a bit more and possiblly purchase the course.

The course outline:

 Introducing SQL Server Reporting Services

  • Tour of 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
  • 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
  • Paul