|
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.
- Overview of Microsoft SQL Server Reporting Services
- Tour of Reporting Services
- Overview of Reporting Services Architecture
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.
- Creating a Basic Table Report
- Formatting Report Pages
- Calculating Values
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.
- Interactive Navigation
- Displaying Data
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.
- Defining Report Data
- Using Parameters and Filters
- Using Parameter Lists
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.
- Publishing Content
- Executing Reports
- Creating Cached Instances
- Creating Snapshots and Report History
- Creating Report Subscriptions
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.
- Server Administration
- Performance and Reliability Monitoring
- Database Administration
- Security Administration
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.
- Querying Server Information
- Automating Report Management
- Rendering Reports
- Creating Custom Code
|