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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Overview

The WinForms pivot grid control organizes and summarizes business data and displays the result in a cross-table format.


High performance

Asynchronous loading support in WinForms Pivot Grid control

Asynchronous loading

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

On-demand loading support in WinForms Pivot Grid control

On-demand loading

The control can load a large set of records on demand in little time.


Data binding

The WinForms Pivot Grid control simulates the pivot table feature of Excel. The data source for the control should be either a DataTable, DataView, DataSet from SQL databases or collections like IEnumerable, ICollection, IList, List and ArrayList.

Relational data source binding in WinForms Pivot Grid control


Chart integration in WinForms Pivot Grid control

Binding data with charts

The data from the WinForms pivot grid columns and rows can be plotted in a chart (graphical format), providing meaningful visualization.


Pivot table field list and group fields

The pivot table field list and group fields are automatically populated with fields from the bound data source. They later allow end users to drag fields, filter and sort them, and create pivot reports at runtime.

Field list support in WinForms Pivot Grid control to create reports dynamically at runtime


Drill down and drill up

Drill down (expand) and drill up (collapse) to visualize the pivot information in both abstract and detailed views.

Drill up functionality in WinForms Pivot Grid control


Defer update

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

Defer update support in WinForms Pivot Grid control


Editing and updating

Edits value cells at run-time in WinForms Pivot Grid control

Editing

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

Updates value cells at run-time in WinForms Pivot Grid control

Updating

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


Filters row and column headers in WinForms Pivot Grid control

Filtering

Display only selective values for a field either through UI or code-behind.


Sorting

Order rows and columns based on either labels or values.

Sorting support in WinForms Pivot Grid control

Header sorting

Order the column and row header text either in ascending or descending order.

Custom sorting support in WinForms Pivot Grid control

Custom sorting

Orders the column and row header text based on the custom comparer defined by the user.

Column sorting support in WinForms Pivot Grid control

Column sorting

Order the column values in either ascending or descending order. It is performed by clicking the desired column header. You can achieve this programmatically only.

Multi-column sorting support in WinForms Pivot Grid control

Multi-column sorting

Order one or more columns in either ascending or descending order. It is performed by holding the Ctrl key and clicking the column headers. You can achieve this programmatically only.


Summaries and calculations

Summaries support in WinForms Pivot Grid control

Summaries

Define your own custom summaries for the pivot item values programmatically. The control also supports 19 other built-in summary types to customize the summaries.

Calculation support in WinForms 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 programmatically.


Calculated field

The calculated field, otherwise known as unbound field generates unique field with our own calculated value by executing a simple user-defined formula.

Calculated field support in WinForms pivot table control


Expression field support in WinForms pivot table control

Expression field

Expression field generates data by executing the user-defined expression. The generated data are specific to few field(s) from the underlying data source.


Drill through

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

Drill through support in WinForms Pivot Grid control


Conditional formatting

Allows users to define conditions that, when met, format values and summary cells font, color, and border settings.

Formats only cells that contains specific values at run time in WinForms Pivot Grid control


Number and date formatting support in WinForms Pivot Grid control

Number formatting and date formatting

Number formatting and date formatting help to transform the appearance of the actual cell value.


Visualizations

Users can visualize the control either as a flat grid or a pivot table similar to Excel.

Normal layout

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

Normal view of WinForms Pivot Grid control

Flat grid

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

Flat view of WinForms Pivot Grid control


Totals

Subtotals and grand totals are calculated automatically by the pivot engine inside the source and displayed in the pivot table. This helps users make decisions based on the totals. Also, users can show or hide subtotals and grand totals for rows and columns.

Shows/hides totals in WinForms Pivot Grid control


Column and row

Hyperlink support in Windows Forms pivot grid control

Retrieve information about a particular cell on hyperlink cell click. Perform custom operations programmatically as well.

Tooltip support in Windows Forms pivot grid control

Tooltip

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

Freeze headers in Windows Forms pivot grid control

Freeze header

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

Selecting range of cells Windows Forms pivot grid control

Selection

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


Saves current report in WinForms Pivot Grid control

Save and load reports

Settings in the WinForms Pivot Grid control can be serialized to an XML format and saved. Also, the saved report can be loaded back through the built-in deserialization options.


Exporting and printing

The WinForms Pivot Grid control 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 WinForms Pivot Grid control


Custom style and themes

Built-in theme support in WinForms Pivot Grid control

Built-in themes

Ships with built-in themes like Office 2007, Office 2010, Office 2016 and Metro.

Custom styling support in WinForms Pivot Grid control

Custom styling

Customize the appearance of the control to any extent programmatically.


Developer friendly API

For a great developer experience, flexible built-in APIs are available to define and customize the WinForms Pivot Grid control. Developers can optimize the data bound to the control and customize the user interface (UI) completely using code with ease.


Globalization and localization

Globalization support in WinForms Pivot Grid control

Globalization

Allows users from different locales to use the control by applying a date format, currency format, and number format to suit local preferences.

RTL support in WinForms Pivot Grid control

Right-to-left (RTL)

The text direction and layout of the control can be displayed in the right-to-left (RTL) direction.

Localization support in WinForms Pivot Grid control

Localization

Allows users to customize the text in the user interface based on the local culture.


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