Blazor Pivot Table Example - Server-side Aggregation
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.
The Pivot Table's server-side pivot engine (external pivot engine) uses the Syncfusion package Syncfusion.Pivot.Engine to gather data from the data source and perform all pivot operations such as Aggregation, Filtering, Sorting, Grouping, and more on a separate hosted server and only paged data is sent to the pivot table viewport via web service. The DataSourceSettings->Url property allows this web service URL to be connected to the pivot table.
In this demo, the Pivot Table is rendered using an external server-side engine, which significantly enhances performance when handling large datasets. By offloading data processing to the server, client-side rendering becomes faster and more efficient—ensuring a smoother user experience even with complex or high-volume data.
For further performance improvements when working with large data volumes, we recommend Virtualization or Paging features.
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.
More information about server-side aggregation can be found in this documentation section.