ContextQMD
Back to Devexpress

VCL Pivot Grid

vcl-157065-expresspivotgrid-vcl-pivot-grid.md

latest5.6 KB
Original Source

VCL Pivot Grid

  • Sep 06, 2024
  • 3 minutes to read

The VCL Pivot Grid emulates Microsoft Excel’s Pivot Table UI. It helps you display a variety of summarized views based on raw data. Users can change the view layout and shape data at runtime.

Bind to Data

The Pivot Grid supports the following data access modes:

Bound Mode

Data is stored in a relational data storage. The Pivot Grid loads all data from the bound dataset to the client.

Refer to the following topics for additional information:

Unbound ModeThe Pivot Grid is not bound to a dataset and manages data preloaded into the data controller.Provider ModeData is stored in a custom data source. Create a TcxCustomDataSource descendant and override the GetRecordCount and GetValue methods to use this mode.OLAP Mode

The Pivot Grid loads and displays multidimensional data from Microsoft Analysis Services data sources (OLAP cubes). You can store an OLAP cube in the local file system or deploy it to Microsoft SQL Server. Refer to the following topics for detailed information on how to work with OLAP cubes:

Data Shaping

The Pivot Grid control has the following data shaping options:

Filter Data

The prefilter panel and filter dropdowns allow users to filter data that meets certain criteria.

Group Data

If you place a field into the row or column area, the Pivot Grid automatically groups field values. You can place multiple fields in the same area to enable a hierarchical display.

Summaries

The Pivot Grid’s internal logic specifies the default summary type to apply to different field types. You can change the summary type to any built-in summary function or implement a custom summary calculation algorithm.

Refer to the following topic for more information on summaries:

Tip

You can link the TcxPivotGridSummaryDataSet component to the Pivot Grid to display calculated summaries in another data-aware control.

Sort Data

The Pivot Grid can sort data based on column and row header values, or based on the corresponding summary values.

Refer to the following topics for details:

Totals and Grand Totals

The Pivot Grid can calculate totals against entire rows/columns and against individual groups (if you enable hierarchical data display).

Refer to the following topics for details on supported total types:

Data Analysis

The Pivot Grid can display its data in an unbound Chart View of the VCL Data Grid.

Tip

The Data Grid control required to display data as a chart is installed separately. Refer to the TcxPivotGridChartConnection component description for detailed information.

Export Data

You can export the Pivot Grid’s content to a file in the following formats:

Refer to the following topics for additional information: Data Export.