PivotGridOptionsData.DrillDownMaxRowCount Property

Gets or sets the maximum number of rows returned when obtaining underlying data.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v20.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.WindowsDesktop.PivotGrid.Core

Declaration

C#

[DefaultValue(-1)]
public int DrillDownMaxRowCount { get; set; }

VB.NET

<DefaultValue(-1)>
Public Property DrillDownMaxRowCount As Integer

Property Value

Type	Default	Description
Int32	-1	An integer value that specifies the maximum number of rows returned when calling the CreateDrillDownDataSource method.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to DrillDownMaxRowCount
WinForms Controls	PivotGridControl	.OptionsData .DrillDownMaxRowCount
Reporting	XRPivotGrid	.OptionsData .DrillDownMaxRowCount
ASP.NET MVC Extensions	MVCxPivotGrid	.OptionsData .DrillDownMaxRowCount
	PivotGridSettings	.OptionsData .DrillDownMaxRowCount
ASP.NET Web Forms Controls	ASPxPivotGrid	.OptionsData .DrillDownMaxRowCount

Remarks

In regular binding mode, if the DrillDownMaxRowCount property is set to -1, all the records are retrieved when calling the CreateDrillDownDataSource method. In OLAP mode, if the DrillDownMaxRowCount property is set to -1, the maximum number of rows returned is limited to 10,000.