Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
SQL Server 2005: Reporting Services
with Paul Litwin


View the Course Outline

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.

Course includes 27+ hours of total training time...

  • 8 modules of training
  • Over 9 hours of media run time
  • Over 500 pages of printable courseware
  • Step-by-step hands-on-labs
  • Sample code
Format Sessions Retail Price
SQL Server 2005: Reporting Services
CD-ROM

 8 CD-ROMs

$695.00  
CD-ROM & Books

 8 CD-ROMs + Printed Books

$791.00  
DVD-ROM

 1 DVD-ROMs

$695.00  
DVD-ROM & Books

 1 DVD-ROMs + Printed Books

$791.00  
Read about Paul Litwin .
Course Outline (Outlines are subject to change.)
SQL Server 2005: Reporting Services

Sessions Run Time Pages
8 9 hours 500

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.



In this course, you will...
  • Create complex reports employing expressions, the global collections, and conditional formatting.
  • Create reports with nested groups and multiple parameters.
  • Manage reports using both the browser-based Report Manager and SQL Server Management Studio-based Report Manager.
  • Secure reports using integrated security and SSL.
  • Program reports using URL Access, the Reporting Services Web Service API, the Report Viewer controls, and custom assemblies.
  • Employ report caching and create report snapshots.
  • Create standard and data-driven report subscriptions.
  • Empower users to create ad-hoc reports using Report Builder and the models you create using Report Model projects.
Prerequisites :

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

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

back to top


Your Instructor

Paul Litwin
is a developer specializing in ASP, ASP.NET, Visual Basic, C#, SQL Server, and related technologies. Paul is a programming manager with Fred Hutchinson Cancer Research Center in Seattle. He is also the owner of Deep Training, a developer owned training company specializing in .NET developer training (www.deeptraining.com). Paul has authored a number of books including ASP.NET for Developers (SAMS) and Access 2002 Enterprise Developer’s Handbook (SYBEX) and has written articles in a variety of magazines, including MSDN Magazine and PC World. Paul is the conference chair of Microsoft ASP.NET Connections, a Microsoft MVP, and a member of the INETA Speakers Bureau.

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy