> Nearby Locations
Des Moines
515-226-3265
 
 
 
My Account  |  View Cart
Search:
 


Class Outline*

| Request Info | Contact Us

Building Effective Reports using Microsoft Report Builder 2.0

Duration:
2 Days

Overview:
In this two-day, instructor-led course, you'll learn how to build richly formatted, dynamic reports using Microsoft Report Builder 2.0.  Delivering high-quality, on-demand data allows for flexible reporting and equips key decision makers with the information needed to properly assess their options and improve outcomes.  The ability to view and analyze timely, accurate data about core business activities is paramount to the success of any organization.  Learn how to use the many tools in Microsoft Report Builder 2.0 to provide this valuable information in a format far exceeding Excel spreadsheets.

Objectives:

After completing this course, students will be able to:

·         Create a Reporting Services report.

·         Enhance reports using dynamic visibility, report maps and initiating actions

·         Use each of the data regions including Tables, List, Chart, Matrix and Gauge

·         Create and manipulate data sets.

·         Use report models to build reports

·         Publish Reports to Various Destinations

Audience:

This course is intended for Business Users and IT professionals supporting business users who need to create ad hoc reports or reports for distribution through SQL Server Reporting Services using Report Builder 2.0.

Prerequisites:

Before attending this course, students should have:

·         An understanding of relational databases.

·         Exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports.

·         Experience navigating the Microsoft Office environment.

·         SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).

 

Outline:

Module 1: 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: Getting familiar with Report Builder 2.0
  • Lesson 2: A review of relational databases
  • Lesson 3: Creating a Basic Table Report
  • Lesson 4: Formatting Report Pages
  • Lesson 5: Calculating Values

Lab: Authoring Basic Reports

  • Exercise 1 (Level 200): Creating a Basic Table Report
  • Exercise 2 (Level 200): Formatting Report Pages
  • Exercise 3 (Level 200): Adding Calculated Values

After completing this module, students will be able to:

  • Create a basic table report.
  • Format report pages.
  • Calculate values for a report.

Module 2: 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: (Level 200) Using Dynamic Visibility
  • Exercise 2: (Level 200) Using Document Maps
  • Exercise 3: (Level 200) Initiating Actions
  • Exercise 4: (Level 200) Using a List Data Region
  • Exercise 5: (Level 200) Creating a Tablix Report
  • Exercise 6: (Level 200) Adding Chart Subreport to Parent Report

After completing this module, students will be able to:

  • Create reports with interactive navigation.
  • Display data in various formats.

Module 3: 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: (Level 200) Using Parameters to Restrict Query Results
  • Exercise 2: (Level 200) Using Parameters to Filter Report Data
  • Exercise 3: (Level 200) Creating Dynamic Parameter Lists
  • Exercise 4: (Level 200) Using Parameters with a Stored Procedure
  • Exercise 5: (Level 200) Displaying All Categories in a Parameter List

After completing this module, students will be able to:

  • Define report data.
  • Use parameters and filters.
  • Use parameter lists.

Module 4: Using Report Models and Publishing Reports

The students will learn how to create a report using a Report Model.

Lessons

  • Lesson 1: Creating Report Models (Demo only)
  • Lesson 2: Creating a Report Using a report Model
  • Lesson 3: Publishing Reports to SQL Server Reporting Services
  • Lesson 4: Export Reports in different rendering formats.

*Content, days, and times vary depending on your location. Please view the outline prior to purchase or contact the local center for more information.