Polishing
Our Design in FrontPage 2002
As report developers,
regardless of the medium in which we develop any given report, we should keep focused
on the fact that the lion's share of achieving success in reporting from OLAP
data sources rides heavily on two elements:
-
The collection of the correct
data components; and
-
The intersection of those
components to define the precise values needed by information consumers to meet
their reporting requirements.
One obvious benefit of
building the PivotTable List from scratch via the FrontPage 2002 design
environment is that any enhancements or other modifications we make will be
saved in the HTML file. Another benefit is the capability that FrontPage 2002
provides us to preview your work as it will appear in a browser, at any time
during the design process. Let's try that now.
1.
Click the Preview tab at
the lower-left corner of the PivotTable List we just saved (see Illustration
17 below).
Illustration 17: Select
the Preview Tab in FrontPage 2002
Note that
we may receive the warning message shown in Illustration 18, depending
upon the environment in which we are developing.
Illustration 18: Warning
Message, with Instructions re: Avoiding Same in the Future
2.
Click Yes to bypass the
message for now (and if it appears again at any point in this lesson), and to
close the message box.
We arrive at the Preview
screen, seeing the PivotTable List just as we would from a browser, in most
respects. We can click various selectors and make various on-the-fly
modifications, and so forth, to the PivotTable List in the Preview
environment. We need to keep in mind, however, that, to make our modifications permanent,
and to retain them in the HTML file we created earlier, design changes need to
be made on the Normal (design
mode) tab, and then saved.
3.
Click the Normal
tab to return to design mode.
4.
Right-click the Level 03
label.
5.
Click Collapse Items in
the context menu that appears.
6.
Right-click the Level 02
label.
7.
Click Collapse Items in
the context menu that appears.
8.
Right-click the Level 01
label.
9.
Click Collapse Items in
the context menu that appears.
10.
Right-click the Derrick
Whelply member of the Senior Management column, and select Filter
by Selection.
As we see in Illustration
19 below, the Filter by Selection action narrows the scope of the PivotTable
List to Whelply and his direct reports.
Illustration 19: Filtering
by Selection to Narrow Scope Easily
11.
Right-click the Senior
Management label.
12.
Select Commands and Options
on the context menu.
The Commands and
Options dialog appears.
13.
Click the Format tab, if
necessary.
14.
Change the Font to Arial
Narrow, with a Color of Indigo.
NOTE: Indigo is the color selection to the furthest
right, in the top row of the color palate - the tool tip that appears when we
touch the color swatch shows the name of the color.
The Commands and
Options dialog - Format tab appears, with our changes, as shown in Illustration
20.
Illustration 20: The
Commands and Options Dialog - Format Tab
» 
Comment and Contribute
