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

Once you have selected the Table layout, you will notice that the design window displays a base
report with one column. You want to start building your report based on the Product Category, Product
Subcategory, and Product Name hierarchy. Start at the lowest level of the hierarchy and work your way
up. English Product Name is the lowest level of detail required, so you start with that field. Select the
Dim Product node from the Explorer window. This will refresh the fields list with all the attributes of
Product. Select English Product Name from the list and drag it onto the table in the design window.
Figure 9-3 illustrates adding the Product Name field.
Now that English Product Name has been added to the report, you should notice a change in the
Explorer window as shown in Figure 9-4. Selecting the Product Name field told the Report Builder that
you were going to use the Product entity for this report. The change in the Explorer window shows all
of the related entities to Product. In this model, Product Subcategory and Reseller Sales have a direct
relationship to product.
The next step in building the report is the addition of Product Subcategory and Product Category. You
are moving from the lowest level of detail to the highest, so your next field will be English Product
Subcategory. To add the field, select the English Product Subcategory node from the Explorer window.
This should change the field list to display Product Subcategory attributes. Select English Product
Subcategory Name and drag it to the left of Product Name, as illustrated in Figure 9-5.
Figure 9-3