Blazor Pivot Table Example - Server-side Aggregation

This sample demonstrates how to leverage a server-side pivot engine to fetch and display summarized data in the Pivot Table, including comprehensive export options for Excel, CSV, and PDF formats with customizable headers and footers.

The Pivot Table's server-side pivot engine (external pivot engine) utilizes the Syncfusion Syncfusion.Pivot.Engine package to gather data from the data source and perform all pivot operations such as Aggregation, Filtering, Sorting, and Grouping on a separate hosted server. Only the paged data required for the viewport is transmitted to the pivot table via a web service, significantly improving performance.

The DataSourceSettings->Url property enables connection to the web service endpoint.

In this demo, the Pivot Table is rendered using an external server-side engine, which substantially 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 with large data volumes, we recommend enabling Virtualization or Paging features.

The built-in toolbar includes robust export options for Excel, CSV, and PDF documents. These export features support adding custom headers and footers, enabling enriched document formatting and professional presentation.

For detailed information about server-side aggregation and configuration, refer to the server-side pivot engine documentation.