Corporate HomeCorporate ProfileWorldwide OfficesSolutions At WorkEmployment  
LRS Education Services
LEARN  >  Find a Class  >  Class Summary

RS-2005 - Microsoft SQL Server 2005 Reporting Services

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com
The purpose of this course is to teach the Reporting Solutions Architecture. Students will go through the entire reporting solutions process. In this course students will author, deploy and learn to maintain Reporting Services in a variety of business scenarios. The target audience is intended to be SQL Server 2000/2005 administrators or developers who need to understand best practices for planning, implementing and deploying a Reporting Services solution.
Click here for a printer-friendly version of this page
 
Contact us for class availability


Prerequisites

Must be familiar with Creating Transact-SQL queries Creating Views, Tables, Stored Procedures and Indexes SQL Server Management Studio 2005, Visual Studio 2005 Courses MS2779 and MS2780 or equivalent knowledge
 
Detailed Class Syllabus


Chapter 1: Let's Start at the Very Beginning
  • Reporting Services

  • Authoring Architecture

  • Report Server Architecture


    • Chapter 2: Putting the Pieces in Place: Installing Reporting Services
  • Installation Preparation

  • Installation Process

  • Report Server Configuration Manager

  • Installation Issues


    • Chapter 3: DB 101: Database Basics
  • Database Structure

  • Querying Data

  • Report Introduction


    • Chapter 4: A Visit to Emerald City: The Report Wizard
  • Creating List Reports

  • Creating an Interactive Table Report

  • Creating Matrix Reports

  • Passing Report Parameters


    • Chapter 5: Removing the Training Wheels: Building Basic Reports
  • Basic List Reports

  • Data Regions

  • Additional Report Elements


    • Chapter 6: Graphic Expression: Using Charts and Images in Reports
  • Charts in reports

  • Images in reports

  • Formatting reports


    • Chapter 7: Kicking It Up a Notch: Intermediate Reporting
  • Using Report Templates

  • Handling Errors

  • Data Caching

  • Viewing the RDL

  • Using Visual SourceSafe


    • Chapter 8: Beyond Wow: Advanced Reporting
  • Visual Basic .NET code

  • Reports within Reports

  • Interactive Reports

  • Converting Access Reports


    • Chapter 9: A Leading Exporter: Exporting Reports to Other Rendering Formats
  • Exporting and Printing a Report

  • Presentation Formats

  • Data Exchange Formats


    • Chapter 10: How Did We Ever Manage Without You? The Report Manager
  • Folders

  • Moving Reports and Supporting Files to the Report Server

  • Moving Items in Folders

  • Search and Find Functions

  • Printing Options

  • Security

  • Linked Reports


    • Chapter 11: Delivering the Goods: Report Delivery
  • Setting up Report Caching

  • Execution Snapshots

  • Report History

  • Subscriptions

  • Site Settings

  • Style Sheets


    • Chapter 12: Extending Outside the Box: Customizing Reporting Services
  • Using Reporting Services without Report Manager

  • Customizing Security

  • Best Practices
    •
     
    Microsoft Partner Gold LearningPrometricEC-Council
    Microsoft Certified ProgramsAdditional Certification Courses