PivotViewOptions.ShowDrillIndicators Property

Gets or sets a value indicating whether the expand/collapse buttons should be displayed in a pivot table.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

bool ShowDrillIndicators { get; set; }

VB.NET

Property ShowDrillIndicators As Boolean

Property Value

Type	Description
Boolean	true, to display drill indicators; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to ShowDrillIndicators
PivotTable	.View .ShowDrillIndicators

Remarks

The expand and collapse buttons are displayed in a multi-layered PivotTable report by default and allow end-users to expand or collapse items within the pivot table. However, you can hide these buttons by setting the ShowDrillIndicators property to false.

The images below demonstrate how the ShowDrillIndicators property works.

ShowDrillIndicators = true (the default option)	ShowDrillIndicators = false