Skip to main content
Row

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.1.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