PivotTable

Class name

PivotTable

Purpose / Description

This class contains the properties and methods directly related to the pivot table.

Sub-Classes

• Columns
• DataSource
• Localization
• Rows

Methods

• Init
• ShowPivot

Properties

• Aggregator
• AggregatorField
• Control
• DisplayIn
• IsInteractive
• RendererName
• SaveHtmlFileForDebugging
• WebBrowserActiveX
• WebBrowserControl

Detailed description

The following sections contain a detailed description of the properties and methods.

Aggregator

Description:

Name of the function which is applied to the pivottable.

Default value:

Count

Sample code:

Set myPivot.Aggregator = "Sum"

Related to:

AggregatorField

AggregatorField

Description:

Name of the field on which the function is applied.

Default value:

--

Sample code:

Set myPivot.AggregatorField = "ExtendedPrice"

Related to:

Aggregator

Control

Description:

This property is write only.
This property accepts an object and assigns that control to the appropriate property according to its type.

Default value:

--

Sample code:

Set myPivot.Control = Me.ctlWebbrowser

Related to:

WebBrowserActiveX, WebBrowserControl

DisplayIn

Description:

Here you can specify where the pivot table is shown. The following values are available:

• chWebBrowserControl
• chWebBrowserActiveX
• chSystemBrowser

Default value:

chWebbrowserControl

Sample code:

myPivot.DisplayIn = chDisplayIn.chWebbrowserControl

Related to:

ShowPivot, Control

Init

Description:

This method is called by via the BAPT__Factory, when a new instance of BAPT_PivotTable is created

Parameters

• WebBrowserControl

Sample code:

myPivot.Init Me.ctlBrowser

Related to:

--

IsInteractive

Description:

With this property you can specify if the pivot table is interactive.

In an interactive pivot table the user can interact with the data.

If the pivot table is not interactive the data is only shown and cannot be rearranged.

Default value:

True

Sample code:

myPivot.IsInteractive= True

Related to:

--

RendererName

Description:

Specifies how the pivotable is rendered.

Default value:

Table

Sample code:

Set myPivot.RendererName = "Heatmap"

Related to:

---

SaveHtmlFileForDebugging

Description:

When set to true the html string is saved in a file for debugging.
Path: Current Project
Filename: BetterAccessChart_{WebBrowserControlName}.html

Default value:

False

Sample code:

myPivot.SaveHtmlFileForDebugging = True

Related to:

--

ShowPivot

Description:

Calling this method creates the pivot table and displays it in the control specified via "DisplayIn" property.

Sample code:

myPivot.ShowPivot

Related to:

DisplayIn

WebBrowserActiveX

Description:

In this property you pass a reference to the web browser activex control in which the pivot table is to be displayed.
By setting this property the value for the property DisplayIn is set to "chWebBrowserActiveX".

Default value:

--

Sample code:

Set myPivot.WebBrowserActiveX= Me.ctlWebbrowserActiveX

Related to:

DisplayIn, Control, WebBrowserControl

WebBrowserControl

Description:

In this property you pass a reference to the web browser control in which the pivot table is to be displayed.
By setting this property the value for the property DisplayIn is set to "chWebBrowserControl".

Default value:

--

Sample code:

Set myPivot.WebBrowserControl= Me.ctlWebbrowser

Related to:

DisplayIn, Control, WebBrowserActiveX