.NET Pivot Control (expivot)

ExPivot is a powerful data analysis and summarization tool that functions similarly to a pivot table. It enables automatic sorting, counting, totaling, and averaging of data from tables or spreadsheets. Users can dynamically define and adjust the summary structure through interactive drag-and-drop field configuration. ExPivot also supports customizable skins, allowing you to modify its appearance and provide a more intuitive and visually enhanced data exploration experience.

Skinnable Interface support (ability to apply a skin to any background part)
Easy way to define the control's visual appearance in design mode, using XP-Theme elements or EBN objects
PDF, BMP, JPG, GIF, PNG, TIFF, EMF support (Ability to save/export the control's content to PDF, BMP, JPG, GIF, PNG, TIFF, EMF formats)
Interactive context menu to define the format to be displayed, including the colors, font, and so on
Summarizes the data by Drag and Drop, or by code
Ability to import data from ADO/DAO datasource/datacontext, TXT, XML or by drag and drop from other sources
Export data as TXT, CSV, XML, EMF or by drag and drop
Ability to drag/filter the values of a column to the pivot bar, so the chart displays the associated function by value
SUM, AVG, COUNT, MIN or MAX implementation, for numbers, string or date expressions
Ability to display multiple aggregate functions on the same cell
Ability to add new aggregate functions, using built-in predefined operators
Total / Subtotal rows support
Automatically update the Total/Subtotal rows, once a filter is applied, so the aggregate rows reflect the visible data only
Computed fields support
Undo / Redo support
Easy way to save / restore the control's layout, column positions and size, sorting, filtering, scrolling and so on
Ability to define the content of the columns / rows context menu
Compact or Expanded mode support
FilterBar / FilterPrompt support
Built-in HTML, Decorative Text, Tooltip, Mouse Wheel, Icons, Pictures support and more
Print and Print-Preview support, including Fit-To-Page

General information about ExPivot/NET product:

Identifier:	Exontrol.Pivot, exontrol.EXPIVOTLib.expivot, wpf.exontrol.EXPIVOTLib.expivot
Version:	19.0.0.7
Files:	expivot.dll, expivot.ocx, exontrol.expivot.dll, expivot.net, wpf.exontrol.expivot.dll, expivot.wpf
Available As:	JavaScript COM/ActiveX /NET Assembly /WPF Component
Available since:	2013135
Compatible with:	Access, AutoIt, C#, C++, Clarion, Delphi, Dynamics AX, Dynamics NAV, FORTH, HTML, LabVIEW, Lotus Notes, Power++, PowerBuilder, Progress, Smalltalk, twinBASIC, VB, VB.NET, VB6, VBA, Visual Objects, VFP, VFP Advanced (x64), xBasic, X++, Xbase++, uniPaas (eDeveloper)
Lines of code:	237,059 ^{(205,068 excluding comments and empty lines)}
Includes:	Objects 12, Functions 373, Events 13, Definitions 29
See Also:	ExGraph ExGraph/NET is a data visualization component supporting multiple chart types including line and radar charts, with printing and print preview capabilities and customizable skins for enhanced visual presentation. ExGrid ExGrid/NET is a tree-grid component that combines grid, tree, and list views with data-bound or unbound support, offering flexible data visualization and advanced formatting features for modern application interfaces. ExG2antt ExG2antt/NET is an editable tree-grid component with integrated Gantt chart functionality, combining grid and Gantt features in a single control with customizable skins for enhanced visualization and user experience. ExMLGrid ExXMLGrid is an XML-style grid and tree view component that provides high-performance data visualization with advanced formatting features and customizable skins for enhanced UI appearance. ExPropertiesList ExPropertiesList/NET is a properties grid control similar to Visual Studio's property editor, designed for efficient data input and compact, intuitive user interface property management. ExTree ExTree/NET is an advanced tree view component supporting single and multi-column tree structures, list, and listview modes for flexible hierarchical data display in applications. EBN EBN files provide skinning capabilities for UI components, enabling customizable visual appearances across multiple controls within applications.

Shortcut links: