Retrieves or sets the maximum number of columns to be displayed on the control's list.
Type
Description
Long
A Long expression that specifies the number of columns to be to be added during
the execution of the current layout. If negative all executing columns are shown
in the control's list
By default, the The DisplayPivotFields property is 256. 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.
For instance, this property is useful to limit the columns to be added to the
control's list, when you are grouping more columns, which can generate a lot
of columns to be shown. This property prevent showing all of them during
executing of the layout. The PivotColumns
property indicates the list of data columns to be shown on the control's list.
The DisplayPivotRows property
retrieves or sets the maximum number of rows to be generated on the control's list.