Microsoft Office Tutorials and References
In Depth Information
20.7.13 ServerBased Property
This read-only property returns the amount of memory currently being used by the PivotField (it
also applies to PivotItem objects) as a Long integer.
20.7.13 ServerBased Property
This read-write Boolean property applies to page fields only and is used with (generally very large)
external data sources. It is True when the PivotTable's data source is external and only the items
matching the page-field selection are retrieved.
By setting this property to True , the pivot cache (discussed later in the chapter) needs to
accommodate only the data for a single page field. This may be important, or even necessary,
when the external data source is large. The trade-off is that each time the page field is changed,
there may be a delay while Excel requeries the original source data to retrieve data on the new
page field.
Note that there are some circumstances under which this property cannot be set to True :
The field is grouped.
The data source is not external.
The cache is used by more than one PivotTable.
The field has a data type that cannot be server-based (such as a memo field or an OLE
20.7.14 ShowAllItems Property
This read-write Boolean property is True if all items in the PivotTable are displayed. The default
value is False , in which case the pivot items that do not contribute to the data fields are not
displayed. Note that this property corresponds to the "Show items with no data" check box on
Excel's PivotTable Field dialog box.
To illustrate, suppose we add a single row to our source table:
1998 1 BO-1 BOSTON AStoreType 1000 $10000.00
This row creates a new store type but adds data only for Boston. The resulting pivot table will
have the default appearance shown in Figure 20-35 . Since ShowAllItems is False , there are no
rows for the new store type corresponding to Los Angeles or New York.
Figure 20-35. ShowAllItems = False
Search JabSto ::

Custom Search