Data Binding
Multiple data source type support.
Data Binding
The DevExpress VCL Pivot Grid control supports data-bound, unbound and virtual modes.
OLAP
Microsoft Analysis Services Support
OLAP
The DevExpress VCL Pivot Grid supports Microsoft Analysis Services (OLAP) data sources (OLE DB Provider). When bound to this data source type, the ExpressPivotGrid automatically delegates all data management and calculations to the server.
Chart Integration
Present information graphically.
Chart Integration
Visualize data displayed in the pivot grid using charts and let users create reports that communicate information effectively.
Drill Down
Get records used to calculate cell values.
Drill Down
With specially designed dataset components, you can allow your end-users to explore the data underlying all calculated cell values.
"Of all of the tools that I purchase and maintain, the DevExpress tools are the most valuable. The price is reasonable, the tools are fabulous and your support, in the rare case that it is needed, is stellar."
Al MoskowitzIntelliMedSoft
Data Shaping & Visualization
The DevExpress VCL Pivot Grid Control has the power to convert difficult to dissect dataset information into compact and summarized visual reports so your application can efficiently address real-time business analysis needs.
Sorting
Sort by Summary & Top Values
Sorting
The DevExpress VCL Pivot Grid supports automatic sorting for column/field and summary values. End-users can change a field's sort order by clicking the field header.
Combined with the Sorting by Summary feature, the Top N Values feature allows you to display the most important information and ignore the rest data.
Grouping
Group data against an unlimited number of fields.
Grouping
Data grouping is a highly effective way to summarize information for end-users. The DevExpress VCL Pivot Grid allows you to group data against an unlimited number of fields.
Filtering
Show the data you want and hide the rest.
Filtering
The DevExpress VCL Pivot Grid allows you to filter data via a field header's filter dropdown or an advanced Prefilter dialog.
Summaries & Aggregates
Automatically compute summaries across all Pivot Grid elements.
Summaries & Aggregates
Compute summaries using 9 built-in aggregate functions. The following built-in aggregate functions are available: Sum, Count, Min, Max, Average, Standard Deviation based upon a sample, Standard Deviation based upon the entire population, Variation based upon a sample and Variation based upon the entire population.
You can also compute custom summaries by handling corresponding event handlers.
Totals
Automatic Total and Grand Total calculation.
Totals
The Pivot Grid offers two unique ways with which to display data summaries: an out-of-the-box solution that addresses most common business needs and a completely customizable solution to satisfy the requirements of your most demanding of users.
"I am a long-time DevExpress user and have been an ardent fan of the products and more importantly, the excellent support they have always provided consistently."
Dhaval Shah
Editing & UI Customization
The fully customizable design of the Pivot Grid ensures that end-users can modify any layout visually in order to examine data from different/multiple perspectives.
In-Cell Editing
Use any of our 30+ Data Editors with built-in Input Validation and Error Indication.
In-Cell Editing
Over 30 controls that can be embedded into data cells for editing and better data presentation. Our editors provide seamless integration with the rest of our product line, including the Data Grid and Ribbon controls.
Advanced data editing options include:
- Input Validation;
- Error Indication.
Field Customization
Runtime column/field customization made easy.
Field Customization
The DevExpress VCL Pivot Grid allows end-users to customize column and row layout at runtime. The PivotGrid's Column Chooser can add/remove both columns and rows with simple drag & drop operations.
Field Groups
Combine fields into groups.
Field Groups
Fields can be combined into groups, so that when an end-user drags a field, the entire group is dragged as well.
Hierarchical Data
Expand/collapse values at higher hierarchy levels.
Hierarchical Data
Bring multiple detail levels to a single report. The more fields that take part in a hierarchy, the more flexible the report is. Multi-level hierarchies allow end-users to view data from different perspectives thus giving them total control over the data's layout. When necessary, end-users are free to expand and collapse child groups in order to control the level of detail in the view.
Save/Restore Layout
Save and restore runtime grid customizations made by users.
Save/Restore Layout
The Pivot Grid's layout can be saved to and restored from the system registry, an XML file or INI file or a stream.