Grid Layout in EJ 1 ASP.NET MVC PivotGrid

11 Feb 2019 / 1 minute to read

Normal Layout

A layout in which summary cells are positioned at the bottom of each parent member and their child members appear next to them. Normal layout is the default layout in PivotGrid control. The enumeration property Layout needs to be set to “PivotGridLayout.Normal” in-order to view PivotGrid in normal layout.

  • cshtml
  • @Html.EJ().Pivot().PivotGrid("PivotGrid1").Layout(PivotGridLayout.Normal).Url(Url.Content("/OLAPService"))

    Normal layout in ASP NET MVC pivot grid control

    No Summaries Layout

    IMPORTANT

    This feature is applicable only for OLAP datasource.

    A layout in which summary cells are completely hidden and the child members appear next to their parent member. The enumeration property Layout needs to be set to “PivotGridLayout.NoSummaries” in-order to view PivotGrid without summaries.

  • cshtml
  • @Html.EJ().Pivot().PivotGrid("PivotGrid1").Layout(PivotGridLayout.NoSummaries).Url(Url.Content("/OLAPService"))

    No summaries layout in ASP NET MVC pivot grid control

    Excel-like Layout

    A layout in which summary cells are positioned besides each parent member and their child members appear next to them. The enumeration property Layout needs to be set to “PivotGridLayout.ExcelLikeLayout” in-order to view PivotGrid in excel-like layout.

  • cshtml
  • @Html.EJ().Pivot().PivotGrid("PivotGrid1").Layout(PivotGridLayout.ExcelLikeLayout).Url(Url.Content("/OLAPService"))

    Excel like layout in ASP NET MVC pivot grid control

    Top Summary Layout

    IMPORTANT

    This feature is applicable only for OLAP datasource only at Server Mode.

    A layout in which summary cells are positioned at the top of each parent member and their child members appear next to them. The enumeration property Layout needs to be set to “PivotGridLayout.NormalTopSummary” in-order to view PivotGrid in top summaries layout.

  • cshtml
  • @Html.EJ().Pivot().PivotGrid("PivotGrid1").Layout(PivotGridLayout.NormalTopSummary).Url(Url.Content("~/OLAPService"))

    Top summary layout in ASP NET MVC pivot grid control