Implementing SQL Server 2008 Reporting Services Solutions

This course is included in our On-demand training solution.


SQL Server 2008 Reporting Services provides powerful and flexible solutions for enterprise reporting needs. This course introduces the reporting services functionality, tools, installation, and enhancements provided by SQL Server 2008. It outlines the fundamental tasks involved in authoring a basic report and explores the features available to customize and enhance report functionality. This includes understanding the Report Definition Language used with reports, the types of report objects and items that can be added to reports, defining and manipulating data sources and datasets, and formatting the appearance of reports. The course also covers the use of parameters and filters in manipulating report data sets, as well as the addition of user interactivity features such as drilldowns, document maps, and sorting. The course also discusses how the functionality of reports can be extended through the incorporation of expressions and custom code assemblies. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.

Target Audience

IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer


Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience in performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio

Expected Duration

180 min.

Course Objectives

Introducing SQL Server Reporting Services

  • recognize what SQL Reporting Services is used for
  • Deploying Reporting Services

  • install Reporting Services
  • configure Reporting Services
  • Authoring SQL Server 2008 Reports

  • recognize how to author SQL Server reports
  • Report Pagination and Creation with SQL Server 2008

  • format reports in SQL Server 2008
  • Dataset Manipulation in SQL Server 2008 Reports

  • recognize how to filter data in SQL Server 2008 reports
  • Incorporating Report Interactivity with SQL Server 2008

  • add interactivity to reports
  • Expressions and Custom Code in SQL Server 2008 Reports

  • add expressions to reports
  • add custom code in reports
  • Creating and Modifying a Report with SQL Server 2008