ExpressPivotGrid Suite

DevExpressUI Input ControlsVCL Component

Multi-dimensional pivot grid components for comprehensive data analysis.

  • Supports multiple data binding modes including OLAP and unbound.
  • Enables data shaping features like sorting, filtering, grouping, and summaries.
  • Offers extensive UI customization and export options for developer integration.
DevExpress logo

Prices from:

Loading...
Available in
DevExpress VCL SubscriptionLoading
DevExpress VCL Subscription +Loading
ExpressGridPackLoading
ExpressPivotGrid Suite product image
ExpressPivotGrid Suite offers developer components that emulate Excel pivot tables, enabling interactive multi-dimensional analysis and cross-tab reporting. It supports diverse data sources, including OLAP cubes, and includes advanced data shaping capabilities, visualization integration, and extensive runtime customization to deliver meaningful insights with flexible UI control.

Data Binding Modes

Supports bound, unbound, virtual, and OLAP data sources, allowing integration with relational databases or multidimensional OLAP cubes via Microsoft Analysis Services.

Data Shaping Features

Provides sorting by columns and summaries, advanced filtering via UI controls, grouping across unlimited fields, and calculation of summaries using built-in and custom aggregate functions.

Totals and Summaries

Automatically calculates totals, subtotals, and grand totals with options for customization, supporting hierarchical data display and granular control over aggregated data.

Interactive Data Exploration

Enables end-users to drill down into detailed data records behind summary cells, fostering deeper data understanding through a specialized dataset component connected to the pivot grid.

UI and Editing Customization

Includes several embedded data editors with validation and error indication, field customization through drag & drop, field grouping, and runtime layout adjustments for flexible user interaction.

Hierarchical and Multi-level Layouts

Supports expandable and collapsible hierarchy levels for rows and columns, allowing multidimensional data display from different perspectives and facilitating complex data analysis.

Integration with Visualization Controls

Connection to chart and map controls enables graphical representation of pivot data, enhancing report communication and end-user data comprehension.

Export and Persistence

Facilitates exporting pivot grid content to formats like XLSX, CSV, PDF, HTML, and others, and supports saving and restoring user custom layouts through files, registry, or streams.

High Performance Engine

Leverages a highly optimized in-memory data processing engine to manage large datasets efficiently, ensuring fast data refresh, sorting, and report generation consistent across supported platforms.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Component Type

  • VCL Component

IDE Support

  • C++Builder
  • Delphi
  • RAD Studio