There is extensive support to bind both OLAP and relational data sources.
The pivot grid has built-in support to drill up and drill down to visualize grid information in both abstract and detailed views.
End users can easily slice and dice the cube elements of their choice to visualize performance, trends, outliers, and more.
Slice and dice creates a new view for the end user by selecting limited dimensions and measures from the cube and by filtering them.
KPIs are a collection of calculations associated with a measure group that evaluates business success.
Extensive support has been provided to load and render large amounts of data through paging or virtual scrolling without any performance constraints.
Named sets simplify MDX queries and provide useful aliases for complex, commonly used set expressions.
You can create and display dimensions and measures on your own. This can be done only through the report programmatically.
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.
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.
Users can apply filtering for a selective display of records either by including or excluding values.
Users can order rows and columns based on labels.
You can store reports from the current session as a stream in a database for later use.
The pivot grid control is supported by all the major browsers in use today, including:
There is built-in integration with popular third-party frameworks such as AngularJS.
Conditional formatting allows users to define conditions that, when met, format cells’ font, color, and border settings.
Users can refresh the control only on demand instead of during every UI interaction.
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.
Pivot grid can retrieve information about a particular cell on clicking a hyperlink cell. It later allows you to perform custom operations programmatically.
Pivot grid allows you to perform custom operations programmatically on right-clicking a cell. For example, a context menu or dialog can be created or invoked on right-clicking.
There is extensive support to select a range of value cells.
Tooltips provide basic information about a cell while hovering.
Users can edit values at run time and save their changes to the underlying data source, thereby reflecting the updates in the total cells.
You can easily resize each column’s width through a simple drag operation at run time.
Users can freeze row and column headers while performing scroll operations in order to have a precise view of the content.
You can hide subtotals, grand totals, or both in columns and rows.
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.
Pivot grid ships with a set of 13 stunning, built-in themes.
The pivot grid’s appearance can be customized to any extent programmatically.
You can easily customize all aspects of the control’s appearance using the Theme Studio utility.