Edit this page

Layouts Overview

RadPivotGrid offers three options for setting its row table layout, so that it better fits the requirements for displaying data of a given scenario. To choose which layout your pivot grid should use, set the RowTableLayout property of the control to one of the listed values: Compact, Outline or Tabular.

<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" RowTableLayout="Compact">

Below follow descriptions of the layouts and their main usage.

Compact

Use this layout to keep related data from spreading horizontally off the screen and to help minimize scrolling.Beginning fields on the side are contained in one column and are indented to show the nested column relationship:
Compact layout

Outline

Use to outline the data in the classic PivotTable style:
Outline layout

Tabular

Use to see all data in a traditional table format and to easily copy cells to another worksheet. Tabular is the default value of the RowTableLayout property.
Tabular layout

Layout specifics

When the Compact layout is used and the vertical scroll is disabled the * RowHeaderZone contains only one cell* with rendered PivotGridFieldRenderingControlsinto it:
RowHeaderZone with Compact layout and scrolling

In this case the RadPivotgrid.GetRowZones() method will return collection which contains only one PivotGridRowZone item.

When the other two layouts are chosen or the vertical scroll is enabled the RowHeaderZone contains one or more cells corresponding to the PivotGridRowFields count. For example: If the RadPivotGrid control contains three PivotGridRowField the RowHeaderZone will have three cells.
RowHeaderZone with other layouts and scrolling

In this case the RadPivotgrid.GetRowZones() method will return collection which contains threePivotGridRowZone items.