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

To finish the Product hierarchy, click on the Product Category node in the Explorer and add the English
Product Category Name field to the left of Product Subcategory Name. You can also repeat these steps to
add Total Sales Amount and Total Order Quantity from the Fact Reseller Sales as Product node. Figure
9-6 illustrates the finished layout.
Notice that Report Builder recognized the hierarchy between Product Name, Product Subcategory, and
Product Category. Based on the hierarchy, it created subtotals for each of the levels. You might have
noticed that the English Product Name total is unnecessary since it is the lowest level of detail. There are
a number of formatting improvements that you can make. After discussing the different types of layouts,
you will come back to formatting your reports. For now, save this report as “Table Layout Product Sales.”
Click on the Save button in the application toolbar to save the report. Clicking the Save button will pre-
sent a list of folders located on the Report Server. Reports from the Report Builder are always saved on
the Report Server. Saving reports to the Report Server requires publish permissions. Required permis-
sions are covered later in this chapter.
Now that you have created a basic Table report, you will look at the next layout option, Matrix.
Figure 9-6