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
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
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.
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.
"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
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
Create custom Office inspired contextual menus.
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.
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.