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
PVTListPositionHeader (Function)
In French: TCDListePositionEntête
Returns all values associated with a row or column header in a Pivot Table control.
Example
// Returns all countries displayed in the Pivot Table control
arrPos is array of pvtPosition
arrPos = PVTListPositionHeader(PVT_Statistics, COL_Country)
FOR EACH dim OF arrPos
// Displays the total for each country if > 10000
IF VAL_TO[dim] > 10000
Trace(dim.Country + ": " + VAL_TO[dim])
END
END

// Returns all cities displayed in the Pivot Table control
arrPos = PVTListPositionHeader(PVT_Statistics, COL_City)
FOR EACH dim OF arrPos
// Traces the French cities
IF (dim.Country ~= "FRANCE") THEN
Trace(dim.City)
END
END
Syntax
<Result> = PVTListPositionHeader(<Pivot Table Control> , <Header>)
<Result>: Array of pvtPosition
Name of Array of pvtPosition variable containing the list of elements corresponding to the specified header.
<Pivot Table Control>: Control name
Name of Pivot Table control to use.
<Header>: Character string (with or without quotes)
Name of the row or column header for which the different elements must be listed. This header must be visible and it must be displayed in the control.
Remarks
In the result array:
  • The headers of parents are filled.
  • The headers of children or other axes have "*" for value (..Cumulated = True).
The same value can be returned several times with a different parent. For example, if we want to retrieve the list of vehicle makes per country, the same make can be used in several countries.
Components
WINDEVReports and Queries wd230obj.dll
Minimum required version
  • Version 19
This page is also available for…
Comments
Click [Add] to post a comment