Skip to main content
BuyLog In
VCL
Search in…
Docs > VCL Controls > ExpressPivotGrid Suite > Concepts > Data Modes
All docs
V24.1
VCL Controls
Express Cross Platform Library
ExpressQuantumGrid Suite
ExpressEditors Library
ExpressBars Suite
ExpressCharts Suite
ExpressRichEditControl Suite
ExpressSkins Library
ExpressScheduler Suite
ExpressSpreadSheet Suite
ExpressQuantumTreeList Suite
ExpressPDFViewer Suite
ExpressPrinting System
ExpressLayoutControl Suite
ExpressNavBar Suite
ExpressPivotGrid Suite
Concepts
Unbound Mode
Data Modes
Provider Mode
Bound Mode
Fields
Fields in OLAP Mode
OLAP Requirements and Limitations
Refresh Data
Focusing Cells Programmatically
Selecting Data Cells
Summaries
Summary Variation
Access Cell Values
Automatic Totals (Subtotals)
Automatic Grand Totals
Custom Totals (Subtotals)
Filtering Data
Sorting Data
Displaying Top N Values for a Field
Field Location Areas
Field Groups
Grouping Values
How to Calculate Custom Summaries
How to Provide Custom Grouping Values
How to Add an Unbound Field to Supply Additional Data
Grouping Value Context Menu
How to Display Print Preview and Print the Pivot Grid
Field Header Context Menu
How to Apply a Filter to a Field
Header Area Context Menu
How to Display Underlying Records
How to Add Custom Items into Built-in Context Menus
Filter Builder Dialog
How to Implement the Sorting by Summary Feature
Member Table: Bind to an OLAP Data Source
Cell Region
Fundamentals
Feature Center
Visual Elements
Design-Time Features
End-User Capabilities
Member Tables
Task-Based Help
API Reference
ExpressVerticalGrid Suite
ExpressDocking Library
ExpressMemData
ExpressDataController
ExpressSpellChecker Suite
ExpressMapControl Suite
ExpressGanttControl Suite
ExpressGaugeControl Suite
ExpressTileControl Suite
ExpressFlowChart Suite
ExpressFlowChart Editor
ExpressOrgChart Suite
ExpressPageControl Suite
ExpressWizardControl Suite

Data Modes

Depending upon the type of the data persistence, the ExpressPivotGrid offers the following data modes:

  • OLAP mode – the data is read from Microsoft Analysis Services data sources.

  • Standard modes:

  • Bound mode – is applied if the data is stored in a relational data store (the TcxDBPivotGrid control is used).

  • Unbound mode – in this mode the data is manually pulled out from the file system store into the data controller’s cache (the TcxPivotGrid control is used).

  • Provider mode – is the mode for working with the custom data structure (the TcxPivotGrid control is used). To provide knowledge on the data structure, a set of the TcxCustomDataSource‘s methods is to be overridden in its subclass.

See Also