Your account has not been activated. Click here to get a new activation Email.
Unfortunately, activation email could not send to your email. Please try again.

Overview

The pivot grid control is a powerful pivot table implementation for visualizing relational data sources in a multidimensional UI. The pivot grid, as the name implies, pivots data to organize it in a cross-tabulated form. Along with pivoting, summarizing and grouping are also supported.


High Performance

On-Demand Loading

Pivot grid can load a large set of records on demand in less time.

Asynchronous Loading

Perform long-running operations asynchronously on a background thread. This allows end users to access other UI controls without distraction.

Improved Scrolling

Improved scrolling means a value only updates in the respective grid view where the end user releases the scroll thumb.


Effective Data Binding

The pivot grid control simulates the pivot table feature of Excel. The data source for the pivot table should be either an IEnumerable list or a data table.


Data Exploration

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


Pivot Table Field List and Grouping Bar

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


Seamless Editing Experience

Editing

Edit the values at run time, thereby updating the total cell simultaneously.

Updating

Update values in real time by pushing the live data and refreshing the control whenever its required.


Data Shaping and Manipulation

Filtering

Built-in normal and Excel-inspired filter UI with advanced filtering options to easily filter and view data as required. It is also possible to filter programmatically.

Sorting

Order rows and columns, either based on labels or values.

Calculations

There is extensive support to insert new calculations at run time, along with 16 built-in calculation types.

Summaries

Pivot grid has extensive support for you to define your own custom summaries, along with 10 built-in summary types.


Drill Through

Drill through easily obtains a list of raw items for a particular value cell or summary cell.


Visualizations

Normal

Looks like the pivot table in Excel, allowing the end user to pivot rows, columns, and calculations.

Row Pivots Only

Users can customize the pivot grid to look like a flat grid. It allows users to pivot only rows and calculations.

Summary Layout

Summary layout easily switches the summary position, either to top or bottom beside each field.


Persisting Reports

Settings in the pivot grid control can be serialized to a XML format and loaded back through the built-in deserialization options.


Conditional Formatting

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


Defer Update

Users are allowed to refresh the control only on demand and not during every UI interaction.


Interactive Features

Freeze Headers

There is built-in support for freezing row and column headers for better views of values.

Context Menu

There is a UI option to expand/collapse a header to a certain extent.

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

Selection

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

Hiding Totals

Pivot grid has support to show/hide grand-totals and subtotals for rows and columns.

Tooltip

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


Exporting and Printing

Pivot grid has a rich set of options available for exporting data to Excel, Word, PDF, and CSV, and printing the same. Several options are also provided to customize the exporting and printing operations.


Rich Look and Feel

Built-in Themes

Pivot grid ships with built-in themes like Blend, Office, Visual Studio, and Metro.

Custom Styling

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

Theme Studio

Easily customize all aspects of 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.