• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Publishing to the Web > Adding a Pivot Table to a Page

Adding a Pivot Table to a Page

Pivot tables (see Chapter 11), are powerful tools that allow your users to display your data in the manner that best meets their needs. While they're neat tools to play with, the real benefit of pivot tables is that you don't have to anticipate your users'needs. In other words, with pivot tables users can manipulate and filter your data as they see fit.

To add a pivot table to a data access page:

1.
In Design view, open your data access page.

2.
Click the Field List toolbar button to bring up the Field List dialog box.

3.
Open the list of tables (or queries) and click the table or query you want to use as the base for your pivot table and click Add to Page.

The Layout Wizard appears ( Figure 13.27 ).

Figure 13.27. The Layout Wizard lets you add the fields from your table or query to your pivot table.


4.
Click the Pivot Table List option button and click OK.

The table or query appears as a pivot table in your data access page.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint