PVTSelect (Function)

Allows you find out the position of the selected cell and to select a cell in a Pivot Table control.

Example

// Get the current position
pvtPos is pvtPosition
pvtPos = PVTSelect(PVT_Stats)
IF NOT pvtPos..Out THEN
Trace(pvtPos.Country + " " + pvtPos.City)
END

Versions 21 and later

// Browse the selected cells
pvtPos is pvtPosition of PVT_MyPVT

nbSel is int = PVTSelectOccurrence(PVT_MyPVT)
FOR i = 1 TO nbSel
pvtPos = PVTSelect(PVT_MyPVT, i)
Trace(pvtPos.COL_Today_Date + ":" + pvtPos.COL_Product))
END

New in version 21

// Browse the selected cells
pvtPos is pvtPosition of PVT_MyPVT

nbSel is int = PVTSelectOccurrence(PVT_MyPVT)
FOR i = 1 TO nbSel
pvtPos = PVTSelect(PVT_MyPVT, i)
Trace(pvtPos.COL_Today_Date + ":" + pvtPos.COL_Product))
END

pvtPos is pvtPosition
// Select "France / 2014"
pvtPos.Country = "FRANCE"
pvtPos.Year = "2014"
PVTSelect(PVT_Stats, pvtPos)

Syntax

Retrieving the position of selected cell in a Pivot Table control Hide the details

<Result> = PVTSelect(<Pivot Table control> [, <Rank>])

<Result>: pvtPosition variable

pvtPosition variable containing the position of selected cell in the control. If no element is selected, the ..Out property of returned pvtPosition variable is set to True.

<Pivot Table control>: Control name

Name of Pivot Table control to use.

<Rank>: Optional integer

Versions 21 and later
Rank of selection for a multiselection control. If this parameter is not specified, the position of first selected cell is returned.
New in version 21
Rank of selection for a multiselection control. If this parameter is not specified, the position of first selected cell is returned.
Rank of selection for a multiselection control. If this parameter is not specified, the position of first selected cell is returned.

Selecting a position in a Pivot Table control Hide the details

PVTSelect(<Pivot Table control> , <Position> [, <Value>])

<Pivot Table control>: Control name

Name of Pivot Table control to use.

<Position>: pvtPosition variable

Name of the pvtPosition variable corresponding to the position to select. A WLanguage error occurs if the position does not correspond to a visible cell.

<Value>: Character string (with or without quotes)

Name of the value to select. If this parameter is not specified and if several values are found in the same cell, the first value is selected.

Component : wd260obj.dll