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.
6 features
10 features
8 features
11 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 | |
| Asynchronous calculation | AsyncCalculation or RecalculateAsync (a Task<bool> with a CancellationToken in .NET) recalculate on a background thread, CancelCalculation keeps the previous result on screen and OnCalculated fires on the UI thread. | Registered | 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, and Throttle groups fast changes into one recalculation; 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 |
| Calculated items | Field.CalculatedItems.Add(Name, Formula) adds a member to a row or column field from a formula over its siblings, such as East+West or Q1-Q2. It sorts after the real members, totals stay based on the source rows and the layout JSON saves it. | 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 | |
| Field buttons | With Layout = pvlBar the field list becomes a bar of field buttons above a pivot chart: Filters, Columns (the legend), Rows (the axis) and Values. Drag a button to move a field, filter its members with the funnel, or expand, collapse and remove a field from its menu. | Registered | 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 | |
| Export to Excel (XLSX) | SaveToXLSX on the engine and the VCL, FireMonkey, WinForms, WPF and Avalonia grids writes a workbook with no external library: merged column headers, bold totals, outline rows, a frozen header, Excel number formats and Excel percent. | Registered | Help |
| Layout persistence | SaveLayoutToFile and LoadLayoutFromFile store the layout as JSON, with the settings of a pivot chart. | Registered | Help |
| Headless rendering | TsgcPivotGridRenderer on a server or on Linux64. | Help | |
| Charts interop | sgcCharts reads the pivot result as a table. | Help | |
| Pivot chart link | TsgcChartTableLink of sgcCharts binds a chart to the pivot result with one series per value column and the row labels as categories. Bar, stacked bar, line and area, rebuilt when the pivot changes, series colours kept. In every edition of sgcCharts, also with sgcGrid. | Help | |
| Pivot chart | TsgcPivotChartTable feeds TsgcChartTableLink of sgcCharts: clustered, stacked and 100% stacked column, line, area, pie, donut and combo with a secondary axis, grand totals, top N and data labels. The chart designer sets it from a Data page, and the charts member of the layout JSON saves it, the same in Delphi and .NET. Needs a Registered sgcCharts. | Registered | 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.WinForms.Community | Community (free) | Windows Forms controls |
esegece.sgcPivotGrid.Wpf.Community | Community (free) | WPF controls |
esegece.sgcPivotGrid.Avalonia.Community | Community (free) | Avalonia controls |
esegece.sgcPivotGrid.Rendering.Community | Community (free) | Headless rendering |
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) →