In this seminar, you will first learn how to create SSRS projects

and reports in Business Intelligence Development Studio (BIDS). You will also see how to

develop report objects by using the Report Designer and how to work with advanced report

object properties. You will then see how to use a SQL Server Analysis Services (SSAS)

database as the source for your report. And last, after looking at how to create a dataset

from a data source, you will learn how to apply dataset filters and groups.

Seminar objectives:

Implement report data sources and datasets.

Implement a report layout.

Create an SSRS report by using an SSAS data source.

Implement interactivity in a report.

Implement report items.

Step 1: Creating SSRS Projects and Reports in BIDS

Understanding the SSRS Report Templates

Using the Report Wizard

Modifying Project Properties

Modifying Report-Level Properties

Developing Report Objects with the Report Designer

Adding Report Objects to a Report

Practice: Creating and Modifying a Report

Step 2: Creating a Dataset from a Data Source

Creating a New Report Dataset

Working with an SSAS-Based Dataset

Practice: Creating Report Datasets

Step 3: Working with Advanced Report Object Properties

Toggling Object Visibility

Defining Report Actions

Adding Bookmarks

Practice: Modifying Advanced Report Object Properties

Step 4: Applying Dataset Filters and Groups

Assigning Datasets to Data Regions

Applying Filters, Groups, and Sorts to Data Regions

Applying Aggregates to Data Regions

Practice: Creating Advanced Data Regions

This seminars series based on Microsoft Certification Training Kit for

Exam 70-448: Microsoft SQL Server 2008 - Business Intelligence Development and

Maintenance

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits)