Hands On Lab: Building and Sharing Your First Report Builder 3.0 Report

This Hands On Lab will show you how to build your first Report Builder 3.0 report to perform self-service reporting, and how to share it with SQL Server 2008 R2 Reporting Services and SharePoint 2010.

Overview

This lab will author two reports using Report Builder 3.0. In the first exercise, you will create a report by using the Table Wizard. You will then create and configure a report parameter for this report. Next, you will publish the report parameter and main dataset as report parts.

In the second exercise, you will create a report by using the Map Wizard. The map analytic data will reference the shared dataset published in the first exercise. You will then introduce the report parameter published in the first exercise.

Objectives

The objectives of this exercise are to:

• Use Report Builder 3.0 to:
  • Create a report using the Table Wizard
  • Publish report parts
  • Create a report using the Map Wizard
  • Introduce report parts into a report

System Requirements

You must have installed the following items to complete this lab:

• Microsoft SQL Server 2008 R2:
  • Database Engine
  • Reporting Services (Native mode)
• SQL Server AdventureWorks2008 R2 sample databases
  • AdventureWorksDW2008R2
• Microsoft SQL Server 2008 R2 Report Builder 3.0

Setup

All the requisites for this lab are verified using the Configuration Wizard. To make sure that everything is correctly configured, follow these steps.

1. Launch the Configuration Wizard for this lab by double-clicking the Dependencies.dep file located under the Source\Setup folder of this lab. Install any pre-requisites that are missing (rescanning if necessary) and complete the wizard.

Cleanup

1. There is no need to cleanup if you intend to continue the sequence of labs in this training kit.
2. To restore the original state of the AdventureWorksDW2008R2 SQL Server database and remove the Reporting Services content, execute the Cleanup.cmd script located under the Setup folder in the Source folder of this lab.

Exercises

This Hands-On Lab comprises the following exercise:

1. Creating a Report Using the Table Wizard
2. Creating a Report Using the Map Wizard

Estimated time to complete this lab: 30 minutes.