• Material 3
  • Material 3 Dark
  • Fluent
  • Fluent Dark
  • Bootstrap v5
  • Bootstrap v5 Dark
  • Tailwind CSS
  • Tailwind CSS Dark
  • Material
  • Bootstrap v4
  • High Contrast
Preferences
Theme Selection
Mode Selection
Touch
Mouse
Localization
*Translated by Google Translator.
Currency

Example of Server-side Aggregation in ASP.NET MVC Pivot Table Control

This sample demonstrates how to use a server-side pivot engine to obtain, process and return the summarized data via a remote service and display it in the pivot table.

DEMO
SOURCE

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 shown with the virtualization option enabled through the EnableVirtualization property and an external server engine. This would improve pivot table rendering performance when working with large amounts of data.


More information about server-side aggregation can be found in this documentation section.

Transform your ASP.NET MVC web apps today with Syncfusion ASP.NET MVC components
85+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE