the Report's Row Axis to Align to Business Requirements
that the information consumers requested, among other changes, that we modify
the report to display Product Name in the rows of the report. After
removing the drilldown levels that previously existed, we left the report's Matrix
Properties dialog with a single group, BrandSales_Brand_Name,
although we knew that this was not the field that we ultimately wished to group
upon, nor to display. My reasoning here was to leave the group in place, and
then return to modify it, and re-point it to the Product Name field
(which did not exist in the Dataset, anyway, until several steps after our
modification of the groups).
return to the Groups tab of the Matrix Properties dialog to make
the first of two final modifications to the report.
Click the Layout tab to
return to the Layout of the report.
Click at some
point within the label textbox of the report (containing the label Foodmart
Sales), as we did earlier, to make the row and column headers of the matrix
data region visible.
the upper left corner of the matrix, once again.
from the context menu that appears.
Properties dialog opens, defaulted to the General tab.
Click the Groups
Click the single
entry in the Rows list, BrandSales_Brand_Name, to select it.
and Sorting dialog opens.
current text in the Name box, BrandSales_Brand_Name, to the
In the top row
of the Group on list, select the following expression:
The Grouping and Sorting dialog, containing our modified
input, appears as depicted in Illustration 52.
Illustration 52: The
Modified Row Group
to accept changes, and to return to the Groups tab of the Matrix
The Groups tab appears as shown in Illustration 53.
Illustration 53: The
Renamed Row Group Appears
to close the Groups tab, together with the Matrix Properties
dialog, and to return to the Layout tab.
the textbox containing the current row definition, currently shown as =Fields!Brand_Name.Value,
from the context menu that appears, as depicted in Illustration 54.
Illustration 54: Selecting
the Textbox Defining the Row Display for Modification
Expression dialog opens.
existing expression in the Expression pane of the dialog with the
following (you might also select it from the tree on the left):
The Edit Expression dialog appears
as shown in Illustration 55.
Illustration 55: Edit Expression
Dialog, with our Replacement
Click OK to accept our replacement,
and to close the Edit Expression dialog.