We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Overview

The pivot grid control organizes and summarizes business data and displays the result in a cross-table format. A high volume of pivot data can be loaded without any performance degradation using row and column virtualization.


Data binding

The pivot table can be bound to data in the form of JavaScript object array collections. It uses the Essential JS 2 data manager explicitly to handle remote data and data processing.

ASP NET MVC pivot table control renders with relational data source in JSON format

JavaScript array collection

An array of JavaScript objects can be bound to the pivot table, allowing it to work smoothly in applications.

Remote data binding, aka remote web service and RESTful API, in ASP NET MVC pivot table control

Remote data binding

Binding the pivot table with RESTful services allows data from services to be consumed using the Essential JS 2 data manager explicitly. It supports various data adaptors such as JSON, OData, ODataV4, URL, and Web API for working with a particular data service.


Summary exploration

Pivot table provides built-in drill down and drill up capability to visualize data both in detailed view and abstract view, respectively. By default, pivot table displays data in a summarized format.

ASP NET MVC pivot table with drill up and drill down support


Virtual scrolling

The high-performance pivot grid allows users to load large amounts of raw data, aggregate it, and view it on-demand through horizontal and vertical scrollbar options with ease.

Virtual scrolling support in ASP NET MVC pivot table


Data manipulation

Filtering support in ASP NET MVC pivot table

Filtering

Filtering allows users to view only specific records in the control using complex filter criteria with the help of member, label, or value filter options, similar to Microsoft Excel.

Sorts in ascending and descending order using ASP NET MVC pivot table

Sorting

Allows users to order both fields and values (column) either in the ascending or descending order.

Aggregation support in ASP NET MVC pivot table control

Aggregation

Users can perform calculation over a group of values using the aggregation option. By default, values are summed. The other aggregation types include average, minimum, maximum and count.


Pivot field list and grouping bar

The field list and grouping bar are automatically populated with the fields from the assigned report. They later allow end users to drag fields, filter, and sort them, and also create pivot views at run time.

ASP NET MVC pivot table control along with field list and grouping bar


Calculated field

New value field(s) can be added based on a simple mathematical formula to their report either through built-in dialog at run-time or through code behind.

Calculated field, aka user-defined field in ASP NET MVC pivot table control


Frozen header

By default, row and column headers are frozen to allow scrolling and comparing cell values with the corresponding row and column headers.

Freezes row and column headers in ASP NET MVC pivot table control


Conditional formatting

Conditional formatting allows users to apply styles to value cells by changing grid cells’ font style, font color, background color, and font size.

Conditional formatting support in ASP NET MVC pivot table control


Column

Resizes columns in ASP NET MVC pivot table control

Resize

Resizing allows changing column width on the fly by simply dragging the right corner of the column header. The scroll bar will appear when the pivot table content width exceeds the element width.

Reorders columns in ASP NET MVC pivot table control

Reorder

Columns can be reordered either through user interaction or programmatically. Simply dragging and dropping a column header into the desired column position will reorder the columns.


Optimized for mobile devices

Touch support for ASP NET MVC pivot table control

Touch support

All pivot table features will work on touch devices with ease. Features such as drill up/down, filtering, sorting, and report manipulation can be done on the fly.

Responsive view of ASP NET MVC pivot table control

Responsiveness

Responsive features allow the pivot table layout to be viewed on various devices.

Field list support in ASP NET MVC pivot table control to create reports dynamically at run time

Adaptable field list UI

It allows the pivot field list to be viewed on various devices.


Exporting

Exports pivot table data to Excel, PDF, and CSV formats. The exported document can also be customized to add header, footer, and its cell properties like type, style, and position programmatically.

Exports report to Excel, PDF and CSV in ASP NET MVC pivot table control


Globalization and localization

Globalization support in ASP NET MVC pivot table control

Globalization

Enables users from different locales to use pivot table by formatting the date, currency, and numbering to suit locale preferences. This uses the Essential JS 2 internalization library for handling value formatting.

Right to left, aka RTL support in ASP NET MVC pivot table control

Right to left {RTL}

Supports right-to-left rendering, allowing the text direction and layout of the pivot table to be displayed from right to left. This improves user experience and accessibility for RTL language users.

Localization support in ASP NET MVC pivot table control

Localization

All the pivot table strings in the user interface can be localized as needed. The pivot table uses Essential JS 2 localization library to localize UI strings.


50+ ASP.NET MVC CONTROLS

Transform your applications today by downloading our free evaluation versionDownload Free Trial

Scroll up icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon