Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted May 6, 2003

Reporting Options for Analysis Services Cubes: MS FrontPage 2002 - Page 5

By William Pearson

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

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM