TcxDBPivotGrid Members

A data-aware Pivot Grid control.

Constructors

Name	Description
Create(TComponent)	Inherited from TComponent.
CreateParented(HWND)	Inherited from TWinControl.

Properties

Name	Description
Action	Inherited from TControl.
ActiveCanvas	Provides access to the control’s GDI-based canvas. Inherited from TcxControl.
Align	Inherited from TControl.
AlignDisabled	Inherited from TWinControl.
AlignWithMargins	Inherited from TControl.
Anchors	Inherited from TControl.
AutoSize	Inherited from TControl.
BevelEdges	Inherited from TWinControl.
BevelInner	Inherited from TWinControl.
BevelKind	Inherited from TWinControl.
BevelOuter	Inherited from TWinControl.
BevelWidth	Inherited from TWinControl.
BiDiMode	Inherited from TControl.
BorderSize protected	Inherited from TcxControl.
BorderStyle	Inherited from TcxCustomPivotGrid.
BorderWidth	Inherited from TWinControl.
Bounds	Returns the control’s boundaries. Inherited from TcxControl.
BoundsRect	Inherited from TControl.
Brush	Inherited from TWinControl.
Canvas	Provides access to the control’s GDI-based canvas. Inherited from TcxControl.
Caption	Inherited from TControl.
ClientBounds	Returns the control’s client area. Inherited from TcxControl.
ClientHeight	Inherited from TControl.
ClientOrigin	Inherited from TControl.
ClientRect	Inherited from TControl.
ClientWidth	Inherited from TControl.
Color	Inherited from TControl.
ComObject	Inherited from TComponent.
ComponentCount	Inherited from TComponent.
ComponentIndex	Inherited from TComponent.
Components	Inherited from TComponent.
ComponentState	Inherited from TComponent.
ComponentStyle	Inherited from TComponent.
Constraints	Inherited from TControl.
ControlCount	Inherited from TWinControl.
Controls	Inherited from TWinControl.
ControlState	Inherited from TControl.
ControlStyle	Inherited from TControl.
Ctl3D	Inherited from TWinControl.
CurrentPPI	Inherited from TControl.
Cursor	Inherited from TControl.
CustomHint	Inherited from TControl.
Customization	Provides access to the settings of the pivot grid’s customization form. Inherited from TcxCustomPivotGrid.
DataController	Provides access to the data controller. Inherited from TcxCustomDBPivotGrid.
DataSource	Specifies a data source object that provides a link to a dataset. Inherited from TcxCustomDBPivotGrid.
DesignInfo	Inherited from TComponent.
DockClientCount	Inherited from TWinControl.
DockClients	Inherited from TWinControl.
DockManager	Inherited from TWinControl.
DockOrientation	Inherited from TControl.
DockSite	Inherited from TWinControl.
DoubleBuffered	Inherited from TWinControl.
DragAndDropObject	Inherited from TcxControl.
DragAndDropObjectClass	Inherited from TcxControl.
DragAndDropState	Inherited from TcxControl.
DragCursor	Inherited from TControl.
DragKind	Inherited from TControl.
DragMode	Inherited from TControl.
Enabled	Inherited from TControl.
ExplicitHeight	Inherited from TControl.
ExplicitLeft	Inherited from TControl.
ExplicitTop	Inherited from TControl.
ExplicitWidth	Inherited from TControl.
FieldCount	Gets a count of the fields in the TcxCustomPivotGrid.Fields collection. Inherited from TcxCustomPivotGrid.
FieldHeaderImages	Specifies the source of images for displaying within field headers. Inherited from TcxCustomPivotGrid.
Fields	Provides indexed access to the TcxPivotGridField object, which represents a field. Inherited from TcxCustomPivotGrid.
Floating	Inherited from TControl.
FloatingDockSiteClass	Inherited from TControl.
FocusOnClick protected	Specifies if clicking the control focuses it. Inherited from TcxControl.
Font	Inherited from TControl.
GroupHeaderImages	Specifies the source of images for displaying within grouping item headers. Inherited from TcxCustomPivotGrid.
Groups	Provides access to a collection of field groups. Inherited from TcxCustomPivotGrid.
Handle	Inherited from TWinControl.
Height	Inherited from TControl.
HelpContext	Inherited from TControl.
HelpKeyword	Inherited from TControl.
HelpType	Inherited from TControl.
Hint	Specifies a hint message for the control. Inherited from TcxControl.
HitTest	Returns HitTest information on the coordinates of the test point and on the pivot grid’s element that the mouse pointer is currently positioned over. Inherited from TcxCustomPivotGrid.
HostDockSite	Inherited from TControl.
HScrollBar protected	Inherited from TcxControl.
HScrollBarVisible protected	Inherited from TcxControl.
ImeMode	Inherited from TWinControl.
ImeName	Inherited from TWinControl.
IsDesigning	Identifies if the control is being modified by the form designer. Inherited from TcxControl.
IsDestroying	Identifies if the control is about to be destroyed. Inherited from TcxCustomControl.
IsDrawingLocked	Inherited from TWinControl.
IsFocused	Identifies if the control has focus. Inherited from TcxControl.
IsLoading	Identifies if the control is being loaded. Inherited from TcxControl.
Keys protected	Inherited from TcxControl.
Left	Inherited from TControl.
LookAndFeel	Provides access to the control’s look & feel settings. Inherited from TcxControl.
LookAndFeelPainter	Inherited from TcxControl.
LRDockWidth	Inherited from TControl.
Margins	Inherited from TControl.
MouseCapture	Inherited from TControl.
MouseCaptureObject	Provides access to the dragged object during a drag-and-drop operation. Inherited from TcxControl.
MouseDownPos	Specifies the mouse pointer position when an OnMouseDown event occurs. Inherited from TcxControl.
MouseInClient	Inherited from TWinControl.
Name	Inherited from TComponent.
Observers	Inherited from TComponent.
OLAPDataSource	Specifies the data source providing OLAP cube data for the pivot grid. Inherited from TcxCustomPivotGrid.
OptionsBehavior	Provides access to hint and focus settings of the pivot grid. Inherited from TcxCustomPivotGrid.
OptionsCustomize	Provides access to options, which control the behavior of different elements of the pivot grid. Inherited from TcxCustomPivotGrid.
OptionsData	Provides access to options that control data processing in the pivot grid. Inherited from TcxCustomPivotGrid.
OptionsDataField	Provides access to appearance and behavior settings of the data field anchor. Inherited from TcxCustomPivotGrid.
OptionsLockedStateImage	Specifies the display settings for the pivot grid’s “Locked View“ image. Inherited from TcxCustomPivotGrid.
OptionsPrefilter	Provides access to appearance and layout settings of the prefilter panel. Inherited from TcxCustomPivotGrid.
OptionsSelection	Provides access to selection settings of the pivot grid. Inherited from TcxCustomPivotGrid.
OptionsView	Provides access to view options of the pivot grid. Inherited from TcxCustomPivotGrid.
Owner	Inherited from TComponent.
Padding	Inherited from TWinControl.
Parent	Inherited from TControl.
ParentBackground protected	Inherited from TcxControl.
ParentBiDiMode	Inherited from TControl.
ParentColor	Inherited from TControl.
ParentCtl3D	Inherited from TWinControl.
ParentCustomHint	Inherited from TControl.
ParentDoubleBuffered	Inherited from TWinControl.
ParentFont	Inherited from TControl.
ParentShowHint	Inherited from TControl.
ParentWindow	Inherited from TWinControl.
PixelsPerInch	Inherited from TWinControl.
PopupMenu	Specifies the popup menu associated with the control. Inherited from TcxControl.
PopupMenus	Provides access to options of the pivot grid’s pop-up menu. Inherited from TcxCustomPivotGrid.
RaiseOnNonMainThreadUsage	Inherited from TControl.
RedrawDisabled	Inherited from TWinControl.
ScaleFactor	Inherited from TControl.
ScrollBars protected	Inherited from TcxControl.
ShowHint	Inherited from TControl.
Showing	Inherited from TWinControl.
StyleElements	Inherited from TControl.
StyleName	Inherited from TControl.
Styles	Provides access to style settings for the pivot grid’s visual elements. Inherited from TcxCustomPivotGrid.
SummaryFields	Provides access to a collection of fields whose values are involved in summary calculations. Inherited from TcxCustomPivotGrid.
TabOrder	Inherited from TWinControl.
TabStop	Inherited from TcxControl.
Tag	Inherited from TComponent.
TBDockHeight	Inherited from TControl.
Text	Inherited from TControl.
TipMode	Inherited from TWinControl.
Top	Inherited from TControl.
Touch	Inherited from TControl.
Transparent protected	Specifies if the control is transparent in GDI render mode. Inherited from TcxControl.
UndockHeight	Inherited from TControl.
UndockWidth	Inherited from TControl.
UseDockManager	Inherited from TWinControl.
VCLComObject	Inherited from TComponent.
ViewData	Provides access to layout information on the data cells. Inherited from TcxCustomPivotGrid.
Visible	Inherited from TControl.
VisibleDockClientCount	Inherited from TWinControl.
VScrollBar protected	Inherited from TcxControl.
VScrollBarVisible protected	Inherited from TcxControl.
Width	Inherited from TControl.
WindowProc	Inherited from TControl.

Methods

Name	Description
AcceptMousePosForClick(Integer,Integer)	Inherited from TcxControl.
AddFontListener(IcxFontListener)	Inherited from TcxControl.
AddListener(IcxPivotGridListener)	Inherited from TcxCustomPivotGrid.
ApplyBestFit	Resizes the headers and data cells that correspond to all the visible data fields and row fields to completely display their contents. Inherited from TcxCustomPivotGrid.
Assign(TPersistent)	Inherited from TPersistent.
AssignTo(TPersistent)	Inherited from TPersistent.
BeginDrag(Boolean,Integer)	Inherited from TControl.
BeginDragAndDrop	Inherited from TcxControl.
BeginInvoke(TAsyncConstArrayFunctionEvent,Untyped[],TObject)	Inherited from TComponent.
BeginInvoke(TAsyncConstArrayProc,Untyped[],TObject)	Inherited from TComponent.
BeginInvoke(TAsyncConstArrayProcedureEvent,Untyped[],TObject)	Inherited from TComponent.
BeginInvoke(TAsyncFunctionEvent,TObject)	Inherited from TComponent.
BeginInvoke(TAsyncProcedureEvent,TObject)	Inherited from TComponent.
BeginInvoke(TProc,TObject)	Inherited from TComponent.
BeginInvoke<TResult>(TAsyncConstArrayFunc<TResult>,Untyped[],TObject)	Inherited from TComponent.
BeginInvoke<TResult>(TFunc<TResult>,TObject)	Inherited from TComponent.
BeginLockedStatePaint(TcxLockedStateImageShowingMode)	Inherited from TcxCustomPivotGrid.
BeginUpdate	Acquires a lock on the pivot grid when performing bulk updates. Inherited from TcxCustomPivotGrid.
BringToFront	Inherited from TControl.
Broadcast(Untyped)	Inherited from TWinControl.
CanFocus	Inherited from TWinControl.
CanFocusEx	Inherited from TcxControl.
ChangeScale(Integer,Integer)	Inherited from TControl.
CheckNonMainThreadUsage	Inherited from TControl.
Click	Inherited from TControl.
ClientToParent(TPoint,TWinControl)	Inherited from TControl.
ClientToScreen(TPoint)	Inherited from TControl.
ClientToScreen(TRect)	Inherited from TControl.
ConstrainedResize(Integer,Integer,Integer,Integer)	Inherited from TControl.
ContainsControl(TControl)	Inherited from TWinControl.
ControlAtPos(TPoint,Boolean,Boolean,Boolean)	Inherited from TWinControl.
CopyToClipboard(Boolean,Boolean,Boolean,Boolean)	Copies visible or selected data cells to the clipboard. Inherited from TcxCustomPivotGrid.
CreateAllFields	Creates fields that represent all the persistent fields in the underlying data source. Inherited from TcxCustomDBPivotGrid.
CreateDrillDownDataSource	Inherited from TcxCustomPivotGrid.
CreateField	Creates a new field. Inherited from TcxCustomPivotGrid.
CreateParentedControl(HWND)	Inherited from TWinControl.
DeleteAllFields	Deletes all the fields in the pivot grid. Inherited from TcxCustomPivotGrid.
DestroyComponents	Inherited from TComponent.
Destroying	Inherited from TComponent.
DisableAlign	Inherited from TWinControl.
Dock(TWinControl,TRect)	Inherited from TControl.
DockDrop(TDragDockObject,Integer,Integer)	Inherited from TWinControl.
DragDrop(TObject,Integer,Integer)	Inherited from TControl.
Dragging	Inherited from TControl.
DrawTextBiDiModeFlags(Longint)	Inherited from TControl.
DrawTextBiDiModeFlagsReadingOnly	Inherited from TControl.
EnableAlign	Inherited from TWinControl.
EndDrag(Boolean)	Inherited from TControl.
EndFunctionInvoke(IAsyncResult)	Inherited from TComponent.
EndInvoke(IAsyncResult)	Inherited from TComponent.
EndInvoke<TResult>(IAsyncResult)	Inherited from TComponent.
EndLockedStatePaint	Inherited from TcxCustomPivotGrid.
EndUpdate	Releases a lock acquired by the BeginUpdate method. Inherited from TcxCustomPivotGrid.
Equals(TObject)	Inherited from TObject.
ExecuteAction(TBasicAction)	Inherited from TComponent.
FindChildControl(String)	Inherited from TWinControl.
FindComponent(String)	Inherited from TComponent.
FinishDragAndDrop(Boolean)	Inherited from TcxControl.
FlipChildren(Boolean)	Inherited from TWinControl.
Focused	Inherited from TWinControl.
FreeNotification(TComponent)	Inherited from TComponent.
FreeOnRelease	Inherited from TComponent.
FullRefresh	Forces the pivot grid to update it and the underlying data controller. Inherited from TcxCustomPivotGrid.
GetChildren(TGetChildProc,TComponent)	Inherited from TComponent.
GetControlsAlignment	Inherited from TControl.
GetDragImages	Inherited from TControl.
GetFieldByName(string)	Returns an instance of the named field. Inherited from TcxCustomPivotGrid.
GetHashCode	Inherited from TObject.
GetNamePath	Inherited from TPersistent.
GetOwner	Inherited from TPersistent.
GetParentComponent	Inherited from TComponent.
GetStyleName	Inherited from TControl.
GetSystemMetrics(Integer)	Inherited from TControl.
GetTabControlList(TList)	Inherited from TWinControl.
GetTabOrderList(TList)	Inherited from TWinControl.
GetTextBuf(PChar,Integer)	Inherited from TControl.
GetTextLen	Inherited from TControl.
HandleAllocated	Inherited from TWinControl.
HandleNeeded	Inherited from TWinControl.
HasParent	Inherited from TComponent.
Hide	Inherited from TControl.
InitiateAction	Inherited from TControl.
InsertComponent(TComponent)	Inherited from TComponent.
InsertControl(TControl)	Inherited from TWinControl.
Invalidate	Inherited from TControl.
InvalidateRect(TRect,Boolean)	Adds a specified portion of the control’s client area to the window update region. Inherited from TcxControl.
InvalidateRgn(TcxRegion,Boolean)	Inherited from TcxControl.
InvalidateWithChildren	Inherited from TcxControl.
IsCustomStyleActive	Inherited from TControl.
IsImplementorOf(IInterface)	Inherited from TComponent.
IsLightStyleColor(TColor)	Inherited from TControl.
IsMouseInPressedArea(Integer,Integer)	Inherited from TcxControl.
IsRightToLeft	Inherited from TControl.
LayoutChanged	Forces the pivot grid to recalculate the layout and ViewInfo and notifies that the pivot grid’s view has been changed. Inherited from TcxCustomPivotGrid.
Loaded	Inherited from TComponent.
LockDrawing	Inherited from TWinControl.
LockScrollBars	Inherited from TcxControl.
ManualDock(TWinControl,TControl,TAlign)	Inherited from TControl.
ManualFloat(TRect)	Inherited from TControl.
MouseDown(TMouseButton,TShiftState,Integer,Integer)	Inherited from TControl.
MouseMove(TShiftState,Integer,Integer)	Inherited from TControl.
MouseUp(TMouseButton,TShiftState,Integer,Integer)	Inherited from TControl.
MouseWheelHandler(TMessage)	Inherited from TControl.
Notification(TComponent,TOperation)	Inherited from TComponent.
PaintTo(HDC,Integer,Integer)	Inherited from TWinControl.
PaintTo(TCanvas,Integer,Integer)	Inherited from TWinControl.
ParentToClient(TPoint,TWinControl)	Inherited from TControl.
Perform(Cardinal,WPARAM,LPARAM)	Inherited from TControl.
Perform(Cardinal,WPARAM,PChar)	Inherited from TControl.
Perform(Cardinal,WPARAM,TRect)	Inherited from TControl.
PostMouseMove	Inherited from TcxControl.
PostMouseMove(TPoint)	Inherited from TcxControl.
PreProcessMessage(TMsg)	Inherited from TWinControl.
Realign	Inherited from TWinControl.
ReferenceInterface(IInterface,TOperation)	Inherited from TComponent.
Refresh	Inherited from TControl.
RemoveComponent(TComponent)	Inherited from TComponent.
RemoveControl(TControl)	Inherited from TWinControl.
RemoveFontListener(IcxFontListener)	Inherited from TcxControl.
RemoveFreeNotification(TComponent)	Inherited from TComponent.
RemoveListener(IcxPivotGridListener)	Inherited from TcxCustomPivotGrid.
Repaint	Inherited from TControl.
ReplaceDockedControl(TControl,TWinControl,TControl,TAlign)	Inherited from TControl.
RestoreFromIniFile(string,Boolean,Boolean)	Restores the pivot grid’s layout from an INI file. Inherited from TcxCustomPivotGrid.
RestoreFromRegistry(string,Boolean,Boolean)	Restores the pivot grid’s layout from the system registry. Inherited from TcxCustomPivotGrid.
RestoreFromStream(TStream,Boolean,Boolean)	Restores the pivot grid’s layout from an AStream stream. Inherited from TcxCustomPivotGrid.
ScaleBy(Integer,Integer)	Inherited from TWinControl.
ScaleForPPI(Integer)	Inherited from TControl.
ScaleRectSize(TRect)	Inherited from TControl.
ScaleValue(Double)	Inherited from TControl.
ScaleValue(Integer)	Inherited from TControl.
ScaleValue(TPoint)	Inherited from TControl.
ScaleValue(TRect)	Inherited from TControl.
ScaleValue(TSize)	Inherited from TControl.
ScreenToClient(TPoint)	Inherited from TControl.
ScreenToClient(TRect)	Inherited from TControl.
ScrollBy(Integer,Integer)	Inherited from TWinControl.
ScrollContent(TcxDirection)	Inherited from TcxControl.
ScrollWindow(Integer,Integer,TRect)	Inherited from TcxControl.
SendToBack	Inherited from TControl.
SetBounds(Integer,Integer,Integer,Integer)	Inherited from TControl.
SetDesignVisible(Boolean)	Inherited from TControl.
SetFocus	Inherited from TWinControl.
SetParentComponent(TComponent)	Inherited from TComponent.
SetScrollBarInfo(TScrollBarKind,Integer,Integer,Integer,Integer,Integer,Boolean,Boolean)	Inherited from TcxControl.
SetSubComponent(Boolean)	Inherited from TComponent.
SetTextBuf(PChar)	Inherited from TControl.
Show	Inherited from TControl.
ShowPrefilterDialog	Shows the filter builder dialog. Inherited from TcxCustomPivotGrid.
StartDrag(TDragObject)	Inherited from TcxControl.
StoreToIniFile(string,Boolean)	Saves the pivot grid’s layout in an INI file. Inherited from TcxCustomPivotGrid.
StoreToRegistry(string,Boolean)	Saves the pivot grid’s layout in the system registry. Inherited from TcxCustomPivotGrid.
StoreToStream(TStream)	Saves the pivot grid’s layout in the AStream stream. Inherited from TcxCustomPivotGrid.
SupportsUIAutomation protected	Inherited from TcxCustomControl.
SystemInfoChanged(Cardinal)	Inherited from TcxControl.
ToString	Inherited from TObject.
TranslationChanged	Inherited from TcxControl.
UnlockDrawing	Inherited from TWinControl.
UnlockScrollBars	Inherited from TcxControl.
Update	Inherited from TControl.
UpdateAction(TBasicAction)	Inherited from TComponent.
UpdateControlState	Inherited from TWinControl.
UpdateWithChildren	Inherited from TcxControl.
UseRightToLeftAlignment	Inherited from TControl.
UseRightToLeftReading	Inherited from TControl.
UseRightToLeftScrollBar	Inherited from TControl.
WndProc(TMessage)	Inherited from TControl.

