Reporting Options for Analysis Services Cubes: MS FrontPage 2002 - Page 5
May 6, 2003
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:
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).
Note that we may receive the warning message shown in Illustration 18, depending upon the environment in which we are developing.
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.
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.