Category / Section
How to enable paging in PivotGrid?
1 min read
This KB illustrates that how to enable paging for PivotGrid.
Solution:
You can enable pager for PivotGrid with respective to JS, ASP and MVC platforms using the following code example.
Note:
Set EnablePaging to “True” and, SeriesPageSize as well as CategorialPageSize to a definite number, in the OLAP Report.
JavaScript
<script type="text/javascript"> $("#PivotGrid1").ejPivotGrid({ url: "../wcf/PagingService.svc }); $("#Pager").ejPivotPager({ mode: ej.PivotPager.Mode.Both, targetControlID: "PivotGrid1" }); </script>
MVC
@Html.EJ().Pivot().PivotGrid("PivotGrid1").Url(Url.Content("~/wcf/OLAPService.svc") @Html.EJ().Pivot().PivotPager("PivotPager1").Mode(PivotPagerMode.Both).TargetControlID("PivotGrid1")
ASP
<ej:PivotGrid ID="PivotGrid1" Url="../wcf/OLAPService.svc" runat="server"></ej:PivotGrid> <ej:PivotPager ID="PivotPager1" Mode="Both" TargetControlID="PivotGrid1"></ej:PivotPager>
C#
private OlapReport CreateOlapReport() { OlapReport olapReport = new OlapReport(); olapReport.CurrentCubeName = "Adventure Works"; olapReport.EnablePaging = true; olapReport.PagerOptions.SeriesPageSize = 20; olapReport.PagerOptions.CategorialPageSize = 15; DimensionElement dimensionElement = new DimensionElement() { Name = "Customer" }; dimensionElement.AddLevel("Customer", "Customer"); olapReport.CategoricalElements.Add(dimensionElement); DimensionElement dimensionElementRow = new DimensionElement() { Name = "Customer", HierarchyName = "Customer" }; dimensionElementRow.AddLevel("Customer Geography", "Country"); olapReport.SeriesElements.Add(dimensionElementRow); MeasureElements measureElementColumn = new MeasureElements(); measureElementColumn.Elements.Add(new MeasureElement { Name = "Internet Sales Amount" }); olapReport.CategoricalElements.Add(measureElementColumn); return olapReport; }
VB
Private Function CreateOlapReport() As OlapReport Dim olapReport As OlapReport = New OlapReport() olapReport.CurrentCubeName = "Adventure Works" olapReport.EnablePaging = True olapReport.PagerOptions.SeriesPageSize = 20 olapReport.PagerOptions.CategorialPageSize = 15 Dim dimensionElement As DimensionElement = New DimensionElement() With {.Name = "Customer"} dimensionElement.AddLevel("Customer", "Customer") olapReport.CategoricalElements.Add(dimensionElement) Dim dimensionElementRow As DimensionElement = New DimensionElement() With {.Name = "Customer", .HierarchyName = "Customer"} dimensionElementRow.AddLevel("Customer Geography", "Country") olapReport.SeriesElements.Add(dimensionElementRow) Dim measureElementColumn As MeasureElements = New MeasureElements() measureElementColumn.Elements.Add(New MeasureElement With {.Name = "Internet Sales Amount"}) olapReport.CategoricalElements.Add(measureElementColumn) Return olapReport End Function