Reporting Services - Professional SQL Server Analysis Services 2005 with MDX - page 914

Figure 17-33
4. Switch to the Layout tab to design your report. Add a list report item
with Grouping/Sorting option as Calendar Year similar to the report
you designed in the previous section. Add a table item within the list
item. Right-click on one of the rows and select Insert Group to add a
new group within the table. In the Grouping/Sorting dialog select
Model Name and disable group header. Disable the table footer by
right-clicking on a row and selecting Table footer. Drag and drop
Model Name to the group footer row as shown in Figure 17-34 . Drag
and drop Product Name and Fact Internet Sales - Unit Price fields to
the second and third columns in the detail row as shown in Figure
17-34 . Drag and drop Fact Internet Sales - Unit Price to the last
column of the group footer row as shown in Figure 17-34 . You will
notice that Report Designer automatically adds the aggregate func-
tion Sum for the measure Fact Internet Sales - Unit Price as shown
in Figure 17-34 . Drag and drop the Calendar Year field above the
table and change BackgroundColor, Color, and FontWeight for table
header and group footer rows as shown in Figure 17-34 .