Microsoft SQL Server 2008: Reporting Services

Course Overview

Attendees will learn how to use the Reporting Services development tools to create reports, and additionally how to use the Reporting Services management and administrative tools. Concise coverage of the subject matter is augmented with plenty of hands on exercises to facilitate the learning process and to enable students to quickly gain confidence in using Reporting Services.

CourseMonster only uses quality Microsoft training suppliers who have been through our rigorous standards to ensure that you receive the best quality training available.

Related Courses

• Microsoft SQL Server 2008 New Features: Hands-On
• Microsoft SQL Server 2008 Comprehensive Introduction: Hands-On
• Microsoft SQL Server 2008: Database Administration
• Microsoft SQL Server 2008 Training Course UK: Comprehensive DBA & Programming Upgrade
• Microsoft SQL Server 2008 Analysis & Integration Services (SSAS & SSIS) - (Business Intelligence, BI, Data Warehouse, Mining)
• Microsoft SQL Server 2008 Reporting Services (SSRS) - (Business Intelligence, BI)
• Microsoft SQL Server 2008: Business Intelligence with SQL Server 2008 - (Microsoft, BI, SSRS, SSAS, SSIS, Data Warehouse, Mining)
• Microsoft SQL Server 2008: Maintaining a Microsoft SQL Server 2008 Database
• Microsoft SQL Server 2008 Reporting Services: Hands-On
• Microsoft SQL Server 2008: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Audience

This course is intended for students who need to learn how to implement a Reporting Services solution.

Skills Gained

Upon successful completion of this course, students will be able to:

• Understand where SQL Server Reporting Services fits in with the Business Intelligence paradigm
• Install Reporting Services
• Understand the Reporting Services architecture
• Create a Report
• Enhance Reports
• Work with Data Sets
• Implement Report Models
• Use the Report Builder 2.0 application to create reports
• Set up report publishing and execution settings
• Distribute reports with subscriptions
• Administer Reporting Services
• Implement the Report Viewer control

Prerequisites

Delegates should have:

• An understanding of working in a Microsoft Windows operating system environment.
• Some experience working with relational databases.
• Knowledge gained from taking the 2 day course 'Microsoft SQL Server 2008 Introduction to Querying' or equivalent SQL language experience.

Course Outline

1. Introduction to SQL Server 2008 Reporting Services

• Overview of Reporting Services

2. Installing Reporting Services

• Standard Installations (Native Mode) of Reporting Services
• Installation Prerequisites and Considerations

3. Reporting Services Architecture

• The Reporting Life Cycle
• Reporting Services Tools
• Reporting Services Web Service
• Reporting Services Windows Service
• Reporting Services Processors and Extensions
• Reporting Services Application Databases

4. Authoring Reports

• Introduction to Report Designer and BIDS
• Creating a Basic Table Report
• Formatting Report Pages
• Including Calculated Values

5. Enhancing Reports

• Dynamic Visibility
• Document Maps
• Initiating Actions
• Using a List Data Region
• Creating a Tablix Report
• Adding a Chart Subreport

6. Working with Data Sets

• Using Parameters to Restrict Query Results
• Using Parameters to Filter Report Data
• Creating Dynamic Parameter Lists
• Using Parameters with a Stored Procedure
• Displaying All Categories in a Parameter List

7. Report Models

• Creating Report Models
• Using Report Builder 1.0

8. Using Report Builder 2.0

• Introduction to Report Builder 2.0
• Modifying an Existing Report
• Creating Parameterised Reports
• Column Groups and Document Maps
• Using Subreports
• Linked Reports
• Drill Through Reports
• Authoring a Report from XML Data
• Creating Tabular and Matrix Reports with Report Models
• Creating Reports from Analysis Services Cubes

9. Publishing and Executing Reports

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

10. Distributing Reports with Subscriptions

• Introduction to Report Subscriptions
• Creating a Standard Subscription
• Creating a Data Driven Subscription
• Managing Report Subscriptions

• 11. Reporting Services Administration
• Administering the Reporting Server
• Performance and Reliability Monitoring
• Administering the Report Server Databases
• Security Administration

12. Programming Reporting Services

• Using URL Access to Display a Report
• Automating Report Management
• Rendering Reports
• Using the Report Viewer Control