Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

• Module 1: Introduction to Microsoft SQL Server Reporting Services The students will be introduced to 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. Lessons Lesson 1: Overview of SQL Server Reporting Services Lesson 2: Installing Reporting Services Lesson 3: Reporting Services Tools Lab: Introduction to Microsoft SQL Server Reporting Services Exercise 1: Exploring Report Designer Exercise 2: Exploring Report Manager Module 2: Authoring Basic Reports The students will learn the fundamentals of report authoring, including configuring data sources and data sets, creating tabular reports, summarizing data, and applying basic formatting. Lessons Lesson 1: Creating a Basic Table Report Lesson 2: Formatting Report Pages Lesson 3: Calculating Values Lab: Authoring Basic Reports Exercise 1: Creating a Basic Table Report Exercise 2: Formatting Report Pages Exercise 3: Adding Calculated Values Module 3: Enhancing Basic Reports The students will learn about navigational controls and some additional types of data regions, and how to use them to enhance a basic report. Lessons Lesson 1: Interactive Navigation Lesson 2: Displaying Data Lab: Enhancing Basic Reports Exercise 1: Using Dynamic Visibility Exercise 2: Using Document Maps Exercise 3: Initiating Actions Exercise 4: Using a List Data Region Exercise 5: Creating a Tablix Report Exercise 6: Adding Chart Subreport to Parent Report Module 4: Manipulating Data Sets The students will explore 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 will learn how to dynamically modify the data set underlying a data region by allowing parameters to be sent to the underlying query, as well as will learn to use best practices to implement static and dynamic parameter lists when interacting with queries and stored procedures. Lessons Lesson 1: Defining Report Data Lesson 2: Using Parameters and Filters Lesson 3: Using Parameter Lists Lab: Manipulating Data Sets Exercise 1: Using Parameters to Restrict Query Results Exercise 2: Using Parameters to Filter Report Data Exercise 3: Creating Dynamic Parameter Lists Exercise 4: Using Parameters with a Stored Procedure Exercise 5: Displaying All Categories in a Parameter List Module 5: Using Report Models The students will learn how to create a report model so that business users can create their own reports without using the full Report Designer development environment. Students will also learn how to use Report Builder to create a report from a report model. Lessons Lesson 1: Creating Report Models Lesson 2: Using Report Builder Lab: Using Report Models Exercise 1: Creating a Report Model Exercise 2: Using Report Builder to Create a Report Module 6: Publishing and Executing Reports The students will learn the various options you can use to publish reports to the report server and execute them. Lessons Lesson 1: Publishing Reports Lesson 2: Executing Reports Lesson 3: Creating Cached Instances Lesson 4: Creating Snapshots and Report History Lab: Publishing and Executing Reports Exercise 1: Publishing Reports Exercise 2: Executing Reports Exercise 3: Configuring and Viewing a Cached Report Exercise 4: Configuring and Viewing a Sna

Meer informatie?

Gerelateerde cursussen

In dezelfde cursusgroep bieden wij óók onderstaande opleidingen aan: