Pivot Grid - Remote Virtual Scrolling

Remote virtual scrolling allows the PivotGrid to load data pages from the server when they enter the viewport. To enable remote virtual scrolling, set the component's scrolling.mode property to "virtual" and the PivotGridDataSource's paginate property to true. Refer to the paginate description for more information about paging specifics.

Was this demo helpful?

Thank you!

Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.

Thank you for the feedback!

Backend API

<div class="long-title"><h3>Sales Statistics</h3></div> @(Html.DevExtreme().PivotGrid() .AllowSorting(true) .AllowFiltering(true) .Height(570) .ShowBorders(true) .FieldPanel(fp => fp .Visible(true) .ShowFilterFields(false) ) .FieldChooser(fc => fc.AllowSearch(true)) .HeaderFilter(hf => hf.Search(hfs => hfs.Enabled(true))) .Scrolling(fc => fc.Mode(PivotGridScrollingMode.Virtual)) .DataSource(d => d .Paginate(true) .Fields(fields => { fields.Add() .DataField("[Customer].[Customer]") .Area(PivotGridArea.Row); fields.Add() .DataField("[Ship Date].[Calendar Year]") .Area(PivotGridArea.Column); fields.Add() .DataField("[Ship Date].[Month of Year]") .Area(PivotGridArea.Column); fields.Add() .DataField("[Measures].[Internet Sales Amount]") .Area(PivotGridArea.Data); }) .Store(s => s.Xmla() .Url("https://demos.devexpress.com/Services/OLAP/msmdpump.dll") .Catalog("Adventure Works DW Standard Edition") .Cube("Adventure Works") ) ) )

using DevExtreme.NETCore.Demos.Models.SampleData; using Microsoft.AspNetCore.Mvc; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Linq; namespace DevExtreme.NETCore.Demos.Controllers { public class PivotGridController : Controller { public ActionResult RemoteVirtualScrolling() { return View(); } } }

.long-title h3 { font-family: 'Segoe UI Light', 'Helvetica Neue Light', 'Segoe UI', 'Helvetica Neue', 'Trebuchet MS', Verdana; font-weight: 200; font-size: 28px; text-align: center; margin-bottom: 20px; }