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 2

By William Pearson

Introduction to the Office PivotTable List

While multiple options exist for creating a PivotTable List, one of which involves starting by creating a PivotTable Report in Excel (complete with data source setup), and then transforming it into a PivotTable List, we will focus upon the design and creation of a PivotTable List "from scratch" in this lesson. We will use FrontPage 2002 as the application from which we can not only to read the PivotTable List (just as a browser would), but from which we can also design and/or edit the PivotTable List and apply our changes for immediate effect. Microsoft FrontPage 2002, which is included in the Premium Edition of Office XP, (and is sold separately, and is available in other ways), is well suited to the purpose of creating PivotTable Lists due to its integration with Office XP.

Designing in FrontPage 2002

Let's start FrontPage 2002, and set about the PivotTable List design process.

1.      Click the Start button.

2.      Select Programs -` FrontPage 2002.

FrontPage 2002 opens, and a new, blank page appears. (If not, simply click the "New" button to create a new page).

3.      Choose Insert from the top menu.

4.      Select Web Component, as shown in Illustration 1.

Illustration 1: Select Web Component

The Insert Web Component selection dialog appears.

5.      Under Component Type (left pane of the dialog), click Spreadsheets and Charts.

6.      From the Choose a Control options that appear in the right pane, select Office PivotTable as shown in Illustration 2 below.

Illustration 2: Selecting the Office Pivot Table Control

7.      Click Finish to enact our selections.

The empty Office PivotTable List appears in the new page, as shown in Illustration 3.

Illustration 3: The Empty PivotTable List

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