Pivot Object (ExPivot) | Exontrol Docs

The Exontrol's eXPivot tool is our approach to provide data summarization, as a pivot table. A pivot-table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. The user sets up and changes the summary's structure by dragging and dropping fields graphically.

The control can load data using one of the following methods:

Import method, loads data from a CSV file or from specified text.
DataSource property, assigns an ADO/DAO record set to be loaded.
LoadXML method, loads an XML file previously saved using the SaveXML method

The AppendData method appends data to the control (prevents clearing data already loaded).

The following properties may be used to group and summarize the data, once it is loaded:

PivotRows property specifies the list of DATA columns that determines the first column in the control's list. In other words, the Group-By columns
PivotColumns property specifies the list of DATA columns that determines the rest of the columns to be displayed on the control's list
PivotTotals property specifies the list of total/sub-total functions to be displayed on the control's list.

The Pivot object supports the following properties and methods:

		Name	Description
		Aggregates	Retrieves the Aggregates collection of the pivot control.
		AllowDrop	Gets or sets a value indicating whether the control can be used as the target of a drag-and-drop operation.
		AllowSelectNothing	Specifies whether the current selection is erased, once the user clicks outside of the items section.
		AnchorFromPoint	Retrieves the identifier of the anchor from point.
		Appearance	Retrieves or sets the control's appearance.
		AppendData	Appends data to the control (prevents clearing data already loaded).
		AttachTemplate	Attaches a script to the current object, including the events, from a string, file, a safe array of bytes.
		AutoDrag	Gets or sets a value that indicates the way the component supports the AutoDrag feature.
		BackColor	Specifies the control's background color.
		BackColorAlternate	Specifies the background color used to display alternate items in the control.
		BackColorHeader	Specifies the header's background color.
		Background	Returns or sets a value that indicates the background color for parts in the control.
		BeginUpdate	Maintains performance when items are added to the control one at a time. This method prevents the control from painting until the EndUpdate method is called.
		BorderHeight	Sets or retrieves a value that indicates the border height of the control.
		BorderWidth	Sets or retrieves a value that indicates the border width of the control.
		CheckImage	Retrieves or sets a value that indicates the image used by cells of checkbox type.
		ClearData	Removes the control's data.
		ClearFilter	Clears the filter.
		CollapseAll	Collapses all rows.
		ColumnAutoResize	Returns or sets a value indicating whether the control will automatically size its visible columns to fit on the control's client width.
		ColumnFromPoint	Retrieves the column from the point.
		Copy	Copies the control's content to the clipboard, in the EMF format.
		CopyTo	Exports the control's view to an EMF file.
		DataColumnFromPoint	Retrieves the index of the data column from the point.
		DataColumns	Retrieves the Data Columns collection of the pivot control.
		DataSource	Retrieves or sets a value that indicates the data source for object.
		DefaultColumnWidth	Retrieves or sets a value that indicates the default column width.
		DefaultItemHeight	Retrieves or sets a value that indicates the default item height.
		Description	Changes descriptions for control objects.
		DisplayFilterList	Specifies what the column's filter displays.
		DisplayPivotData	Retrieves or sets the maximum number of rows to be displayed on the control's list.
		DisplayPivotFields	Retrieves or sets the maximum number of columns to be displayed on the control's list.
		DisplayPivotRows	Retrieves or sets the maximum number of rows to be generated on the control's list.
		DrawGridLines	Retrieves or sets a value that indicates whether the grid lines are visible or hidden.
		Enabled	Enables or disables the control.
		EndUpdate	Resumes painting the control after painting is suspended by the BeginUpdate method.
		EventParam	Retrieves or sets a value that indicates the current's event parameter.
		ExecuteTemplate	Executes a template and returns the result.
		ExpandAll	Expands all rows.
		ExpandOnDblClick	Specifies whether the item is expanded or collapsed if the user dbl clicks the item.
		Export	Exports the control's data to a CSV format.
		FilterBarBackColor	Specifies the background color of the control's filter bar.
		FilterBarCaption	Specifies the filter bar's caption.
		FilterBarFont	Retrieves or sets the font for control's filter bar.
		FilterBarForeColor	Specifies the foreground color of the control's filter bar.
		FilterBarHeight	Specifies the height of the control's filter bar. If the value is less than 0, the filterbar is automatically resized to fit its description.
		FilterBarPrompt	Specifies the caption to be displayed when the filter pattern is missing.
		FilterBarPromptColumns	Specifies the list of columns to be used when filtering using the prompt.
		FilterBarPromptPattern	Specifies the pattern for the filter prompt.
		FilterBarPromptType	Specifies the type of the filter prompt.
		FilterBarPromptVisible	Shows or hides the filter prompt.
		FilterCriteria	Retrieves or sets the filter criteria.
		FilterInclude	Specifies the items being included after the user applies the filter.
		Font	Retrieves or sets the control's font.
		ForeColor	Specifies the control's foreground color.
		ForeColorHeader	Specifies the header's foreground color.
		FormatABC	Formats the A,B,C values based on the giving expression and returns the result.
		FormatAnchor	Specifies the visual effect for anchor elements in HTML captions.
		FormatAppearances	Retrieves the FormatAppearances collection of the pivot control.
		FormatConditionalAppearances	Retrieves the FormatConditionalAppearances collection of the pivot control.
		FormatContents	Retrieves the FormatContents collection of the pivot control.
		FormatPivotAggregate	Specifies the format to display an aggregate function.
		FormatPivotHeader	Specifies the format to display the columns in the pivot bar.
		FormatPivotTotal	Specifies the format to display an aggregate/total functions.
		FreezeEvents	Prevents the control to fire any event.
		GetHeaders	Gets a safe array of all generated columns/headers.
		GetItems	Gets a safe array of all generated items/values.
		GridLineColor	Specifies the grid line color.
		GridLineStyle	Specifies the style for gridlines in the list part of the control.
		HasLines	Enhances the graphic representation of a grid control's hierarchy by drawing lines that link child items to their corresponding parent item.
		HeaderAppearance	Retrieves or sets a value that indicates the header's appearance.
		HeaderHeight	Retrieves or sets a value indicating the control's header height.
		HeaderVisible	Retrieves or sets a value that indicates whether the the grid's header is visible or hidden.
		HTMLPicture	Adds or replaces a picture in HTML captions.
		hWnd	Retrieves the control's window handle.
		Images	Sets at runtime the control's image list. The Handle should be a handle to an Images List Control.
		ImageSize	Retrieves or sets the size of icons the control displays.
		Import	Imports the control's data from a CSV format.
		IncludeExpandColumn	Specifies whether the column itself is displayed in the list (header/chart), while it expanded ( the column contains child columns ).
		Indent	Retrieves or sets the amount, in pixels, that child items are indented relative to their parent items.
		Layout	Saves or loads the control's layout, such as positions of the columns, scroll position, filtering values.
		LinesAtRoot	Link items at the root of the hierarchy.
		LoadHeadersOnly	Loads the headers only, so no data is loaded.
		LoadXML	Loads an XML document from the specified location, using MSXML parser.
		LockRowsColumn	Retrieves or sets a value that indicates whether the rows column in the list is locked or scrollable.
		LockTotalRows	Retrieves or sets a value that indicates whether the total rows in the list are locked or scrollable.
		OnFilterChange	Specifies the action that the control performs once the user changes the filter at runtime.
		PaneHeight	Specifies the height for the top or bottom panel.
		PaneMinHeight	Specifies the minimum height for the top or bottom panel.
		Picture	Retrieves or sets a graphic to be displayed in the control.
		PictureDisplay	Retrieves or sets a value that indicates the way how the graphic is displayed on the control's background
		PivotBarVisible	Specifies how the control displays its pivot bar.
		PivotColumns	Specifies the list of columns to be displayed in the list.
		PivotColumnsFloatBarVisible	Retrieves or sets a value that indicates whether the pivot columns float bar is visible or hidden.
		PivotColumnsSortOrder	Specifies the sorting order for the columns being shown in the control's columns floating panel.
		PivotRows	Specifies the list of group-by columns that determines the rows in the list.
		PivotTotalDefaultFormatAppearances	Specifies the list of format-appearances ( key of FormatAppearance object), separated by comma, to be applied on the Total field when it is displayed in the pivot-table.
		PivotTotalDefaultFormatContent	Specifies the default format (key of FormatContent object) to be applied on the Total field when it is displayed in the pivot-table.
		PivotTotals	Indicates the list of totals/subtotals to be shown in the list.
		RadioImage	Retrieves or sets a value that indicates the image used by cells of radio type.
		Refresh	Refreses the control.
		ReplaceIcon	Adds a new icon, replaces an icon or clears the control's image list.
		Reset	Resets the control's layouts, so no filtering, sorting, ... is applied to the view.
		SaveXML	Saves the control's content as XML document to the specified location, using the MSXML parser.
		SelBackColor	Retrieves or sets a value that indicates the selection background color.
		SelBackMode	Retrieves or sets a value that indicates whether the selection is transparent or opaque.
		SelectableAggregateRows	Specifies whether the aggregate rows are selectable or un-selectable.
		SelectAll	Selects all rows.
		SelectOnRelease	Indicates whether the selection occurs when the user releases the mouse button.
		SelForeColor	Retrieves or sets a value that indicates the selection foreground color.
		ShowBranchRows	Indicates how the branch rows displays the information ( divider items ).
		ShowDataOnDblClick	Specifies whether the user shows the original data that generated the result when user double clicks a cell.
		ShowImageList	Specifies whether the control's image list window is visible or hidden.
		ShowToolTip	Shows the specified tooltip at given position.
		ShowViewCompact	Indicates whether the view compacts the data being displayed.
		SingleSel	Retrieves or sets a value that indicates whether the control supports single or multiple selection.
		Statistics	Gives statistics data of objects being hold by the control.
		Template	Specifies the control's template.
		TemplateDef	Defines inside variables for the next Template/ExecuteTemplate call.
		TemplatePut	Defines inside variables for the next Template/ExecuteTemplate call.
		ToolTipDelay	Specifies the time in ms that passes before the ToolTip appears.
		ToolTipFont	Retrieves or sets the tooltip's font.
		ToolTipMargin	Defines the size of the control's tooltip margins.
		ToolTipPopDelay	Specifies the period in ms of time the ToolTip remains visible if the mouse pointer is stationary within a control.
		ToolTipWidth	Specifies a value that indicates the width of the tooltip window, in pixels.
		UnselectAll	Unselects all rows.
		UseVisualTheme	Specifies whether the control uses the current visual theme to display certain UI parts.
		ValueFromPoint	Retrieves the value from the point.
		Version	Retrieves the control's version.
		VisualAppearance	Retrieves the control's appearance.
		VisualDesign	Invokes the control's VisualAppearance designer.