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.


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.


Relational data source binding in Windows Forms pivot grid control

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 shaping and manipulation

Filters row and column headers in Windows Forms pivot grid control

Filtering

A built-in filter UI allows you to easily filter and view data. It is also possible to filter programmatically.

Sorts row and column headers in Windows Forms pivot grid control

Sorting

Order rows and columns based on headers.


Data exploration

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


Calculation support in Windows Forms pivot grid control

Calculations

Along with 16 built-in calculation types, there is also extensive support to insert user-defined calculated fields using a custom formula, either dynamically at runtime or programmatically.


Summaries

Pivot grid has extensive support for you to define your own custom summaries for the pivot item values using a built-in dialog at runtime as well as programmatically. It also supports 19 other built-in summary types to customize the summaries.

Summaries support in Windows Forms pivot grid control


Editing and updating

Editing

Edit the values at runtime, thereby updating the total cell simultaneously.

Edits value cells at run-time in Windows Forms pivot grid control

Updating

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

Updates value cells at run-time in Windows Forms pivot grid control


Asynchronous loading support in Windows Forms pivot grid control

Asynchronous data processing

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


Layouts

Normal layout

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

Normal view of Windows Forms pivot grid control

Flat layout

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

Flat view of Windows Forms pivot grid control

Hiding totals

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

Shows/hides totals in Windows Forms pivot grid control


Saves current report in Windows Forms pivot grid control

Persisting reports

Settings in the pivot grid control can be serialized to an 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.


Interactive features

Freeze headers, aka frozen headers in Windows Forms pivot grid control

Freeze headers

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

Selecting range of cells, aka cell selection in Windows Forms pivot grid control

Selection

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

Tooltip support in Windows Forms pivot grid control

Tooltips

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

Hyperlink support in Windows Forms pivot grid control

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

Defer update support in Windows Forms pivot grid control

Defer update

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


Exporting and printing

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

Prints and exports to Excel, Word, and PDF support in Windows Forms pivot grid control


Localization support in Windows Forms pivot grid control

Localization

Every static text in the pivot grid and built-in dialogs can be localized to any desired language.


Right to left

Pivot grid can render headers and values from right to left to adhere to certain local standards.

RTL support in Windows Forms pivot grid control


Rich look and feel

Built-in theme support in Windows Forms pivot grid control

Built-in themes

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

Custom styling support in Windows Forms pivot grid control

Custom styling

Customize the appearance of the control to any extent programmatically.


100+ WINDOWS FORMS 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