PivotItem.ShowDetails Property

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

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

bool ShowDetails { get; set; }

VB.NET

Property ShowDetails As Boolean

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.

C#

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

VB.NET

pivotTable.Fields("Category").Items(0).ShowDetails = False

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

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