Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotFieldLayout.Compact Property

Gets or sets a value indicating whether item labels from the next row field should be displayed in the same column as the current row field.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

bool Compact { get; set; }

#Property Value

Type Description
Boolean

true, to display the next row field in the same column; otherwise, false.

#Remarks

If the current pivot field is an outer row field displayed in outline form (its PivotFieldLayout.Outline property is true), you can use the Compact property to show fields in the report condensed by displaying items of this field and the next one in a single column.

The following code snippet illustrates how to display items of the “Category” and “Product” row fields in the same column (the report is shown in outline form).

pivotTable.Layout.SetReportLayout(PivotReportLayout.Outline);
pivotTable.RowFields["Category"].Field.Layout.Compact = true;

PivotField_Layout_Compact

See Also