23.
Click the BrandSales_Product_Category
field (second from the top in the Rows list) to select it.
24.
Click the Delete
button to delete the group.
25.
Click the BrandSales_Product_Subcategory
field (currently the middle entry in the Rows list) to select it.
26.
Click the Delete
button to delete the group.
27.
Click the BrandSales_Brand_Name
field (currently the bottom entry in the Rows list) to select it.
28.
Click the Delete
button to delete the group.
29.
Click the BrandSales_Quarter
field (currently the middle entry in the Columns list) to select it.
30.
Click the Delete
button to delete the group.
The Groups tab
appears, after our deletions, as depicted in Illustration 37.
31.
Click the BrandSales_Product_Department
group (now the only entry in the Rows list) to select it.
32.
Click Edit.
The Grouping
and Sorting Properties dialog for the group opens to the General tab.
33.
Type the
following into the Name box on the General tab, replacing the
existing name:
StoreName.
34.
Select Fields!Store_Store_Name.Value
within the dropdown selector of the Expression list, in the Group
on section.
The Grouping and Sorting Properties dialog appears as shown in Illustration 38.
Illustration
38: The Grouping and Sorting Properties Dialog with Our Changes
35.
Click OK to accept
changes and close the Grouping and Sorting Properties dialog for the StoreName
group.
36.
Click OK to accept
changes, and to close the Matrix Properties dialog, and to return to the
Layout view in Report Designer.
Only a few minor
changes remain to prepare the report for its new uses.
37.
Right-click the textbox
underneath the report title, currently displaying =Fields!Product_Department.Value.
38.
Select Properties from
the context menu that appears, as depicted in Illustration 39).
Illustration
39: Select Properties from the Context Menu ...
The Textbox Properties dialog opens.
39.
Replace the
contents of the Name box with the following:
StoreName.
40.
Click the Function button
("fx") to the right of the Value box.
The Edit Expression
dialog appears.
41.
Replace the contents of the Expression
pane (the right half of the dialog) with the following expression:
= Fields!Store_Store_City.Value & " - " & Fields!Store_Store_Name.Value
The Edit Expression dialog appears as shown in Illustration 40.
Illustration
40: Edit Expression Dialog with Our Modifications
42.
Click OK to accept
changes and return to the Textbox Properties dialog, which appears as
depicted in Illustration 41.
Illustration 41:
Textbox Properties Dialog
43.
Click OK to close the Textbox
Properties dialog.
44.
Click the textbox under the Store
Cost label in the Matrix, as shown in Illustration 42, to
select it.
Illustration
42: Targeting Store Cost for Elimination ...
45.
Touch the Delete key.
Store Cost disappears from the report.
46.
Click the textbox under the Store
Profit label in the Matrix, as depicted in Illustration 43,
to select it.
Illustration
43: Targeting Store Profit for Deletion ...
47.
Touch the Delete key.
Store Profit disappears from the report. The Multi-Layer_Calculations
report, Layout view, appears as shown in Illustration 44.
Illustration
44: The Multi-Layer_Calculations Report - Layout View
We
need to complete a final "cleanup" step before executing the report.
48.
Right-click
the Store_Profit calculated field in the Fields list.
49.
Select Delete
from the context menu that appears, as depicted in Illustration 45.
Illustration 45: Deleting
the Store_Profit Calculated Field
This
removes the calculated field, which is no longer relevant to our report, from
the list.
50.
Click the Preview tab to
execute the modified report.
The Multi-Layer_Calculations
report appears as shown in Illustration 46.
Illustration 46:
Multi-Layer_Calculations, Reflecting Our Modifications
The
report's layout has been altered sufficiently to meet the layout requirements
as expressed by the information consumers. We are now ready to insert the calculated
member that we created in the cube earlier.
» 
Comment and Contribute
