PVTAxisXY (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Specifying the headers

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

PVTAxisXY (Function)

In french: TCDAxeXY

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:

<Name header 1>..Name + CR + ... + CR + <Name header N>..Name

Example:

COL_Date..Name + CR + COL_Product..Name

"<Name header 1>" + CR + ... + CR + "<Name header 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:

<Name header 1>..Name + CR + ... + CR + <Name header N>..Name

Example:

COL_Date..Name + CR + COL_Product..Name

"<Name header 1>" + CR + ... + CR + "<Name header 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.

Component : wd240obj.dll