Web Themes

In addition to over 20 built-in Themes, you can use style properties and CSS for appearance customization. Templates are also available for fine-grain control over UI elements and control layout.

Demo

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.

Demo

Chart & Map Integration

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

Demo

Learn More about Our ASP.NET Pivot Grid

Learn More

Performance & Data Access
The DevExpress ASP.NET Pivot Grid 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.
Server Mode
Very Large Datasets. Blazing fast data processing.
Server Mode
Server Mode

Our Pivot Grid control is powered by a proprietary server-side data processing engine so that regardless of dataset size, users can shape and analyze mission critical information at lightning speed.

The Pivot Grid can be bound to any LINQ to SQL data sources via its LinqServerModeDataSource Data Provider.

Drill Down
Get records used to calculate cell values.
Drill Down
You can 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
Microsoft Analysis Services data sources are fully supported.
OLAP
OLAP
Microsoft Analysis Services (OLAP) data sources are fully supported by the ASP.NET Pivot Grid. When bound to this data source type, the Pivot Grid automatically delegates all data management and calculations to the server. Supported data providers include: OLEDB for OLAP, ADOMD.NET and XMLA.
OLAP KPI
Key Performance Indicators
OLAP KPI
You can 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.
Unbound Fields
Data binding made easy.
Unbound Fields
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.
"The response from DevExpress is always prompt, detailed and typically includes a code sample. Have used their suite for 4 years and never regretted my choice for one second." Jim Thomas
Data Shaping & Visualization
With its powerful data architecture, our ASP.NET Pivot Grid 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.
Sorting
Sort by Summaries & 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.

Totals & Running Totals
Automatic and Custom Total calculation.
Totals & Running Totals

Our Pivot Table control automatically calculates grand totals for each row and column. Additionally, totals are automatically calculated for each value group. The type of the automatic totals always matches the type of the summaries calculated in cells. Thus, automatic totals give you a more general data view while you still displaying the details. In this demo, you can use a number of view options to control the availability of totals.

Row Totals are rows that display sub-totals calculated for outer row fields. Column Totals are columns that display sub-totals calculated for outer column fields.

Automatic and custom totals are also supported. Automatic totals are calculated using a summary function specified by a corresponding data field. Custom totals can be calculated using any summary function. It's possible to calculate multiple custom totals against a data field.

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.

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.
Prefilter
Create complex filter expressions.
Prefilter
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.
Charts Integration
Present the pivot grid's information graphically.
Charts Integration
Visualize data displayed in the pivot grid using the DevExpress Chart.
There are very few words to describe how impressed I am with every iteration of the DevExpress toolset. This group does not rest on their laurels; I doubt they ever rest.George K Fahnbulleh
Appearance & Layout Customization
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.
Field Customization
Runtime column/field customization made easy.
Field Customization
The DevExpress ASP.NET Pivot Grid allows end-users to customize column and row layout at runtime. The Field List dialog can add/remove both columns and rows with simple drag & drop operations.
Custom Popup Menu
Create custom Office inspired contextual menus.
Custom Popup Menu
Custom Popup Menu
Create custom Office inspired contextual menus.
Compact Layout
Compact Layout for Hierarchical Row Values
Compact Layout
Compact Layout for Hierarchical Row Values
Data Paging & Virtual Scrolling
Navigate data rows with easy-to-use, SEO fiendly data pager.
Data Paging & Virtual Scrolling

From data scrolling using a scroll bar to SEO friendly paging, virtual scrolling and customizable data pager settings, everything you'll need is built-in and ready to use.

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.

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
ASP.NET Core 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 Report Viewer
ASP.NET End-User Report Designer
MVC Report Viewer
MVC End-User Report Designer
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)
Spreadsheet Document API (XLSX, XLS)
Excel Export Library
Word Processing Document API (DOC, RTF)
PDF Document API
DevExpress Snap Report API
Barcode Generation API
Zip Compression and Archive API
Unit Conversion API
Native Mobile UI Controls
Charting Library
iOS Controls
Android Controls
Xamarin Wrappers
CodeRush
VS 2017 Support
VS 2015 Support
Roslyn-Powered Superior Performance
C#, VB.NET, XAML
CodeRush Classic
VS 2015 Support
VS 2012, 2013 Support
C#, VB.NET, XAML
HTML, ASP.NET, CSS, Razor, JavaScript
Coded UI Support for WinForms Controls
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

Customizable ASP.NET Themes

The DevExpress ASP.NET Subscription ships with 20+ highly polished themes for your next web application. You can use each of these themes easily, without modification or manipulate them using our free ASP.NET Theme Builder application. See Demo

Sec 508 and Accessibility

The DevExpress ASP.NET Subscription makes it easy to create web applications that meet government regulations regarding web accessibility. Sec 508 and Web Content Accessibility Guidelines 1.0 support is available across our entire DevExpress ASP.NET Product Line. Read more

Touch and Mobile Device Enabled

Deliver elegant, touch-enabled ASP.NET and MVC web applications using the platform you know and love. The ASP.NET Subscription helps you leverage your current investments and address customer needs via a comprehensive range of WebForms Controls and MVC Extensions that support touch on iOS Safari, Android and Internet Explorer 10.

AJAX Enabled with Rich Client-Side API

Each and every control provides an ability to update the control using callbacks, eliminating the need to re-load the entire page. This callback functionality allows you to optimize how data is transferred to the client. We also offer you a comprehensive client-side API, along with the ability to handle events on the client side. With our ASP.NET components, you have full control over the control's behavior via client functions.

Fast and Lightweight with XHTML Compliance

DevExpress controls are optimized for exceptional performance and efficient memory use without the loss of functionality or features. DevExpress ASP.NET controls also support optimizations like HTML compression, callbacks, image sprites, resource caching and sharing. Key ASP.NET controls in this subscription use semantic HTML to keep output clean and minimal. The semantic HTML markup means that web pages are lighter and faster, more search engine friendly and provide improved accessibility for screen readers.

Straightforward Localization

All DevExpress ASP.NET AJAX Controls can be easily localized using satellite resource assemblies. DevExpress delivers satellite assemblies for a large variety of languages and cultures. To make it easy to get started, resource files for four cultures are included to 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 ASP.NET subscribers. Online Localization Service