<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.

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