The DevExpress Pivot Grid is a comprehensive data analysis, data mining, and visual reporting solution for ASP .NET applications and allows you to create a pivot table for multi-dimensional data analysis. Using the Pivot Grid, large amounts of data can be summarized and represented in a cross-tabular format that can be sorted, grouped and filtered. End-users can customize the layout of the report based on their analysis requirements using simple drag-and-drop operations. The Pivot Grid also supports printing and exporting to various file formats (such as PDF, XLS or XLSX), as well as data visualization using the DevExpress Chart Control or KPI. This section contain documentation about the ASPxPivotGrid control.
Create a first Pivot Grid and bind it to data using online tutorials, videos and product documentation.
OLAP Data Source describes how to connect to a cube in a Microsoft Analysis Services server (OLAP server) and provides information on the PivotGridControl functionality limitations imposed when bound to an OLAP server.
Database Server Mode topic describes how to connect a Pivot Grid to a database with a large number of records without performance loss.
Unbound Fields topic describes the capability to create fields that are not bound to any data source fields, and populate them with data manually.
This section illustrates the powerful features that help to organize, analyze and interpret Pivot Grid's data.
Integration with the Chart Control describes how to visualize data displayed in the pivot grid using the Chart Control. Set a Pivot Grid control as the Chart control data source and display your data as bars, areas, lines and many other forms. Here you will learn how to customize a Chart control to display Pivot Grid data.
Key Performance Indicators (KPIs) introduces a Microsoft Excel-inspired conditional formatting feature that allows you to change the appearance of individual cells based on specific conditions. This feature helps to highlight important information, identify trends and exceptions, and compare data using the collection of format rules. Here you will learn how to change appearances of Pivot Grid Control cells depending upon cell data or an expression.
PivotGridControl allows you to format the display text of its data cells, field values, summaries, totals and grand totals before they are displayed on screen. You can apply standard format strings or implement a custom formatter. This section provides general information about data formatting.
This section describes the ways in which you can manage the layout of the ASPxPivotGrid control. This includes changing the layout of fields and data cells, saving and restoring the grid's overall layout, etc.
Field Groups topic provides information on arranging fields into groups. These fields cannot be separated by end-users by dragging one of them to a different area or hiding it on the Customization Form.
Customization Form is a window or a standalone control that allows end-users to easily customize the pivot grid layout by hiding and rearranging fields.
Save and Restore Layout section describes how to save the information on the Pivot Grid's layout, and then restore it. This information includes all the settings that control the visibility and size of visual elements, their appearance settings, filtering, sorting, etc.
Paging and Scrolling section provides information on how to navigate through data using the pager and scroll bars.
The appearance of the Pivot Grid control can be customized in a number of ways. You can customize style settings for each cell individually, use the control's style settings or use templates. This section provides all the necessary information about styling and templating.
This section describes design-time editors that enable you to customize field, layout and appearance settings. For example, the ASPxPivotGrid Designer allows you to customize fields and groups and manage client-side events.
To get more information about the Pivot Grid control, see the following sections.