Top New Features

Based on great feedback from users such as yourself, our pivot grid continues to evolve. See what we've been up to in recent release cycles.

Read More

Reporting Made Easy

The DevExpress Pivot Grid 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.

Read More

Chart Integration

Visualize data displayed in the pivot grid using the DevExpress Chart Control and let users create reports that communicate information effectively.

Watch the Video

Learn More about Our WinForms Pivot Grid Control

Learn More

Performance & Data Access
Asynchronous Mode
Eliminate 'screen-freeze' during data-intensive operations.
Asynchronous Mode
With this data loading mode, you can create solutions that remain responsive to end-user actions regardless of the data analysis task complexity. Whenever you bind the control to a large dataset, this asynchronous loading mode fetches data on-demand, in a background thread. This ensures that the UI does not freeze during data-intensive operations.
Server Mode
Blazing fast and always ready.
Server Mode
Our flexible data loading options allow you to display, edit and shape data against hundreds of thousands of records at incredibly fast speeds. This unmatched performance is achieved by loading data on demand and executing time-intensive data operations on the server when appropriate.
Unbound Fields
Data binding made easy.
Unbound Fields
You can create Unbound Fields which are not bound to any field in the control's underlying data source. These fields are populated manually and can display any information not suitable to be stored in the bound dataset.
"In my lengthy experience as a programmer, I have never before encountered such an efficient and friendly support team. Thank you DevExpress!" Richard McNaught
Data Shaping & Visualization
Sorting
Sort by Summary & Top Values
Sorting

End-users can sort by summary through the context menu by right-clicking an innermost column or row header. Sorting by Summary is available for all fields displayed within the Column Header Area or Row Header Area.

To focus on a smaller portion of a large amount of your Pivot Table data for in-depth analysis, you can limit the number of field values to the specified number of topmost values according to the sort order.

Grouping
Group data against an unlimited number of fields.
Grouping
Grouping

Group data to quickly see subtotals for a specific set of items to analyze.

For instance, it's possible to create two fields and bind them to the same 'Date' field. The first field can group data by years, the second field - by months.

Filtering
Show the data you want and hide the rest.
Filtering

End-users can build simple filter criteria and apply them using a field's filter drop-down.

The built-in Prefilter (Query/Filter Builder) gives you and your users more granular control over filter construction. The Prefilter displays filter criteria as a tree structure, where nodes represent simple filter conditions. If the filter criteria consist of multiple filter conditions, the Prefilter contains multiple nodes linked by logical operators into groups.

Summaries & Aggregates
Automatic compute summaries across all Pivot Grid fields.
Summaries & Aggregates
Summaries & Aggregates

We've made it easy for you to use aggregate functions and compute data summaries for rows and columns displayed within our Pivot Grid. The following built-in aggregate functions are available: Average, Count, Max, Min and Sum.

You can also implement your own algorithms and calculate summaries manually.

Totals
Automatic Total and Grand Total calculation.
Totals
Totals

The Pivot Grid control supports three types of totals: automatic totals for each data group, grand totals, and custom totals.

Running totals allow you to display cumulative values that correspond to the specified column or row fields.

Conditional Formatting
Highlight cell values for maximum data clarity.
Conditional Formatting
Microsoft Excel inspired Conditional Formatting feature allows you to highlight cells/rows based on specified criteria without writing a single line of code. Cells/rows can be highlighted with data bars, icons and predefined color scales. At runtime, end-users can easily apply style conditions by activating the popup menu.
"Still discovering new and exciting possibilities while being a customer for +5 years - best .net developer tools on the planet like emoticon." Andy Luyten
Editing & UI Customization
In-Cell Editing
Use any of our 20+ Data Editors.
In-Cell Editing

Over 20 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
Input Validation
Reduce data entry errors and visually inform users of invalid input.
Input Validation
Specify your validation rules and limit the values that can be entered into individual fields. If a rule fails, the control automatically provides users with visual feedback and forces the correct the input.
Field Customization
Runtime column/field customization made easy.
Field Customization
End-users can customize column and row layout at runtime. The built-in Column Chooser dialog has been designed to 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.
Save/Restore Layout
Save and restore runtime grid customizations made by users.
Save/Restore Layout
Any end-user customizations to the control layout can be saved to and restored from the system registry, an XML file or a stream.
Best Fit
Adjust column width to fully display cell values.
Best Fit
End-users can resize columns to the optimal width to fully display cell values by double-clicking a column's right border.
"You guys have done a phenomenal job on all of your versions. Thank you for providing such a great product and such great support." Mark C
OLAP, Export & Printing
OLAP Drill Down
Get records used to calculate cell values.
OLAP Drill Down
The PivotGrid allows you to see the data behind a summarized value. Use the controls's CreateDrillDownDataSource method to get the full set of data that backs up that value.
OLAP KPI
Microsoft Analysis Services Support
OLAP KPI
Display KPI (Key Performance Indicator) values - a collection of calculations associated with a measure group in a cube, with server-defined or client-defined graphics.
Data Export
Export data to XLS, PDF, HTML, TXT, and more formats.
Data Export

