HBFITES Data Center, Collaboration, Security, Storage, Wireless, Telepresence Training +91-9886770046 info@hbfites.com

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

Course Details

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.

Course 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

Course Agenda

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. 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. Adding Custom Code to a Report

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

10. External Data

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

11. Optimizing and Troubleshooting

  • Optimizing the SSRS environment
  • Troubleshooting the SSRS environment

12. 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