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

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

Declaration

void RepeatAllItemLabels(
    bool repeat
)
Sub RepeatAllItemLabels(
    repeat As Boolean
)

Parameters

Name Type Description
repeat Boolean

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

Remarks

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

SpreadsheetPivotTable_DoNotRepeatItemLabels

SpreadsheetPivotTable_RepeatAllItemLabels

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

NOTE

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.

Examples

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.
pivotTable.Layout.RepeatAllItemLabels(True)
See Also