The WPF pivot grid control organizes and summarizes business data and displays the result in a cross-table format.
Features and Benefits
The WPF 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.
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 a pivot report 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.
Refresh the control only on demand and not during every UI interaction.
Editing and updating
Built-in header and Excel-like filter UIs with advanced filtering options to easily filter and view data. It is also possible to filter programmatically. It is also possible to filter programmatically.
Order rows and columns, either based on labels or values.
Summaries and calculations
The calculated field, otherwise known as unbound field generates unique field with our own calculated value by executing a simple user-defined formula.
Expression field generates data by executing user-defined expressions. The generated data is specific to a few field(s) from the underlying data source.
It easily obtains a list of raw items for a particular value cell or summary cell.
Format the column header, row header, summary cell, and value cell of the control.
Define conditions that, when met, format values and summary cells font, color, and border settings.
Number formatting and date formatting
Number formatting and date formatting help to transform the appearance of the actual cell value.
Users can visualize the control either as a flat grid or a pivot table similar to Excel. Users can also position summaries at the top.
Subtotals and grand totals are calculated automatically by the pivot engine inside the control and displayed in the pivot grid. This helps users make decision based on the totals. Also, users can show or hide subtotals and grand totals for rows and columns.
Column and row
Save and load reports
Settings in the WPF Pivot Grid control can be serialized to an XML format and loaded back through the built-in deserialization options.
Exporting and printing
The WPF Pivot Grid control 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.
Founded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion has more than 23,000 customers and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.