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
