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 DevExpress PivotGrid for .NET, however, using the pivot capabilities of products like MS Excel® meant introducing "out-of-process" solutions within managed applications.

The XtraPivotGrid Suite was engineered from the ground-up to eliminate the limitations imposed by these out-of-process solutions and to radically improve the way in which data-centric applications deliver information to end-users. With its powerful data architecture, the XtraPivotGrid is able to slice and dice information efficiently and intuitively present it to end-users. It delivers numerous layout customization options with total end-user control over each individual on-screen report.

: DevExpress WinForms Pivot Table

Fully Customizable
Actionable On-Screen Analytics

The DevExpress WinForms 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.

Transform Plain-Table Data into a Pivot Report
Use Multiple Data Fields in a Report
Use Manually Calculated Fields
Show Trends Using the Built-in Summary Variation Feature


: DevExpress WinForms Pivot Table

Powerful, Fast and Efficient
OLAP Support and Asynchronous Data Processing

Microsoft Analysis Services (OLAP) data sources are fully supported by the WinForms Pivot Grid. When bound to this data source type, the XtraPivotGrid automatically delegates all data management and calculations to the server. Supported data providers include: OLEDB for OLAP, ADOMD.NET and XMLA.

Asynchronous Data Processing: When asynchronous data processing mode is enabled, your application stays responsive while the pivot grid performs necessary calculations.

Unbound Columns and Expression Editor: You can now create unbound fields and populate them with data as your needs dictate.


: DevExpress WinForms Pivot Table

Integrated Toolset
Drill-Down, Visualize, Print and Export

Data Drill-Down: With just a single line of code, 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 Chart Control.

Print and Export Data: Instant Cross-Tab Reports in printed form, PDF, XLS, and numerous other file formats. XtraPivotGrid 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.


: DevExpress WinForms Pivot Table

Summarize with Clarity
Group Values and Hierarchical Data Display

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

Hierarchical Data Display: Field values are automatically arranged into a tree structure with expandable parents. When necessary, end-users are free to expand and collapse child groups in order to view information in a more summarized format.


: DevExpress WinForms Pivot Table

On-Screen Shaping and Computation
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: The Pivot Grid makes data analysis more efficient by enabling a two-way approach to data navigation. End-users can locate data by a specific value or find a value by its data.


: DevExpress WinForms Pivot Table

Flexible Data Management
Built-in Filtering, Editing and Validation

End-User Data Filtering: With the Pivot Grid's built-in visual filtering option, your end-users can manipulate reports on the fly using an easy to understand data filter dialog.

Data Editing and Validation: The Pivot Grid allows end-users to perform 'what-if' analysis by editing summary values displayed in data cells.


Subscribe Today

It's Your Choice: All DevExpress WinForms Controls can be purchased as part of the following Subscriptions:
Universal Subscription
DXperience Enterprise
WinForms Controls

What's New in 2012

The best keeps on getting better. Our newest WinForms controls and features include:

WinForms Tech Library

Explore the power of the DevExpress WinForms product line at your pace with the following online technical resources:

Our Awards


              DevExpress Awards : Windows IT Pro Community Choice
              DevExpress Awards : Visual Studio Magazine Readers Choice
              DevExpress Awards : SDTimes 100
              DevExpress Awards : ComponentSource Bestselling Publishers
DevExpress WinForms Subscription
100% WinForms. 100% DevExpress.
The 110+ controls and libraries that make up the DevExpress WinForms Subscription have been engineered to address the UI, analytics and reporting requirements for a broad range of solutions targeting Windows®. If you are a WinForms developer and are ready to experience the #1 selling WinForms control library on the market today, download your free trial today or explore the individual controls that ship as part of this subscription below.
Reporting
Including an integrated Runtime Report Designer.
Charting
Comprehensive Collection of 2D and 3D Charts
Data Grid & Editors
Outlook® Style data shaping built-in.
Snap
Word Inspired Reporting platform.
Ribbon, Menu, Docking
Fully customizable Outlook® style Ribbon.
Pivot Grid
Excel® style multi-dimensional pivot table.
Scheduler
Outlook® Style scheduling and calendars.
Tree List
Hybrid treeview and list view control.
Gauges
Analog and digital gauges with 150 built-in presets.
Rich Text Editor
Word® style WYSIWYG word processing.
Property Grid
A vertical data grid and VS style property grid in one.
Layout Manager
Create forms faster, with runtime customization.
Tile Control
The Windows 8 touch-first Tile UI.
Navigation Bar
Outlook® Style app navigation controls.
Editors & Controls
Unmatched data editing options.
Printing-Exporting
Instant reporting - render and export your UI.
Spell Checker
Office® style spell checker.
Wizard Control
Create advanced app wizards with ease.
Application Skins
From Office to MacOS, a theme for all seasons.
More from DevExpress
Live Chat
Have a pre-sales question?
Need assistance with your evaluation?
We are here to help.
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, require pre-sales assistance, or want help with your order, write to us at info@devexpress.com or call us at
+1 (818) 844-3383.