Maintaining, Troubleshooting, and Developing Solutions with Microsoft SQL Server 2008 Reporting Services

COURSE OUTLINE:

Description

In this instructor-led course, you will learn to implement a ReportingServices solution in an organization. You will learn how to use the ReportingServices development tools to create reports and how to use the ReportingServices management and administrative tools to manage a Reporting Servicessolution.

This course incorporates material form the Official Microsoft LearningProduct 6236: Implementing and Maintaining Microsoft SQL Server 2008 ReportingServices.

Global Knowledge Exclusive!

Continue developing your skills after class with 24/7 access to our live remote labs for six months providing you with valuable extra time for hands-on practice.

Audience

IT professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services

Prerequisites

  • Exposure to creating reports in Microsoft Access or other third-partyreporting products, such as Crystal Reports
  • Conceptual understanding of the push and pull distribution/subscriptionparadigm
  • Experience navigating the Microsoft Windows Server environment
  • Experience with Windows services (starting and stopping)
  • Experience creating service accounts and permissions
  • Experience with Microsoft SQL Server, including:
    • SQL Server Agent
    • SQL Server query language (SELECT, UPDATE, INSERT, and DELETE)
    • SQL Server System tables
    • SQL Server accounts (users and permissions)
  • Course 6182: Implementing and Managing SQL Server 2008

Learning Objectives

  • SQL Server Reporting Services and its components
  • Create a Reporting Services report
  • Enhance a Reporting Services report
  • Create dynamic reports
  • Create and manipulate data sets
  • Use report models to implement reporting for business users
  • Configure report publishing and execution settings
  • Implement subscriptions for reports
  • Administer Reporting Services
  • Implement custom Reporting Services applications
  • Retrieve data from external data sources
  • Optimize and troubleshoot Reporting Services
  • Integrate Reporting Services with SharePoint 2007

1. Introduction to Microsoft SQL Server Reporting Services

  • Overview of SQL Server Reporting Services
  • Installing Reporting Services
  • Reporting Services Tools

2. Authoring Basic Reports

  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values

3A. Enhancing Basic Reports

  • Interactive Navigation
  • Displaying Data
  • Expressions
  • Using Parameters as Content
  • Changing Report Structure with Parameters

3B. Exclusive - Dynamic Reports

  • More with expressions
  • Displaying Parameters
  • Dynamic Report Structure

4. Manipulating Data Sets

  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists

5. Using Report Models

  • Creating Report Models
  • Using Report Builder

6. Publishing and Executing Reports

  • Publishing Reports
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History

7. Using Subscriptions to Distribute Reports

  • Introduction to Report Subscriptions
  • Creating Report Subscriptions
  • Managing Report Subscriptions

8. Administering Reporting Services

  • Reporting Server Administration
  • Performance and Reliability Monitoring
  • Administering Report Server Databases
  • Security Administration
  • Upgrading to Reporting Services 2008

9A. Programming Reporting Services

  • Adding Code to Reports
  • Querying for Server Information Using a Web Service
  • Automating Report Management
  • Rendering Reports
  • Creating Custom Code

9B. Exclusive - Adding Custom Code to a Report

  • Adding Code to a Report
  • Using a Custom Code Assembly

10. Exclusive - External Data

  • Accessing Remote SQL Server Data
  • Connecting to Other Data Sources
  • Implementing Analysis Services

11. Exclusive - Optimizing and Troubleshooting

  • Optimizing the SSRS environment
  • Troubleshooting the SSRS environment

12. Exclusive - Integrating with Microsoft Office SharePoint Server 2007

  • Introduction to SharePoint 2007
  • SharePoint Integrated Mode
  • Configuring SharePoint for Reporting Services
  • Deploying Reports to SharePoint
  • Managing and Viewing Reports
  • Integrating Reports into Dashboards