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

PivotItem.ShowDetails Property

Gets or sets a value indicating whether the outline is expanded for the pivot item.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

bool ShowDetails { get; set; }

#Property Value

Type Description
Boolean

true, to show details for the current item; otherwise, false.

#Remarks

The ShowDetails property is in effect only when the specified item belongs to an outer row or column field and can be used to expand or collapse the details for the item.

For example, the following code snippet demonstrates how to hide details for the first item (“Dairy Products”) in the “Category” field.

pivotTable.Fields["Category"].Items[0].ShowDetails = false;

The image below shows the result of the code’s execution.

PivotTable_CollapseItem

Note that you can also hide the expand/collapse buttons in the report by using the PivotViewOptions.ShowDrillIndicators property.

See Also