Retrieves or sets the maximum number of rows to be generated on the control's list.
Type
Description
Long
A Long expression that specifies the number of rows when the control generates
the result.
By default, the DisplayPivotRows property is 16384, which
indicates that the number of rows is limited to 16384 rows. If the
DisplayPivotRows property is -1, there is no limit for generated rows. The DisplayPivotFields
property specifies the number of maximum columns to be added during the
execution of the current layout. The DisplayPivotData
property retrieves or sets the maximum number of rows to be displayed from the pivot's data.
