Detail

MSSQL Server 2005: Implementing and Maintaining SQL Server 2005 Reporting Services (SSRS) Module 1: Introduction to Microsoft SQL Server Reporting Services * This module introduces the role that Reporting Services plays in an organization�s reporting life cycle, the key features offered by Reporting Services, and the components that make up the Reporting Services architecture. Overview of SQL Server Reporting Services * Installing Reporting Services * Reporting Services Tools Module 2: Authoring Basic Reports * This module introduces the fundamentals of report authoring, including configuring data sources and data sets, creating tabular reports, summarizing data, and applying basic formatting. Creating a Basic Table Report * Formatting Report Pages * Calculating Values Module 3: Enhancing Basic Reports * This module introduces navigational controls and some additional types of data regions, and discusses how to use them to enhance a basic report. Interactive Navigation * Displaying Data Module 4: Manipulating Data Sets * This module explores data sets to a greater depth, including the use of alternative data sources and interacting with a data set through the use of parameters. Students learn how to dynamically modify the data set underlying a data region by allowing parameters to be sent to the underlying query. They also learn to use best practices to implement static and dynamic parameter lists when interacting with queries and