.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

PivotLayout.RepeatAllItemLabels(Boolean) Method

Specifies whether to repeat item labels for all outer row and column fields in a pivot table.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.1.Core.dll


void RepeatAllItemLabels(
    bool repeat
Sub RepeatAllItemLabels(
    repeat As Boolean


Name Type Description
repeat Boolean

true, to repeat item labels in the outer fields; otherwise, false.


If your PivotTable report contains multiple fields in the row or column area, you can specify how to display item labels in the outer row and column fields. By default, items of the outermost column and row fields are displayed only once, while items in the remaining column and row fields are repeated as needed. If you wish to repeat item labels in all outer row and column fields, call the RepeatAllItemLabels method.

Do Not Repeat Item Labels

(the default option)

Repeat All Item Labels



To repeat item labels in a particular field, use the field's PivotFieldLayout.RepeatItemLabels property.


Repeated labels for the outer row fields are displayed only when a pivot table is shown in outline or tabular form. To change the report layout, use the PivotLayout.SetReportLayout method.


Dim worksheet As Worksheet = workbook.Worksheets("Report5")
workbook.Worksheets.ActiveWorksheet = worksheet

' Access the pivot table by its name in the collection.
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")
' Display repeated column labels.
See Also