Example of Server-side Aggregation in ASP.NET MVC Pivot Table Control
This sample shows how to use a server-side pivot engine to fetch and display summarized data in the Pivot Table. It includes export options for Excel, CSV, and PDF with headers and footers, and a layout switcher to toggle between Compact and Tabular views at runtime.
The Pivot Table's server-side pivot engine (external pivot engine) uses the Syncfusion package Syncfusion.Pivot.Engineopens in a new tab to gather data from the data source and perform all pivot operations such as Aggregationopens in a new tab, Filteringopens in a new tab, Sortingopens in a new tab, Groupingopens in a new tab, and more on a separate hosted server and only paged data is sent to the pivot table viewport via web service. The DataSourceSettings->Urlopens in a new tab property allows this web service URL to be connected to the pivot table.
In this demo, the pivot table is shown with the virtualization option enabled through the EnableVirtualizationopens in a new tab property and an external server engine. This would improve pivot table rendering performance when working with large amounts of data.
The built-in toolbar includes export options for Excel, CSV, and PDF documents. These export features support adding headers and footers, enabling enriched document formatting and presentation.
Additionally, a custom toolbar menu is provided to switch between Compact and Tabular layouts at runtime, offering flexibility in how the summarized data is displayed.
More information about server-side aggregation can be found in this documentation sectionopens in a new tab.