PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Specifying the headers
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
Used to:
  • Specify the row and column headers displayed in a Pivot Table control.
  • Versions 20 and later
    Find out the row and column headers displayed in a Pivot Table control.
    New in version 20
    Find out 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
// Specifies the row and column headers
IF CBOX_ReverseAxis = True THEN
PVTAxisXY(PVT_Stats, "COL_Date" + CR + "COL_Product", "COL_Salesman")
ELSE
PVTAxisXY(PVT_Stats, "COL_Salesman", "COL_Date" + CR + "COL_Product")
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 Pivot Table control to use.
<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:
  • <Header Name 1>..Name + CR + ... + CR + <Header Name N>..Name

    Example:
    COL_Date..Name + CR + COL_Product..Name
  • "<Name Header 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:
  • <Header Name 1>..Name + CR + ... + CR + <Header Name N>..Name

    Example:
    COL_Date..Name + CR + COL_Product..Name
  • "<Name Header 1>" + CR + ... + CR + "<Header Name N>"

    Example:
    "COL_Date" + CR + "COL_Product"
Versions 20 and later

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 +
<Name Filter 1> + CR + ... CR + <Name Filter 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 Pivot Table control to use.
New in version 20

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 +
<Name Filter 1> + CR + ... CR + <Name Filter 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 Pivot Table control to use.

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 +
<Name Filter 1> + CR + ... CR + <Name Filter 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 Pivot Table control to use.
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.
Components
WINDEVReports and Queries wd230obj.dll
Minimum required version
  • Version 19
This page is also available for…
Comments
Click [Add] to post a comment