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 6

By William Pearson

15.  Click the Captions tab.

16.  Change the caption to read Sr Manager.

17.  Make the Font Arial, Bold and Indigo.

The Commands and Options dialog - Captions tab appears, with our changes, as shown in Illustration 21.

Illustration 21: The Commands and Options Dialog - Captions Tab

18.  Close the Commands and Options dialog, leaving all other setpoints as before.

The result set in the PivotTable List should resemble that shown in Illustration 22.

Illustration 22: The Pivot Table List - After Formatting Modifications

Formatting virtually any PivotTable List component is just this simple. We simply need to remember that changing formats for any member of a group (in our case, labels) changes all members of the group simultaneously.

19.  Click the Pivot Table Field List toolbar button to display the PivotTable Field List.

20.  Drag the Employee Salary measure (under Totals in the tree) to the Total or Detail fields drop area, dropping it to the immediate right of the Count measure label.

21.  Right-click the Employee Salary label and select Commands and Options from the context menu.

The Commands and Options dialog appears for the Employee Salary measure.

22.  Change the caption (Captions tab) to read Salary (000), to make the Employee Salary measure perhaps a bit more meaningful to anyone reviewing the PivotTable List.

23.  Select Currency as the Number format (Format tab).

24.  Close the Commands and Options dialog.

25.  Save the PivotTable List by clicking the Save button on the top toolbar, or by choosing File -` Save.

26.  Click to the left side of the PivotTable List, causing the cursor to flash on its left.

27.  Press Enter to move the PivotTable List down.

28.  Click in the space above the PivotTable List.

29.  Type the following text:

Headcount and Salary: Location, Department and Employees

30.  Format to taste.

(I used Verdana 18-pt Bold, and aligned the title and PivotTable List with the Center button in the FrontPage toolbar.)

31.  Save the PivotTable List, leaving it open for the remainder of the lesson.

NOTE: Always remember to save any time changes are made in design mode, to ensure that the changes are retained.

32.  Click the Preview tab to see a PivotTable List that should resemble (in all material respects) the one shown in Illustration 23.

Illustration 23: The Pivot Table List - Final View

The majority of the browser functionality that is available to information consumers from our newly designed PivotTable List is based upon our saved efforts from the design mode. We will see even more how this is true in the following section.

Far more innovation can be undertaken with the PivotTable List, and there are many more nuances to explore. I hope that the exercises above will serve as a good navigational introduction, and as a jumpstart to further exploration.

Let's conclude this lesson with a final discussion surrounding how to make functionality available to information consumers, and how to restrict what they can accomplish within the scope of the PivotTable List design.

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