When it comes to data mining and multi-dimensional analysis, an advanced and feature complete pivot table control provides business users unrivaled insights into daily operations. Until the release of the ExpressPivotGrid, however, using the pivot capabilities of products like MS Excel® meant introducing "out-of-process" solutions with Automation objects.

The ExpressPivotGrid Suite was engineered from the ground-up to blow away the limitations posed not just by these out-of-process solutions, but to radically improve the way in which data-centric applications deliver information to end-users. With its powerful data architecture, the ExpressPivotGrid is able to slice and dice information efficiently and provide customers with an extremely intuitive end-user experience. It delivers numerous layout customization options with total end-user control over each individual on-screen report. Regardless of the perspective, data can be rendered to answer business questions - and best of all - it allows you to focus on business rules rather than creating dozens and dozens of reports.

Actionable On-Screen Analytics:
Actionable On-Screen Analytics

As you browse these web pages and begin using the ExpressPivotGrid within your applications, you will discover that when it comes to ease-of-use and flexibility, the ExpressPivotGrid has no equal in the marketplace. Fact is that when it comes to data analysis and data mining, the ExpressPivotGrid is the only product that empowers your end-users to solve their business needs without being forced to use cumbersome and overly complex reporting solutions.

The DevExpress VCL Pivot Grid Control has the power to convert hard to read and difficult to dissect dataset information into compact and summarized visual reports so your application can efficiently address real-time business analysis needs. 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.

OLAP Support:
OLAP Support

Microsoft Analysis Services (OLAP) data sources (OLE DB Provider) are fully supported by the DevExpress VCL Pivot Grid. When bound to this data source type, the ExpressPivotGrid automatically delegates all data management and calculations to the server.

Group Values and Hierarchical Data Display:
Group Values and Hierarchical Data Display

Group Values: Provide end-users with unique levels of detail for more flexible data analysis and reduce the amount of effort required to understand business trends by using summarized on-screen pivot table values.

Hierarchical Data Display: Brings 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.

Drill-Down, Visualize, Print and Export:
Drill-Down, Visualize, Print and Export

Data Drill-Down: With specially designed dataset components, you can allow your end-users to explore the data underlying all calculated cell values.

Charting: The Pivot Grid Control allows its contents to be visualized using the DevExpress VCL Grid Chart View.

Print and Export Data: Instant Cross-Tab Reports in printed form, PDF, XLSX, XML and numerous other file formats. ExpressPivotGrid is not just for on-screen data analysis. With it, you can export data to numerous formats and render its contents to paper just like a traditional WYSIWYG report. Multi-cell selection and data export via the clipboard are also supported.

Data Summaries and Sorting:
Data Summaries and Sorting

Automatic and Manually Calculated 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.

Sorting, Top or Bottom Numbers: A two-way approach to data navigation makes data analysis more efficient. End-users can locate data by a specific value or find a value by its data.

Download the Free Trial

Includes 30 days of free tech support

Buy it Today

Part of the Express Grid Pack
Pricing starts at only
Get started today and see why tens of thousands of developers
worldwide choose DevExpress.


100% VCL. 100% DevExpress.

The 210+ controls and libraries that make up the DevExpress VCL Subscription have been engineered to address the UI, analytics and reporting requirements for a broad range of solutions targeting Windows®. If you are a Delphi/C++Builder developer and are ready to experience the #1 selling control library on the market today, download your free trial today or explore the individual controls that ship as part of this subscription below.
Outlook® Style data shaping built-in.
Fully customizable Ribbon, Toolbars and Docking.
Instant reporting - render and export your UI.
Outlook® Style scheduling and calendars.
Excel® style multi-dimensional pivot table.
Hybrid treeview and list view control.
A vertical data grid and Delphi style Object Inspector in one.
Office® style spell checker.
Outlook® Style app navigation controls.
Create advanced app wizards with ease.
The Windows 8 touch-first Tile UI.
Create forms faster, with runtime customization.
From Office to MacOS, a theme for all seasons.
Microsoft Excel style spreadsheet control.
Unmatched data editing options.
Different map types and amazing interactivity.
Data visualization for dashboards.
Visio® style hierarchical chart control.
Visualizes workflow diagrams & network topologies.
Multi-purpose components for VCL.

Chat is one of the many ways you can contact members of the DevExpress Team.
We are available Monday-Friday between 7:30am and 4:30pm Pacific Time.

If you need additional product information, write to us at or call us at +1 (818) 844-3383


DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, Delphi, HTML5 or iOS & Android development. Whether using WPF, ASP.NET, WinForms, HTML5 or Windows 10, DevExpress tools help you build and deliver your best in the shortest time possible.

Copyright © 1998-2018 Developer Express Inc.
All trademarks or registered trademarks are property of their respective owners