SQL Server 2005 Reporting Services (SSRS) Training (4 days)

SQL Server 2005 Reporting Services (SSRS) Training Overview

In this SSRS training 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 also 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.

SQL Server 2005 Reporting Services (SSRS) Training Course Goals

• Learn to create reports using SQL Server 2005 Reporting Services.
• Learn to format reports.
• Learn to create Matrix reports and charts.
• Learn to manage report services.
• Learn about SQL Server Reporting Services security features.
• Learn to create distributed reports.
• Learn to program Reporting Services.
• Learn to create ad-hoc reports with Report Builder.

SQL Server 2005 Reporting Services (SSRS) Training Course Prerequisites

Experience in the following areas is required:

• Basic relational database concepts
• Basic SQL experience

Experience in the following areas would be beneficial.

• SQL Server
• Visual Studio .NET
• C# or VB.NET

SQL Server 2005 Reporting Services (SSRS) Training Course Outline

1. Introducing SQL Server Reporting Services
   1. Tour of Features
   2. Reporting Services Architecture
   3. Reporting Services Terminology
   4. Reporting Services Editions
   5. Taking Reporting Services for a Spin
2. Creating Reports
   1. Deconstructing Reporting Services
   2. Shared Data Sources
   3. Creating Reports from Scratch
3. Calculations and Formatting
   1. Reporting Services Items
   2. Basic Expressions
   3. Using the Global Collections
   4. Using Custom VB Code in Reports
   5. Formatting Fields
   6. Conditional Formatting
4. Grouping and Sorting
   1. Creating Groups
   2. Interactive Sorting
   3. Creating Drill-Down Reports
   4. Calculating Totals and Percentages
5. Report Parameters
   1. Creating Report Parameters
   2. Binding Report Parameters to Dataset Parameters
   3. Creating Drop-Down Parameters
   4. Multi-Valued Parameters
   5. Debugging Parameter Issues
6. Creating Matrix Reports and Charts
   1. Creating a Basic Matrix Report
   2. Matrix Subtotals
   3. Creating a Basic Chart
   4. Exploring the Charting Possibilities
   5. Charting Add-ons
7. Managing Reporting Services
   1. Using the Web-Based Report Manager
   2. Using SQL Server Management Studio-based Reporting Services Manager
   3. Deploying Reports and Data Sources
8. Reporting Services Security
   1. Reporting Services Security
   2. Managing Roles
   3. Data Source Security
9. Distributing Reports via Subscriptions
   1. How Subscriptions Work
   2. Creating Standard Subscriptions
   3. Creating Data-Driven Subscriptions
   4. Managing Subscriptions
10. Reporting Services Tips and Tricks
    1. Creating Mailing Label Reports
    2. Creating Mail Merge Documents
    3. Adding Multiple Regions to a Report
11. Ad-Hoc Reporting with Report Builder
    1. The Report Builder Architecture
    2. Creating Report Model Projects
    3. Running Report Builder

SQL Server 2005 Reporting Services (SSRS) Training Course Materials

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

SQL Server 2005 Reporting Services (SSRS) Training Technical Requirements

1. Internet Information Services
   • Instructions
2. Microsoft SQL Server 2005 with SP2
   • Download - Full installation (including all services) required of developer or enterprise edition.
3. Microsoft SQL Server Sample Databases
   • Download - Choose AdventureWorksDBCI.msi and AdventureWorksLT.msi.
   1. After downloading the sample databases, execute the MSI files by double-clicking on them.
   2. You must now attach the databases. You can do this in Microsoft SQL Server Management Studio:
      1. Open Object Explorer
      2. Right-click on the Databases folder and select "Attach"
      3. In the dialog that appears, click "Add..."
      4. In turn, navigate to and select each of the newly installed MDF files (probably in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).
      5. Click OK. The dialog should close and you should see the new databases listed under the Databases folder
   3. Click here if you need more detailed instructions.

Class Files for SQL Server 2005 Reporting Services (SSRS) Training

The class files for this course are included on a DVD that is shipped with the manual.