Report Builder - Professional SQL Server 2005 Reporting Services - page 372

Before you build your report, you need to decide what type of layout is appropriate. In the Report
Layout window, you are presented with three options:

❑ Table

❑ Matrix

❑ Chart

Let's take a look at creating reports with three different layout types.

Table Layout
To understand the table report layout, you will create a simple report that shows Products in the hierar-
chy (Product Category, Product Subcategory, Product Name) with their associated Sales Amount and
Order Quantity. This will build a base around working with related data as well as aggregated values.

To start, select the Adventure Works DW Model and Table layout from the Getting Started window (see
Figure 9-2).

Figure 9-2