PivotGridOptionsData.DrillDownMaxRowCount Property

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

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

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

VB.NET

<DefaultValue(-1)>
<XtraSerializableProperty>
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
ASP.NET Controls and MVC Extensions	ASPxPivotGrid	.OptionsData.DrillDownMaxRowCount
	MVCxPivotGrid	.OptionsData.DrillDownMaxRowCount
	PivotGridSettings	.OptionsData.DrillDownMaxRowCount
Reporting	XRPivotGrid	.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.