Click Add ...
to the right of the Rows list, in the upper half of the tab, as shown in
Illustration 9: Adding a
New Group ...
and Sorting Properties dialog appears, defaulted to its General tab.
Atop the General
tab, replace the default entry that appears in the Name box with the
Click the currently
empty top row in the Expression list within the Group on section
of the tab, to enable the selector.
within the selector, as depicted in Illustration 10.
Illustration 10: Selecting
a Group On Expression for a New Group ...
to accept our selection, and to close the Grouping and Sorting Properties dialog.
return to the Groups tab, where we see the new matrix1_Product entry
(currently highlighted) within the Rows list, underneath the originally appearing
matrix1_Sales_Reason group, as shown in Illustration 11.
Illustration 11: Two Row
Groups Appear in the Groups Tab
on the Groups tab, to close the Matrix Properties dialog.
wider report layout appears, as expected.
Once again on
the Layout tab, within the Matrix Data Region, right-click the
value appearing underneath the Internet Orders column heading (the leftmost
of the three value cells).
on the context menu that appears, as depicted in Illustration 12.
Modifying Properties for the Count Value ...
On the Textbox
Properties dialog that next appears, click the Format tab.
existing Format code setting (in the upper left corner of the Format
tab) with the following string:
we are simply changing the existing format to one more appropriate for a count
value. The Format code appears on the Format tab of the Textbox
Properties dialog as shown
in Illustration 13.
Replacing the Existing Format Code ...
to accept our modifications, and to dismiss the Textbox Properties dialog.
We will next
execute the report to ascertain that our modifications are complete, and that
we have a working report for the practice session that follows.
Click the Preview
tab, as depicted in Illustration
Illustration 14: Click
the Preview Tab to Execute the Report
in the Product Category parameter selector, as shown in Illustration 15.
Illustration 15: Select
Bikes in the Parameter Selector ...
Click the View
Report button, as required.
is being generated message briefly appears, and then the report
displays. The modified report appears as partially depicted in Illustration
Illustration 16: The
Modified Report (Partial View)
have a clone OLAP report file within our Reporting Services 2005 Project,
with which we can proceed in the next section to add the navigation support
that our client colleagues need, using the Document Map feature.