40.
Click the Add
button, as depicted in Illustration 19.
Illustration 19: Adding
a New Row Group
The Grouping
and SortingProperties dialog reappears, defaulted to its General
tab, as before.
41.
Atop the General
tab, change the default Name to the following:
matrix1_Cal_Qtr
42.
Click the row
containing the Expression value (currently the expression is blank) within
the Group on list, to enable the selector.
43.
Select =Fields!Calendar_Quarter.Value
within the selector.
The Grouping
and SortingProperties dialog appears, with our input, as shown in Illustration 20.
Illustration 20: The
Grouping and Sorting Properties Dialog with Our Input
44.
Click OK,
to accept our modifications, and to close the Grouping and SortingProperties dialog.
45.
Click the
Add button, once again.
The Grouping
and SortingProperties dialog appears, once again.
46.
Atop the General
tab, change the default Name to the following:
matrix1_Cal_Month
47.
Click the row
containing the Expression value (currently the expression is blank)
within the Group on list, to enable the selector.
48.
Select =Fields!Month.Value
within the selector.
The Grouping
and SortingProperties dialog appears, with our input, as depicted in Illustration 21.
Illustration 21: The
Grouping and Sorting Properties Dialog with Our Input
49.
Click OK,
to accept our modifications, and to close the Grouping and SortingProperties dialog.
50.
Click the
Add button, once again.
The Grouping
and SortingProperties dialog reappears.
51.
Atop the General
tab, change the default Name to the following:
matrix1_Cal_Date
52.
Click the row
containing the Expression value (currently the expression is blank)
within the Group on list, as before, to enable the selector.
53.
Select =Fields!Date.Value
within the selector.
The Grouping
and SortingProperties dialog appears, with our input, as shown in Illustration 22.
Illustration 22: The
Grouping and Sorting Properties Dialog with Our Input
54.
Click OK,
to accept our modifications, and to close the Grouping and SortingProperties dialog.
The Group
tab reappears, with our input, as depicted in Illustration 23.
Illustration 23: The
Grouping Tab with the New Groups
55.
Click OK
on the Groups tab, to close the Matrix Properties dialog.
We are
returned to the Layout view.
56.
Once again on
the Layout view, right-click the leftmost textbox of the Matrix value
row (which currently contains the “=Fields!Sales_Reason.Value”).
57.
Select Expression ... on the
context menu that appears, as shown in Illustration 24.
Illustration 24: Editing the Existing
Value Expression ...
The Expression
Editor opens.
58.
Replace the
expression in the upper portion of the Editor with the following:
=Fields!Calendar_Year.Value
The
intent is to label the column to reflect the nature of the Group we have
put in place: Years instead of Sales Reasons.
59.
The Expression
Editor appears, with our modification, as depicted in
Illustration 25.
Illustration 25: The
Expression Editor with Our Substitution in Place
60.
Click OK
to accept our modification, and to dismiss the Expression Editor.
Since the
report no longer deals with Sales Reasons, we will eliminate the Sales
Reason heading label.
61.
Right-click
the textbox (containing the title Sales Reason), immediately above the
box for which we changed the expression to “=Fields!Calendar_Year.Value.”
62.
Select Delete
on the context menu that appears, as shown in Illustration 26.
» 
Comment and Contribute
