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
Returns the values of headers corresponding to a position in a Pivot Table control in pixels.
Example
pos is pvtPosition of PVT_Statistics
pos = PVTInfoXY(PVT_Statistics, MouseXPos(), MouseYPos())
IF pos..Out = True THEN
STC_Caption  = ""
ELSE
STC_Caption = "Year =" + pos.Year + ...
"Product = " + pos.Product + ...
"Sales  = " + PVT_Statistics.VAL_Sales[pos]
END
Syntax
<Result> = PVTInfoXY(<Pivot Table Control> , <X> , <Y>)
<Result>: pvtPosition variable
pvtPosition variable containing the characteristics of selected cell.
Notes:
  • If the position does not correspond to a cell of pivot table (-1, -1), the ..Out property of pvtPosition variable is set to True.
  • The (0,0) position corresponds to the 1st cell at the top left.
<Pivot Table Control>: Control name
Name of Pivot Table control to use.
<X>: Integer
X coordinate (in pixels) to study. This coordinate is relative to the client area of the control.
<Y>: Integer
Y coordinate (in pixels) to study. This coordinate is relative to the client area of the control.
Components
WINDEVReports and Queries wd230obj.dll
Minimum required version
  • Version 18
This page is also available for…
Comments
Click [Add] to post a comment