PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Collapses the data found in a Pivot Table control according to a row header or to a column header.
Example
// Collapses all quarters
PVTCollapse(PVT_Sales, COL_OrderDate_Quarter)
Syntax
PVTCollapse(<Pivot Table Control> , <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.
Components
WINDEVReports and Queries wd230obj.dll
Minimum required version
  • Version 18
This page is also available for…
Comments
Click [Add] to post a comment