<Pivot table>.Collapse (Function) - PC SOFT - Online documentation

PC SOFT

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

WINDEV

Windows

Linux

Universal Windows 10 App

Java

Reports and Queries

User code (UMC)

WEBDEV

Windows

Linux

PHP

WEBDEV - Browser code

WINDEV Mobile

Android

iPhone/iPad

Apple Watch

Mac Catalyst

Universal Windows 10 App

Others

Stored procedures

<Pivot table>.Collapse (Function)

In french: <Tableau croisé dynamique>.Enroule

Collapses the data found in a Pivot Table control according to a row header or to a column header.

Example

// Collapses all quarters
PVT_Sales.Collapse(COL_OrderDate_Quarter)

Syntax

<Pivot Table control>.Collapse(<Header to collapse>)

<Pivot Table control>: Control name

Name of Pivot Table control to use.

<Header to collapse>: Character string (with or without quotes)

Name of the row header or column header to collapse.

Related Examples:

WD PivotTable

Training (WINDEV): WD PivotTable

[ + ] This example presents the use of the Pivot Table control.

This Pivot Table control is used to display dynamic statistics while grouping the data.
These statistics are calculated form the database.

Component: wd270obj.dll

See also

Minimum version required

Version 23

This page is also available for…

Comments

Click [Add] to post a comment

Last update: 10/06/2021

Send a report | Local help

Close this window

Searching...

Annotate the page

Title:

I accept the terms of the license agreement

How to browse local help?

All you have to do is configure your product as follows:

Go to "Home .. Options .. General options of …".
In the "Help" tab, select "Use the local help database" and specify (if necessary) the path of the "Help" directory of your product.
Validate. The help used by default will be the local help installed on your computer.