current position within the Data tab, select Report -> Report Parameters from the main
menu of the design environment, as shown in Illustration 9.
Illustration 9: Select Report -> Report Parameters from the Main Menu
sole Report Parameter (ProductCategory) listed within the Parameters
pane of the Report Parameters dialog, which appears next.
to delete the ProductCategory Report Parameter, as depicted
in Illustration 10.
Illustration 10: Click
Remove to Delete the Parameter ...
to accept our removal of the Report Parameter, and to dismiss the Report
completes our modifications to the report from the Data tab. We will
execute the query for the remaining dataset, once more, to ascertain that all
is in working condition.
Click the Execute
Query button (!) in the toolbar, as we did earlier, to run the query
pane is populated once more, and appears as partially shown in Illustration
Illustration 11: The
Result Pane is Populated (Partial View)
will now transit to the Layout tab, where we will wrap up our
Click the Layout
Click the left
value textbox within the Matrix data region, which contains =Sum(Fields!Internet_Order_Quantity.Value), and whose Background Color is
Press the Delete
key on the keyboard, to delete the Internet Order Quantity measure (depicted in Illustration 12), along with the column containing
it, from the matrix.
Illustration 12: Deleting
the Internet Order Quantity Measure ...
column disappears, leaving two remaining columns.
Click the right
value textbox remaining within the Matrix data region, which
contains =Sum(Fields!Internet_Total_Product_Cost.Value), and whose Background Color is
Transparent (and for which,therefore, the White background color
Press the Delete
key on the keyboard, to delete the Internet Total Product Cost calculated value, along with the column containing
it, from the Matrix,
as we did for the measure before.
modified Matrix data region, now presenting a single measure column,
appears on the Layout tab as shown in Illustration 13.
Illustration 13: The
Modified Data Region
we will modify grouping within the Matrix data region.
Click a point
within the Matrix data region, to give it the focus, and to cause its
gray handles to appear.
the upper left-hand corner of the Matrix data region (the gray square).
gray column and row bars disappear, as a light, patterned outline forms around
the Matrix data region, and the context menu appears.
from the context menu, as
depicted in Illustration 14.
Illustration 14: Select
Properties from the Context Menu ...
The Matrix Properties dialog appears, defaulted to the
Click the Groups tab.
In the Columns section
of the Groups tab (in the lower half of the tab), select the middle
group, named matrix1_Sales_Territory_Group.
Click the Edit button,
as shown in Illustration 15.
15: Editing the Matrix1_Sales_Territory_Group Column Group ...
and Sorting Properties dialog appears, defaulted to its General tab.
Atop the General
tab, change the existing Name to the following:
Click the row
containing the Expression value (currently the expression is Fields!Sales_Territory_Group.Value),
within the Group on list, to enable the selector.
within the selector, as depicted in Illustration 16.
Replacing the Existing Group Expression ...
to accept our modifications, and to close the Grouping and Sorting Properties dialog.
on the Groups tab, to close the Matrix Properties dialog.
Once again on
the Layout tab, within the Matrix data region, right-click the
textbox appearing above the Internet Sales column heading (it currently
contains the expression =Fields!Sales_Territory_Group.Value).
on the context menu that appears, as shown in Illustration 17.
Illustration 17: Modifying
Properties for the Column Value ...
On the Textbox Properties
dialog that next appears (defaulted to the General tab), change the
existing Name to the following:
Within the Value
selector, modify the existing expression to the following:
within the Textbox Properties dialog General tab, appear as
depicted in Illustration 18.
18: Our Modifications within the Textbox Properties Dialog General Tab
Click OK to
accept our modifications, and to close the Textbox Properties dialog.
execute the report, at this point, to ascertain that our modifications are
complete, and that we have a working report for the practice session that
Click the Preview
is being generated message briefly appears, and then the report displays.
The modified report appears as shown in Illustration 19.
Illustration 19: The
report is now ready for the practice session, which we will begin in the next