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.

Overview

The pivot grid control is an easily configurable, presentation-quality business control that reads both relational and OLAP data sources. It is displayed with drill-up and drill-down capabilities and features exceptional performance.

ASP.NET MVC pivot grid control


Effective Data Binding

Pivot grid has extensive support to bind both OLAP and relational data sources.

  • OLAP Data Sources: Supports SSAS, Mondrian, Active Pivot, and Oracle.
  • Relational Data Sources: Supports IEnumerable List, DataTable, and JSON.

View Demo

OLAP and relational data binding in ASP.NET MVC pivot grid control


Data Exploration

Pivot grid has built-in support to drill up and drill down to visualize grid information in both abstract and detailed views.

View Demo

Drill up/drill down functionalities in ASP.NET MVC pivot grid control


OLAP

End users can easily slice and dice the cube elements of their choice to visualize performance, trends, outliers, and more.

Slice and dice functionality in ASP.NET pivot grid control

Slice and Dice

Slice and dice creates a new view for the end user by selecting limited dimensions and measures from the cube and filtering them.

View Demo

Key Performance Indicators (KPIs) support in ASP.NET pivot grid control

KPIs

KPIs are a collection of calculations associated with a measure group that evaluates business success.

View Demo

Paging support in ASP.NET MVC pivot grid control

Dynamic Paging

Extensive support has been provided to load and render large amounts of data through paging or virtual scrolling without any performance constraints.

View Demo

Named sets support in ASP.NET MVC pivot grid control

Named Sets

Named sets simplify MDX queries and provide useful aliases for complex, commonly used set expressions.

Creates user-defined (calculated) members in ASP.NET MVC pivot grid control

Calculated Members

You can create and display dimensions and measures on your own. This can be done only through the report programmatically.


Grouping Bar

The grouping bar is automatically populated with fields from the bound data source. It allows end users to drag fields, filter and sort them, and create pivot views at run time for both OLAP and relational data sources.

View Demo

Groups fields in ASP.NET MVC pivot grid control to change existing reports dynamically at run-time


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 relational data sources. End users can drag fields and filter them at run time as they wish.

View Demo

Field list support in ASP.NET MVC pivot grid control for creating reports dynamically at run-time


Data Shaping and Manipulation

Filters row and column headers in pivot grid control

Filtering

Users can apply filtering for selective displays of records either by including or excluding values.

Sorts row and column headers in ASP.NET MVC pivot grid control

Sorting

Sort orders rows and columns based on labels.


Persisting Reports

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

Saves current report in ASP.NET MVC pivot grid control


Browser Compatibility

The pivot grid control is supported in all the major browsers in use today, including:

  • IE 8+
  • Firefox 2.0+
  • Chrome 1+
  • Opera 9+
  • Safari 3.0+

Browser compatibility for ASP.NET MVC pivot grid control


AngularJS

There is built-in integration with popular third-party frameworks such as AngularJS.

View Demo

Pivot grid control in web frameworks


Conditional Formatting

Pivot grid allows users to define conditions that, when met, format value and summary cells’ font, color, and border settings.

View Demo

Formats cells at run time based on used-defined criteria in ASP.NET MVC pivot grid control


Defer Update

Users can refresh the control only on demand instead of during every UI interaction.


Calculated Field

You can insert a new calculated field based on the existing calculated items either through a dialog window at run time or through code behind.


Interactive Features

Hyperlink support in ASP.NET MVC pivot grid control

Pivot grid can retrieve information about a particular cell on clicking a hyperlink cell. It later allows you to perform custom operations programmatically.

View Demo

Context menu support in ASP.NET MVC pivot grid control

Cell Context

Pivot grid allows you to perform custom operations programmatically on right-clicking a cell. For example, you can create and invoke a context menu or dialog on right-clicking.

View Demo

Selects the range of cells (cell selection) in ASP.NET MVC pivot grid control

Selection

There is extensive support for selecting a range of value cells.

View Demo

Tooltip support in ASP.NET MVC pivot grid control

Tooltip

Tooltips provide basic information about a cell while hovering the pointer over it.

View Demo

Edits and updates value cells at run-time in ASP.NET MVC pivot grid control

Editing and Updating

Users can edit values at run time and save their changes to the underlying data source, thereby reflecting its update in the total cells.

Resizes columns in ASP.NET MVC pivot grid control

Column Resizing

You can easily resize each column’s width through a simple drag operation at run time.

Freezes headers in ASP.NET MVC piot grid control

Freeze Headers

Users can freeze row and column headers while performing a scroll operation in order to have a precise view of the content.

Shows/hides totals in ASP.NET MVC pivot grid control

Hiding Totals

You can now hide subtotals, grand totals, or both in columns and rows.


Exporting

You can export pivot grid content to Excel, Word, and PDF documents. These documents can be saved from the browser to the local disk drive for later use.

Exports report to Excel, Word, and PDF in ASP.NET MVC pivot grid control


Rich Look and Feel

Built-in theme support in ASP.NET MVC pivot grid control

Built-in Themes

Pivot grid ships with a set of 13 stunning, built-in themes.

Custom CSS for ASP.NET MVC pivot grid control

Custom Styling

The pivot grid’s appearance can be customized to any extent programmatically.

Customizes ASP.NET MVC pivot grid control appearance using theme studio

Theme Studio

Easily customize all aspects of the control’s appearance using the Theme Studio utility.


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.