Built for Your Development Needs
WebForms and MVC

It’s Your Choice. The ASPxPivotGrid is available as a WebForms Control or an MVC Extension. Both ship as part of the DevExpress ASP.NET Subscription.

Fully Customizable
Actionable On-Screen Analytics

The DevExpress ASP.NET 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.

Powerful, Fast and Efficient
OLAP Support and Unbound Fields

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

Unbound Fields: You can create unbound fields and populate them with data as your needs dictate.

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 allows its contents to be visualized using the DevExpress ASP.NET Chart Control.

Export Data: The ASPxPivotGrid 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.

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.

On-Screen Shaping and Computation
Data Summaries, Sorting and Filtering

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: The ASPxPivotGrid provides multiple modes to sort field values (by values, display text, summaries, etc.).

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.