The Exontrol's eXPivot tool is our approach to provide data summarization, as a pivot table.
A pivot-table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet.
The user sets up and changes the summary's structure by dragging and dropping fields graphically.
The eXPivot component lets
the user changes its visual appearance using skins,
each one providing an additional visual experience that enhances viewing
pleasure. Skins are relatively easy to build and put on any part of the control.
|
First Look of eXPivot:
|
|
Features of eXPivot include:
|
- 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
- Print and Print-Preview support, including Fit-To-Page
- Summarizes the data by Drag and Drop, or by code
- Undo / Redo support
- 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 function on the same cell
- Ability to add new aggregate functions, using built-in predefined operators
- Total / Subtotal rows support
- Computed fields support
- Conditional-Formating support
- PDF (Portable Document Format), BMP, JPG, GIF, PNG, TIFF, EMF support (Ability to save/export the control's content to PDF, BMP, JPG, GIF, PNG, TIFF, EMF formats)
- Easy way to save / restore the control'slayout,column positions and size, sorting, filtering, scrolling and so on
- Interactive context menu to define the format to be displayed, including the colors, font, and so on
- FilterBar / FilterPrompt support
- Automatically update the Total/Subtotal rows, once a filter is applied, so the aggregate rows reflect the visible date only
- Ability to define the content of the columns / rows context menu
- Compact or Expanded mode support
- Built-in HTML,Decorative Text, Tooltip, Mouse Wheel, Icons, Pictures support and more ...
|
|
General information about eXPivot product:
|
Identifier:
|
Exontrol.Pivot, exontrol.EXPIVOTLib.expivot, wpf.exontrol.EXPIVOTLib.expivot
|
Version:
|
17.1.0.5
|
Files:
|
expivot.dll, expivot.ocx, exontrol.expivot.dll, expivot.net, wpf.exontrol.expivot.dll, expivot.wpf
|
Available As:
|
|
Available since:
|
20131110
|
Compatible with:
|
VB, VB.NET, VBA, C++, X++, C#, VFP, VFP Advanced (x64), Access, HTML, Delphi, Smalltalk, uniPaas (eDeveloper), Clarion, Dynamics AX, Dynamics NAV, xBasic, Visual Objects, PowerBuilder, LabVIEW, AutoIt, Power++, FORTH, Progress
|
Lines of code:
|
237,059 (205,068 excluding comments and empty lines)
|
Includes:
|
Objects 12, Functions 373, Events 13, Definitions 29
|
See Also:
|
|
|
Shortcut links:
|
|