Now,
only a few minor cleanup items remain in our preparation sequence.
63.
Right-click
the value field underneath the column label Internet Orders. The value
displayed in the box is “=Sum(Fields!Internet_Order_Quantity.Value)”).
64.
Click Properties
from the context menu that appears, as depicted in
Illustration 27.
Illustration 27: Editing
the Value Field Properties ...
65.
On the Textbox
Properties dialog that next appears, click the Format tab.
66.
Replace the
existing Format code setting (in the upper left corner of the Format
tab) with the following string:
#,###
Here
we are simply changing the existing format to one that is more appropriate for
a count value. The Format code appears on the Format tab of the Textbox
Properties dialog as shown
in Illustration 28.
Illustration 28:
Replacing the Existing Format Code ...
67.
Click OK
to accept our modification, and to dismiss the Textbox Properties dialog.
Now
let’s reset a couple of basic layout dimensions to make the report a bit more
compact.
68.
Select all
four row group columns, by clicking them, one after another, with the SHIFT
key depressed.
69.
In the Properties
pane, set the Width for the columns to 1.00, as depicted in Illustration 29.
Illustration 29: Modifying
the Widths for the Four Selected Columns ...
70.
Click inside
the report body to enact the new Width setting.
The
selected columns immediately contract as expected.
71.
Click inside
the Matrix, once again, to cause its handles to appear.
72.
Click the
handles for the bottom two rows of the matrix, to highlight / select
both rows.
73.
Set the Font
Size (in the toolbar above the development environment) for the selected
rows to 8pt, as shown in Illustration 30.
Illustration 30: Setting
Font Size for the Bottom Two Rows of the Matrix ...
The font
adjusts immediately within the affected rows.
74.
In a similar
manner, click the handle for the row immediately above the bottom two rows we have
just modified (and the second row from the top of the Matrix), to
highlight / select it.
75.
Assign a Font
Size of 10pt to the selected row.
76.
Click the top
report heading, which bears the words “Adventure Works Cycles,” to
select the textbox involved.
77.
Assign the
textbox a Font
Size of 12pt, as depicted in Illustration 31.
Illustration 31: Setting
the Font Size for the Primary Report Heading
As a
final piece of housekeeping, we will name the four textboxes reflecting the row
groups we have added. We will then reference one of these names in our
concluding preparatory step, where we set visibility for the Date
column.
78.
Right-click
the leftmost textbox of the Matrix value row (the textbox whose contents
we modified to “=Fields!Calendar_Year.Value” in an earlier step of this
section).
79.
Select Properties on the
context menu that appears.
The Textbox
Properties dialog opens, defaulting to the General tab, as we saw earlier.
80.
Replace the existing
Name (“Sales_Reason_1”) in the upper portion of the Editor
with the following:
Calendar_Year
The Textbox
Properties dialog appears, with our modification, as shown in Illustration 32.
Illustration
32: The Textbox Properties Dialog – General Tab, with Our Substitution in
Place
81.
Click OK
to accept our modification, and to dismiss the Textbox Properties dialog.
82.
Right-click
the textbox to the immediate right of the one we have just renamed “Calendar_Year.”
83.
Select Properties on the
context menu that appears.
84.
Replace the
existing Name (“textbox4” or similar), atop the Textbox
Properties dialog – General tab that next appears, with the
following:
Calendar_Quarter
85.
Click OK
to accept our modification, and to dismiss the Textbox Properties dialog.
86.
Right-click
the textbox to the immediate right of the one we have just renamed “Calendar_Quarter.”
87.
Select Properties on the
context menu that appears.
88.
Replace the
existing Name (“textbox5” or similar), atop the Textbox
Properties dialog – General tab that next appears, with the
following:
Calendar_Month
89.
Click OK
to accept our modification, and to dismiss the Textbox Properties dialog.
We
will now return to the Matrix Properties dialog to make our last
preparatory settings.
90.
Right-click
the upper left-hand corner of the Matrix data region (the gray square),
once again.
NOTE: If the handles for the Matrix data region are not
visible, click somewhere within the region to cause them to appear, so as to
enable the step above.
The
gray column and row bars disappear, as the outline that we saw earlier forms
around the Matrix data region.
91.
Select Properties
on the context menu that appears, as we did earlier.
The Matrix
Properties dialog appears, defaulted to the General tab, once again.
92.
Click the
Groups tab.
93.
In the Rows
section of the Groups tab (in the upper half of the tab), select the
matrix1_Cal_Date entry (the bottom row group in the list).
94.
Click the
Edit button, once again.
The Grouping
and Sorting Properties dialog appears.
95.
Click the Visibility
tab.
96.
On the Visibility
tab, click the radio button labeled Hidden, to select Initial
visibility of Hidden.
97.
Place a check
in the checkbox labeled “Visibility can be toggled by another report item.”
98.
In the
selector labeled Report item, which becomes enabled upon checking the
above, select Calendar_Month, as depicted in Illustration 33.
Illustration
33: Select Calendar Month as the Toggle Point for Calendar Date
99.
Click OK
to accept our modification, and to dismiss the Grouping and Sorting Properties dialog.
100.
Click OK
on the Groups tab, to close the Matrix Properties dialog.
We are
returned to the Layout tab. We will execute the report to ascertain
that our modifications are complete, and that we have a working report for the
practice session that follows.
101.
Click the Preview
tab, as shown in Illustration 34.
Illustration 34: Click
the Preview Tab ...
The Report
is being generated message briefly appears, and then the report displays.
102.
Click the “+”
sign to the left of January 2002 (which is at the right of Q1 CY
2002, near the top of the report), to ascertain that the Visibility setting
behaves as expected.
The
modified report, complete with the sample expanded Calendar Month, appears
as partially depicted in Illustration 35.
Illustration 35: The
Modified Report (Partial View)
Our non-parameterized,
non-filtered report is now ready for the practice session, which we will begin
in the next section.
» 