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 demands placed upon the Pivot Grid. Whenever you bind the DevExpress Pivot Grid to a large dataset, this asynchronous loading mode fetches data on-demand, in a background thread. This ensures that the Pivot Grid 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 because the Pivot Grid allows you to load data on demand and move time-intensive data shaping operations to the server when appropriate.
Unbound Fields
Data binding made easy.
Unbound Fields
The DevExpress WinForms PivotGrid control allows you to create Unbound Fields which are not bound to any field in the control's underlying data source. These fields should be populated manually. For instance, they can display custom information and even use summary results calculated by the pivot grid.
"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 PivotTable 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
The Pivot Grid allows you to group fields. This lets you 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 '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
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
The Pivot Grid control supports three types of totals: automatic totals (subtotals), custom totals and grand totals.
Running totals allow you to calculate cumulative values that correspond to the specified column or row fields.
Conditional Formatting
Highlight cell values for maximum data clarity.
Conditional Formatting
The DevExpress Pivot Grid ships with Microsoft Excel inspired Conditional Formatting support. This powerful 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 Pivot Grid's 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. Use the visualization power of the DevExpress WPF Pivot Grid to provide user feedback when data does not pass rule tests.
Field Customization
Runtime column/field customization made easy.
Field Customization
The DevExpress WinForms 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.
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 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 Drill Down
Get records used to calculate cell values.
OLAP Drill Down
The DevExpress WinForms PivotGrid allow you to see the data behind a summarized value. Use the pivot grid's CreateDrillDownDataSource method to get the full set of data that backs up that value.
OLAP KPI
Microsoft Analysis Services Support
OLAP KPI
The DevExpress WinForms Pivot Grid allows you to 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
The DevExpress Pivot Grid supports numerous file formats to import and export data: XLS, XLSX, XPS, PDF, TXT, MHT, CSV, HTML and Image formats.
WYSIWYG Printing
The easiest way to printing the contents of your Pivot Grid.
WYSIWYG Printing
Turn the contents of your Pivot Grid into a printed report with a simple method call.
The Print Options dialog provides printing options that control the Pivot Grid's appearance when it is printed.