• Article

Hands On Lab: Building Your First Relational Report with SQL Server 2008 R2 Reporting Services

Version: 1.0

Description

This Hands On Lab covers how to design a SQL Server 2008 R2 Reporting Services Report that summarizes sales, calculates commissions, and uses custom logic to compute sales commission values.

Overview

This lab will explore the report authoring cycle from project creation, to shared data source creation, report design and deployment.

Objectives

The objectives of this exercise are to:

  • Create and configure a Reporting Services project
  • Create a SQL Server shared data source
  • Create datasets
  • Configure parameters
  • Develop a matrix report
  • Configure a sparkline

System Requirements

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

Setup

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

Note:
To perform the setup steps you need to run the scripts in a command window with administrator privileges.

  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 database, 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. Authoring the Sales Summary Report

Estimated time to complete this lab: 30 minutes.

next >

Downloads

Download The Offline Training Kit
Download Hands-on Lab Document (DOCX)
Download Hands-on Lab Source Files

Contents