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 Core pivot grid control


Effective Data Binding

There is extensive support to bind both OLAP and relational data sources.

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


Data Exploration

Built-in support to drill up and drill down to visualize the grid information in both abstract and detailed views.

Drill up/drill down functionalities in ASP.NET Core 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 Core 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.

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

KPI

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

Named sets support in ASP.NET Core pivot grid control

Named Sets

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


Grouping Bar

Grouping bar is automatically populated with fields from the bound data source. It later allows end users to drag fields, filter and sort them, and create pivot views at run time.

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


Pivot Table Field List

Pivot table field list (also known as pivot schema designer) is a powerful tool that allows you to create and manage pivot table with either multidimensional or relational data sources. End users can drag fields and filter them at run time as they wish.

Field list support in ASP.NET Core 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 Core pivot grid control

Sorting

Users can order rows and columns based on labels. It is supported only in a relational data source.


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 Core pivot grid control


Conditional Formatting

Allows users to define conditions that, when met, format (value and summary) cells’ font, color, and border settings.

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


Calculated Field

You can now insert a new calculated field based on the existing calculated items either through UI dialog (at run time) or code behind. The calculated field option is supported only for relational data source.


Interactive Features

Hyperlink support in ASP.NET Core pivot grid control

Pivot grid retrieves information about a particular cell on hyperlink cell click. It later allows you to perform custom operations programmatically.

Context menu support in ASP.NET Core pivot grid control

Cell Context

Pivot grid allows you to perform custom operations programmatically, on right-clicking over a cell. For example, creating and invoking content menu or dialog on right-click.

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

Selection

There is extensive support to select a range of value cells.

Tooltip support in ASP.NET Core pivot grid control

Tooltip

Tooltip provides basic information about a cell while hovering over it.

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

Editing and Updating

Users can edit the values at run time and save their changes to the underlying data source, thereby reflecting its update in the total cells. This feature is supported only for a relational data source.

Resizes columns in ASP.NET Core 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 Core 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 Core pivot grid control

Hiding Totals

You can now hide either subtotals or grand totals or both at column and row position. This feature is supported only for a relational data source.


Rich Look and Feel

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

Built-in Themes

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

Custom CSS for ASP.NET Core pivot grid control

Custom Styling

Pivot grid provides ability to customize the appearance of the control to any extent programmatically.

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

Theme Studio

You can easily customize all aspects of the 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.