ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage functions / Controls, pages and windows / Pivot Table functions
  • Specifying the headers
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Allows you to:
  • Specify the row and column headers displayed in a Pivot Table control.
  • Find out the row and column headers displayed in a Pivot Table control.
Example
// Spécifie les entêtes de lignes et de colonnes affichés
IF INT_InverseAxe = True THEN
	PVTAxisXY(TCD_Stats, "COL_Date" + CR + "COL_Produit", "COL_Vendeur")
ELSE
	PVTAxisXY(TCD_Stats, "COL_Vendeur", "COL_Date" + CR + "COL_Produit")
END
Syntax

Specifying the row and column headers Hide the details

PVTAxisXY(<Pivot Table control> , <List of column headers> , <List of row headers>)
<Pivot Table control>: Control name
Name of the Pivot Table control to be used.
<List of column headers>: Character string
List of column headers (displayed on the X-axis). This list contains the different column headers separated by CR characters (Carriage Return).
This list can use one of the following syntaxes:
  • <Nom entête 1>..Name + RC + ... + RC + <Nom entête N>..Name
    Example:
    COL_Date..Name + CR + COL_Product..Name
  • "<Header Name 1>" + CR + ... + CR + "<Header Name N>"
    Example:
    "COL_Date" + CR + "COL_Product"
<List of row headers>: Character string
List of row headers (displayed on the Y-axis). This list contains the different row headers separated by CR characters (Carriage Return). This list can use one of the following syntaxes:
  • <Nom entête 1>..Name + RC + ... + RC + <Nom entête N>..Name
    Example:
    COL_Date..Name + CR + COL_Product..Name
  • "<Header Name 1>" + CR + ... + CR + "<Header Name N>"
    Example:
    "COL_Date" + CR + "COL_Product"

Finding out the row and column headers Hide the details

<Result> = PVTAxisXY(<Pivot Table control>)
<Result>: Character string
List of row and column headers displayed in the Pivot Table control. This list has the following format:
<Name header column 1> + CR + ...+ CR + <Name header column N> + EOT +
<Name header row 1> + CR + ...+ CR + <Name header row N> + EOT +
<Nom Filtre 1> + RC + ... RC + ... <Nom Filtre N>
For example:
COL_OrderDate + CR + COL__OrderDate_Quarter + CR+
COL_OrderDate_Month + EOT + COL_Country + CR + COL_City + EOT + PVT_Caption
<Pivot Table control>: Control name
Name of the Pivot Table control to be used.
Remarks

Specifying the headers

  • The Pivot Table control does not have to be re-calculated and the display is immediate.
  • The specified headers must correspond to existing headers. You can for example:
    • reverse the row and column headers.
    • specify fewer headers than the ones defined in the control.
Component: wd300obj.dll
Minimum version required
  • Version 19
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help