<Pivot Table>.CollapseAll (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage functions / Controls, pages and windows / Pivot Table functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Pivot Table>.CollapseAll (Function)

In french: <Tableau croisé dynamique>.EnrouleTout

Collapses all row and/or column headers in a Pivot Table control.

Subscription-exclusive new feature

This function is now available for WEBDEV websites in Windows and Linux.

Note: This feature is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 4.
For more details, see Using new features exclusive to the subscription-based version of WINDEV Suite 2025.

Example

// Loads the data file
PVT_Statistics.Load(sFile)
// Collapses all headers of the Pivot Table control
PVT_Statistics.CollapseAll()

Syntax

<Pivot Table control>.CollapseAll([<Type of header>])

<Pivot Table control>: Control name

Name of the Pivot Table control to be used. This Pivot Table control must have been populated using <Pivot table>.CalculateAll or <Pivot Table>.Load.

<Type of header>: Optional Integer constant (or combination of constants)

Type of header to collapse:
pvtColumnHeader Collapses the column headers.
pvtRowHeader Collapses the row headers.

If this parameter is not specified, the row headers AND the column headers are collapsed.

Component: wd300obj.dll