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.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 enabling 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. 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 section.