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.

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 data-source, 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 add new aggregate functions, using built-in predefined operators
• Total / Subtotal rows support
• Computed fields support
• Conditional Format 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's layout ,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 ...

 

 

® ExPivot is a trademark of Exontrol. All Rights Reserved.