sgcPivotGrid Feature Matrix
Everything sgcPivotGrid does, grouped by task, with a link to the help topic of each feature. The engine, TsgcPivotEngine, also works without a window.
Everything sgcPivotGrid does, grouped by task, with a link to the help topic of each feature. The engine, TsgcPivotEngine, also works without a window.
5 features
9 features
6 features
7 features
7 NuGet packages
Online help and PDF manuals
Registered marks the features that are in the Registered and Trial editions and not in the free Community edition. ~ marks a feature that Community has in part, with the difference below it.
Every row links to its help topic. The Community column shows what the free .NET Community edition includes; everything is in Registered and Trial.
| Feature | Details | Community | Help |
|---|---|---|---|
| A million rows | Typed column store, one pass per recalculation and virtual drawing. The MillionRows demo pivots 1,000,000 rows. | Help | |
| Batch loading | BeginLoad, DefineColumn, AppendRow and EndLoad, and BeginUpdate and EndUpdate for one recalculation. | Help | |
| Data sources | TsgcPivotSource_DataSet follows a TDataSet with live updates; TsgcPivotSource_Table reads an sgcGrid or any IsgcUITable. | Help | |
| ItemsSource binding (.NET) | TsgcWpfPivotGrid and TsgcAvaloniaPivotGrid read their source rows from ItemsSource, any IEnumerable, and recalculate when the collection or an item changes. In WPF the filter of an ICollectionView decides which items are rows. TsgcWinFormsPivotGrid reads DataSource and DataMember, and the filter of a BindingSource reaches the pivot. The binding is one way: the pivot never writes to the data. | Help | |
| Fields in XAML and in the designer (.NET) | TsgcWpfPivotField and TsgcAvaloniaPivotField elements declare the fields with FieldName, Area, Aggregation and DisplayFormat, and the field list binds to its grid through its PivotGrid property. In WinForms the Visual Studio designer edits Fields with a smart tag and a collection editor, and a pivot with no field shows a sample pivot in the designer and in the WPF and Avalonia previewers. | Help |
| Feature | Details | Community | Help |
|---|---|---|---|
| Date grouping | Year, Quarter, Month, Week and Day on the same date field. | Help | |
| Expand and collapse | ExpandAll, CollapseAll and ExpandLevel. | Help | |
| Eight aggregations | Sum, Count, Average, Min, Max, CountDistinct, StdDev and Var. | Help | |
| Totals | Subtotals and grand totals per axis, with their position (SubtotalPosition) and caption (GrandTotalCaption). | Help | |
| Sorting | Sort members by label or by the value of a measure (SortBy, SortMeasure, SortOrder). | Help | |
| Filters | Label and value filters with 13 operators, and member checklists in the field list. | Help | |
| Calculated fields | Row level expressions with IF, ROUND, MIN, MAX, ISNULL, YEAR and MONTH (TsgcPivotCalculatedField), aggregated like source columns. | Registered | Help |
| Show values as | % of row, column or grand total, running total, difference from and rank. | Registered | Help |
| Top N with Others | TopN keeps the members with the largest totals and TopNOthers folds the rest into an Others row. | Registered | Help |
| Feature | Details | Community | Help |
|---|---|---|---|
| Field list | Users drag fields between rows, columns, filters and data. | Help | |
| Conditional formatting | Format rules such as colour scales (TsgcPivotFormatRule, pvrColorScale). | Help | |
| Drill down | A double click or Enter shows the source rows behind a cell (OnDrillDown, DrillDown, GetSourceRows). | Help | |
| Keyboard | Keyboard navigation in the pivot grid. | Help | |
| Themes | Light and dark themes: Theme := utDark. | Help | |
| Right to left (Arabic and Hebrew) | The row header area, column header order, compact indent, chevrons, field list and scroll bars are mirrored, and the XLSX export writes a right to left sheet. Numbers stay left to right runs. | Help | |
| Accessibility | Exposed to UI Automation as a table with row and column headers that expand and collapse, data cells and totals, and the field list as lists of fields per area. Ctrl+1 to Ctrl+4, Ctrl+Up, Ctrl+Down, Space and Del move fields with the keyboard, the focus ring is always visible and Windows high contrast is followed. On by default on VCL (Delphi 7 to 13), FireMonkey on Windows, WinForms, WPF and Avalonia. | Help |
| Feature | Details | Community | Help |
|---|---|---|---|
| Export | SaveToCSV, SaveToJSON, SaveToHTML, SaveToPNG and SaveToSVG. | Help | |
| Layout persistence | SaveLayoutToFile and LoadLayoutFromFile store the layout as JSON. | Registered | Help |
| Headless rendering | TsgcPivotGridRenderer on a server or on Linux64. | Help | |
| Charts interop | sgcCharts reads the pivot result as a table. | Help | |
| Ask your pivot | TsgcPivotGridAI turns a question such as "top 3 countries by sales" into a pivot layout through any AI provider, on VCL, FireMonkey, WinForms, WPF and Avalonia, with the AI query bar or from code. Only the question and the field catalog are sent, never row data. Undo restores the previous layout in the Registered edition. | Help | |
| sgcWebSockets AI provider | TsgcPivotGridAIQuery of the sgcPivotGridWS bridge takes a TsgcAIChat in Chat. TsgcUIAIChatProvider of the sgcUICoreWS bridge uses the TsgcAIChat component of sgcWebSockets on every platform. In .NET, the esegece.sgcUICore.sgcWebSockets package. Needs a registered sgcWebSockets. | Registered | Help |
| Printing and print preview | Print and ShowPrintPreview print the whole pivot table with its current layout, the column headers at the top and the row headers at the left of every page. PrintSettings sets the paper, orientation, margins, scaling, header and footer once for the printer, the preview and the PDF. In every edition, on VCL, FireMonkey, WinForms, WPF and Avalonia (FireMonkey prints on Windows and macOS). | Help | |
| Accessible PDF export, PDF/UA and PDF/A (with sgcPDF) | ExportToPDF writes vector pages with searchable text, every page is a real table with column and row header cells, and a shortened label keeps its full text for screen readers. The file is a tagged PDF/UA document by default, and PDFALevel adds PDF/A-2a or PDF/A-3a. Needs the sgcUIPDF bridge and a licensed sgcPDF (esegece.sgcUICore.sgcPDF in .NET). | Registered | Help |
The .NET pivot grid is a C# port, not a wrapper, for WinForms, WPF and Avalonia, with the shared engine, headless PNG and SVG and a DataTable source.
| Package | Edition | Contents |
|---|---|---|
esegece.sgcPivotGrid.Community | Community (free) | Core library |
esegece.sgcPivotGrid | Registered | Core library |
esegece.sgcPivotGrid.WinForms | Registered | Windows Forms controls |
esegece.sgcPivotGrid.Wpf | Registered | WPF controls |
esegece.sgcPivotGrid.Avalonia | Registered | Avalonia controls |
esegece.sgcPivotGrid.Rendering | Registered | Headless rendering |
esegece.sgcPivotGrid.sgcWebSockets | Registered only | sgcWebSockets bridge |
esegece.sgcUICore.sgcWebSockets | Registered only | sgcWebSockets AI provider (TsgcUIAIChatProvider) |
Every feature of sgcPivotGrid is documented in the sgcUI help, with one build for each development environment.
Start with the sgcPivotGrid introduction, then follow the quick start and the feature topics.
Delphi →The complete sgcUI help as a PDF file, to read offline or print.
Delphi (PDF) →