Events

Name	Description
OnAlignInsertBefore	Inherited from TWinControl.
OnAlignPosition	Inherited from TWinControl.
OnCanResize	Inherited from TControl.
OnClick	Inherited from TControl.
OnCompare	Fires when the sorting operation on column field values or row field values is performed. Inherited from TcxCustomPivotGrid.
OnConstrainedResize	Inherited from TControl.
OnContextPopup	Inherited from TControl.
OnCustomDrawCell	Enables you to custom paint a data cell. Inherited from TcxCustomPivotGrid.
OnCustomDrawColumnHeader	Enables you to custom paint a column grouping value. Inherited from TcxCustomPivotGrid.
OnCustomDrawFieldHeader	Enables you to custom paint a field header. Inherited from TcxCustomPivotGrid.
OnCustomDrawPart	Enables you to custom paint the background of pivot grid client and header areas. Inherited from TcxCustomPivotGrid.
OnCustomDrawRowHeader	Enables you to custom paint a row grouping value. Inherited from TcxCustomPivotGrid.
OnCustomization	Occurs when the visibility of the pivot grid’s customization form changes. Inherited from TcxCustomPivotGrid.
OnDblClick	Inherited from TControl.
OnDockDrop	Inherited from TWinControl.
OnDockOver	Inherited from TWinControl.
OnDragDrop	Inherited from TControl.
OnDragOver	Inherited from TControl.
OnEndDock	Inherited from TControl.
OnEndDrag	Inherited from TControl.
OnEnter	Inherited from TWinControl.
OnExit	Inherited from TWinControl.
OnFieldPosChanged	Fires after the field has been repositioned. Inherited from TcxCustomPivotGrid.
OnFieldSizeChanged	Fires after a field header has been resized. Inherited from TcxCustomPivotGrid.
OnFilterChanged	Fires after a prefilter or a field’s filter has been changed. Inherited from TcxCustomPivotGrid.
OnFocusChanged protected	Inherited from TcxControl.
OnGesture	Inherited from TControl.
OnGetCellHint	Enables you to customize hints or suppress them. Inherited from TcxCustomPivotGrid.
OnGetSiteInfo	Inherited from TWinControl.
OnGetStoredProperties	Enables you to customize a list of the pivot grid’s properties to be stored to external data stores. Inherited from TcxCustomPivotGrid.
OnGetStoredPropertyValue	Enables you to provide values for pivot grid properties to be saved to external data stores. Inherited from TcxCustomPivotGrid.
OnInitStoredObject	Enables you to initialize fields that are created when restoring the pivot grid’s layout from external data stores. Inherited from TcxCustomPivotGrid.
OnKeyDown	Inherited from TWinControl.
OnKeyPress	Inherited from TWinControl.
OnKeyUp	Inherited from TWinControl.
OnLayoutChanged	Occurs after a field or data cell layout change. Inherited from TcxCustomPivotGrid.
OnMouseActivate	Inherited from TControl.
OnMouseDown	Inherited from TControl.
OnMouseEnter	Occurs when the mouse pointer enters into the control. Inherited from TcxControl.
OnMouseLeave	Occurs when the mouse pointer leaves the control. Inherited from TcxControl.
OnMouseMove	Inherited from TControl.
OnMouseUp	Inherited from TControl.
OnMouseWheel	Inherited from TControl.
OnMouseWheelDown	Inherited from TControl.
OnMouseWheelUp	Inherited from TControl.
OnPrefilterDialogShow	Inherited from TcxCustomPivotGrid.
OnPrepareLockedStateImage	Enables you to custom paint a “Locked View“ image. Inherited from TcxCustomPivotGrid.
OnResize	Inherited from TControl.
OnSelectionChanged	Fires after the data cell(s) has been selected. Inherited from TcxCustomPivotGrid.
OnSetStoredPropertyValue	Enables you to restore property values from external data stores. Inherited from TcxCustomPivotGrid.
OnStartDock	Inherited from TControl.
OnStartDrag	Inherited from TControl.
OnUnDock	Inherited from TWinControl.
PopupMenusEvents	Inherited from TcxCustomPivotGrid.
StylesEvents	Inherited from TcxCustomPivotGrid.

See Also

TcxDBPivotGrid Class

cxDBPivotGrid Unit