Use built-in API to export data to a file for further sharing or processing. Save your data as XLS, XLSX, XPS, PDF, TXT, MHT, CSV, HTML or an Image file.

WYSIWYG Printing
The easiest way to printing the contents of your Pivot Grid.
WYSIWYG Printing

Turn the data you see on screen into a printed report with a simple method call.

Specify the printed report's appearance using a dedicated Print Options dialog.

Buy this product as part of the following subscription packages.

We are so confident in our products and services that we back them with a 60 day no questions asked money back guarantee. If within the first 60 days of ownership you are not satisfied with the capabilities of our tools, you can request a full refund of the amount you paid to DevExpress by writing to clientservices@devexpress.com or by calling +1 (818) 844-3383.

Best Value
WinForms Controls
WPF Controls
ASP.NET WebForms Controls
Printing & Exporting
ASP.NET MVC Extensions
Printing & Exporting
ASP.NET Bootstrap Controls
Themes and Skinning
JavaScript - jQuery, Angular, React
JavaScript - ASP.NET MVC & Core
UWP Controls
Reporting
WinForms Report Viewer
WinForms End-User Report Designer
HTML5 Report Viewer
ASP.NET WebForms Report Viewer
ASP.NET WebForms End-User Report Designer
ASP.NET MVC Report Viewer
ASP.NET MVC End-User Report Designer
ASP.NET Core Report Viewer (CTP)
ASP.NET Core End-User Report Designer (CTP)
WPF Report Viewer
WPF End-User Report Designer
Office File API (Basic)
Excel Export Library
Word Processing Document API (DOC, RTF)
Office File API (Complete)
Native Mobile UI Controls
CodeRush
C#, VB.NET, XAML
CodeRush Classic
VS 2015 Support
VS 2012, 2013 Support
C#, VB.NET, XAML
HTML, ASP.NET, CSS, Razor, JavaScript
Source Code *
WinForms Controls
ASP.NET Controls
WPF Controls
UWP Controls
JavaScript - jQuery, Angular, React
XPO - ORM Library
Office File API
Data Visualization Dashboard
eXpressApp Framework
Technical Support
Priority Support

* DevExpress does not include/ship source code for certain products, including CodeRush, TestCafe, and Report Server.

Additional Info

WinForms Themes and App Skins

The DevExpress WinForms Subscription ships with 50 custom designed and highly polished themes for your next WinForms application. You can use each of these themes easily, without modification or manipulate them using our free WinForms Skin-Theme Editor application. Learn more

Touch Enabled User Experience

Deliver elegant, touch-enabled WinForms applications using the platform you know and love. The WinForms Subscription helps you leverage your current investments and address customer needs via a comprehensive range of WinForms controls that support touch on both Windows 7 and Windows 10.

Sec 508 and Accessibility

The DevExpress WinForms Subscription makes it easy to create WinForms applications that meet government regulations regarding web accessibility. Sec 508 and Accessibility Guidelines 1.0 support is available for key DevExpress WinForms controls.

Straightforward Localization

All DevExpress WinForms controls can be localized using satellite resource assemblies. DevExpress delivers satellite assemblies for a large variety of languages and cultures. To help you get started, resource files for four cultures are included in our installation: German, Japanese, Russian, and Spanish. If you need to modify our shipping resources or create satellite assemblies for a different language, simply use our Online Localization Service, a free tool for our active WinForms subscribers. Online Localization Service

Testing Support

The DevExpress Universal Subscription includes built-in support for Microsoft's CodedUI. Unlike many vendors claiming support for Coded UI through the simple use of MSAA, DevExpress controls go the extra mile to make certain that individual controls fully comply with Microsoft's testing framework. We don't simply support Coded UI; we support it to the maximum extent possible. Note: CodedUI support requires purchase of the DevExpress Universal Subscription. Learn more

MVVM Framework

The DevExpress MVVM Framework ships with features that are absent in WinForms, but essential to MVVM development. These missing features include bindings, commands, UI triggers, behaviors etc. Our Framework includes all of these along with a straightforward API to make WinForms app development more efficient. Learn more