ASP.NET Web Forms Pivot Grid (Pivot Table) Control

Data binding

The ASP.NET Web Forms Pivot Table simulates the pivot table feature of Excel. The data source for the control can be an OLAP or pivot data source.

• OLAP Data Sources: Supports SSAS, Mondrian, ActivePivot and Oracle.
• Pivot Data Sources: Supports DataTable, DataView, DataSet from SQL databases or collections like IEnumerable, ICollection, IList, List and ArrayList.

Pivot table field list

The pivot table field list, also known as the pivot schema designer, is a powerful tool that allows you to create and manage a pivot table with either multidimensional or pivot data sources. End users can drag fields and filter them at runtime to create pivot reports as needed.

• Pivot table field list example

Grouping fields

Group fields, also known as grouping bar is automatically populated with fields from the bound data source. It allows end users to drag fields, filter and sort them, and alter the pivot report at runtime.

• Grouping fields example
• Grouping fields documentation

Drill down and drill up

Built-in support for drill down (expand) and drill up (collapse) to visualize the grid information in both abstract and detailed views.

• Drill operation example

Defer update

Users can refresh the control on demand instead of during every UI interaction in ASP.NET Web Forms Pivot Table.

• Defer update example
• Defer update documentation

Editing and updating

Users can edit values at runtime and save their changes to the underlying data source, thereby reflecting the update in all the cells.

• Editing and updating example
• Editing and updating documentation

Calculated fields

The calculated field, otherwise known as unbound field generates unique field with our own calculated value by executing a simple user-defined formula. This functionality is applicable only for pivot data sources.

• Calculated fields example
• Calculated fields documentation

Expression fields

Expression fields generate data by executing a user-defined expression. The generated data is specific to a few fields from the underlying data source. You can apply this only for pivot data sources and perform though reports in code-behind.

Drill through

The drill-through feature easily obtains a list of raw items for a particular value cell or summary cell.

• Drill-through example
• Drill-through documentation

Conditional formatting

Allows users to define conditions that, when met, format the font, color, and border settings, of values and summary cells.

• Conditional formatting example
• Conditional formatting documentation

Number formatting and date formatting

Number formatting and date formatting helps to transform the appearance of the actual cell value. This functionality is applicable only for pivot data sources.

• Number formatting example
• Number formatting and date formatting documentation

Totals

The subtotals and grand totals are calculated automatically by the pivot engine, inside and displayed in the pivot grid. It helps users to make decision based on the totals. Also, user can show or hide subtotals and grand-totals for rows and columns.

Save and load reports

You can save reports from the current session as a stream in a database for later use.

• Save and load reports example
• Save and load reports documentation

Exporting

You can export a ASP.NET Web Forms Pivot Table to Excel, Word, and PDF documents.

• Exporting example
• Exporting documentation

Web accessibility

Our ASP.NET Web Forms Pivot Table has been developed to make it possible for people with disabilities to use and interact with the control.

Cross-browser and cross-platform

The ASP.NET Web Forms Pivot Table will work on all major browsers across Windows and macOS. It is written in jQuery to provide the same working experience on popular browser like Chrome 17+, Firefox 22+ and Internet Explorer 8+. It also works with various platforms like ASP.NET MVC, ASP.NET Core, TypeScript, PHP and JSP.