Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services
Unfiled
Program Outline
Module 1: Introduction to Microsoft SQL Server Reporting Services
The information in this module introduces the role Reporting Services plays in an organization s reporting lifecycle the key features offered by Reporting Services and the components that make up the Reporting Services architecture.
Lessons
No Lab
After completing this module students will be able to:
Module 2: Authoring Basic Reports
In this module students learn about the fundamentals of report authoring including how to configure data sources and data sets create tabular reports summarize data and apply basic formatting.
Lessons
Lab 2: Designing a Simple Report
After completing this module students will be able to:
Module 3: Enhancing Basic Reports
This module introduces some techniques for enhancing a basic report using document maps actions and data regions. Document maps provide navigation through a contents page actions provide a mechanism for creating custom actions (jumping from one report to another for example) and data regions allow data to be displayed in formats such as a matrix or a list.
Lessons
Lab 3: Enhancing a Simple Report
After completing this module students will be able to:
Module 4: Manipulating Data Sets
In this module data sets are covered in greater depth including the use of alternative data sources and interacting with a data set through parameters. Student will learn how to dynamically modify the data set underlying a data region allowing parameters to be sent to the underlying query. This module presents various best practices for dealing with static and dynamic parameter lists when interacting with stored procedures.
Lessons
Lab 4: Manipulating Data Sets
After completing this module students will be able to:
Module 5: Managing Content
This module introduces the management of content in the Reporting Services database. The module discusses the process of deploying reports together with the various mechanisms that can be used in deployment. Students learn about the report execution models supported by Reporting Services including the caching of report instances. Finally students learn about using subscriptions for report delivery.
Lessons
Lab 5: Managing Content
After completing this module students will be able to:
Module 6: Administering Reporting Services
This module introduces the administration of the Reporting Services server the administration of individual jobs and the administration of the database. In this module students will learn how to administer the Reporting Services server monitor and optimize the performance of the Report Server maintain the Reporting Services databases and keep the system secure.
Lessons
Lab 6: Administering Reporting Services
After completing this module students will be able to:
Module 7: Programming Reporting Services
This module introduces the programmatic control of Reporting Services. In this module students will learn how to query Reporting Services information programmatically and how to automate their report management tasks. They will also learn how to render reports without relying on Report Manager and how to create custom code to extend the feature set of the Report Server.
Lessons
Lab 7: Programming Reporting Services
After completing this module students will be able to:
Related Exams
No Microsoft Certified Professional exams are associated with this course currently.
Student Pre-Requisites
Before attending this course students must have:
Student Materials
The student kit includes a comprehensive workbook and other necessary materials for this class.
