CartLog In

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
DevExpress Pivot Grid Control - Performance Comparison

Unrivaled Performance

Our .NET Pivot Grid control is built for speed. See how it compares to the competition and why we think it has no equal in the marketplace.

Learn More

Learn More about Our ASP.NET Pivot Grid

Learn More

PerformanceData ShapingLayout Customization

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.

DemoDocumentation

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.
DemoDocumentation

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.
DemoDocumentation

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.
DemoDocumentation

Calculated Fields

Data binding made easy.

Calculated Fields

Create Calculated 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.
DemoDocumentation
"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.

DemoDocumentation

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.

DemoDocumentation

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.

DemoDocumentation

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.
DemoDocumentation

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.
DemoDocumentation

Charts Integration

Present the pivot grid's information graphically.

Charts Integration

Visualize data displayed in the pivot grid using the DevExpress Chart.
DemoDocumentation
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.
DemoDocumentation

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.
DemoDocumentation

Custom Popup Menu

Create custom Office inspired contextual menus.

Custom Popup Menu

Custom Popup Menu
Create custom Office inspired contextual menus.
Demo

Compact Layout

Compact Layout for Hierarchical Row Values

Compact Layout

When there are a lot of data fields in a Row Area, row values can be displayed in a tree. Set the RowTotalsLocation property to PivotRowTotalsLocation.Tree and get more space horizontally.
DemoDocumentation

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.

DemoDocumentation

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.
Documentation

Start your free 30-day trial today!

Download our fully-functional 30-day trial today and
experience the DevExpress difference today.

 

Download Free Trial

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
DirectX Form
WPF Controls
TreeView
Sunburst
Blazor UI Components
Accordion
Grid Layout
Stack Layout
JavaScript - jQuery, Angular, React, Vue
ASP.NET Web Forms Controls
Printing & Exporting
ASP.NET MVC Extensions
Printing & Exporting
ASP.NET MVC Client-Side Controls
ASP.NET Core Controls
ASP.NET Core Office Controls
ASP.NET Bootstrap Controls
Themes and Skinning
Reporting
WinForms Document Viewer
WinForms End-User Report Designer
ASP.NET Web Forms Document Viewer
ASP.NET Web Forms End-User Report Designer
ASP.NET MVC Document Viewer
ASP.NET MVC End-User Report Designer
ASP.NET Core Document Viewer
ASP.NET Core End-User Report Designer
Blazor Document Viewer
Blazor End-User Report Designer
WPF Document Viewer
WinUI Document Viewer
WPF End-User Report Designer
Angular Document Viewer
Angular End-User Report Designer
XPO - ORM Library
Office File API (Basic)
.NET Standard 2.0+ Support (Windows, Linux, MacOS)
Office File API (Complete)
.NET Standard 2.0+ Support (Windows, Linux, MacOS)
Business Intelligence Dashboard
XAF - Cross-Platform .NET App UI
.NET App Security & Web API Service
Entity Framework Core ORM Support
XPO ORM Support
Role-based Access Control & Permission Management
ASP.NET Core Web API / OData Service for CRUD and Authorization
Administrative UI to Manage Users and Roles at Runtime
Localization Service Endpoints
Xamarin.Forms UI Controls with Support
.NET MAUI Controls with Support
.NET MAUI Project Templates
CodeRush for Visual Studio
VS 2022 Support
VS 2019 Support
VS 2017 Support
VS 2015 Support
C#, VB.NET, XAML
Source Code *
WinForms Controls
ASP.NET Controls
WPF Controls
JavaScript - jQuery, Angular, React
Blazor UI Components
Reporting
XPO - ORM Library
Office File API
Data Visualization Dashboard
XAF - Cross-Platform .NET App UI
Technical Support
Priority Support

* DevExpress does not include/ship source code for certain products, including CodeRush, TestCafe Studio, and Report & Dashboard 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 Web Forms 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

Web Demos

Data Management
GridViewCardViewGanttFilter ControlTree ListVertical Grid
Office Inspired
Excel-inspired SpreadsheetHTML EditorOutlook-inspired ShedulerSpell CheckerVisio-inspired DiagramWord-inspired Rich Text Editor
Analytics & Reporting
ChartsGaugesPivot GridWeb Document ViewerWeb Report DesignerWeb Reporting
Site Navigation
Ribbon UIFloating Action ButtonMenu & ToolbarsNavigation BarSiteMapTab ControlTag Cloud ControlTitle IndexTree View
Page Layout & Popups
DockingForm LayoutHint ControlLoading PanelPanelPopupRound PanelSplitter
Data & Image Navigation
Data ViewHeadlineImage GalleryImage SliderImage ZoomNews ControlPager
Cloud Storage Support
AmazonAzureDropboxGoogle DriveOneDriveSharePoint
File Management
File ManagerFile Upload
Data Editors
ButtonCalendarCaptchaCheck BoxColor EditorComboboxDate & Time EditorsImageList EditorsLookupsProgress BarSpin/Numeric EditorToken BoxTrack Bar
2D/3D Data Visualization
AreaBarsBox PlotBubbleCandle Stick & StockFunnelGanttPie & DoughnutPoint & LineRadar & PolarRangeTornadoWaterfall
Multi-Use Site Controls
CallbackCallback PanelHidden FieldObject ContainerRating ControlTimer
Themes & Icons
Application ThemesIcon Library

Free 30-Day TrialSee What's New

Best in Class Tools

DevExpress is honored to have been voted best in class 20 times in this year's Visual Studio Magazine Reader's Choice Awards.

Experience the DevExpress difference and see why your peers consistently vote our products #1. With our Universal Subscription, you will build your best, see complex software with greater clarity, increase your productivity and create stunning applications for Windows, Web and your Mobile world.

x20
x20
x18
x19