PivotItem

PivotItem class

Represents a item in a PivotField report.

class PivotItem;

Property	Type	Description
isHidden	boolean	Gets and Sets whether the pivot item is hidden.
position	number	Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.
positionInSameParentNode	number	Specifying the position index in the PivotItems under the same parent node.
isDetailHidden	boolean	Gets and sets whether the detail of this pivot item is hidden.
isCalculatedItem	boolean	Readonly. Indicates whether this pivot item is a calculated formula item.
isMissing	boolean	Readonly. Indicates whether the item is removed from the data source.
value	VObject	Readonly. Gets the value of the pivot item
name	string	Gets the name of the pivot item.
index	number	Gets the index of the pivot item in cache field.

Method	Description
move(number, boolean)	Moves the item up or down
getFormula()	Gets the formula of this calculated item. Only works when this item is calculated item.
getStringValue()	Gets the string value of the pivot item If the value is null, it will return ""
getDoubleValue()	Gets the double value of the pivot item If the value is null or not number ,it will return 0
getDateTimeValue()	Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue

Gets and Sets whether the pivot item is hidden.

isHidden : boolean;

Specifying the position index in all the PivotItems,not the PivotItems under the same parent node.

position : number;

Specifying the position index in the PivotItems under the same parent node.

positionInSameParentNode : number;

Gets and sets whether the detail of this pivot item is hidden.

isDetailHidden : boolean;

Readonly. Indicates whether this pivot item is a calculated formula item.

isCalculatedItem : boolean;

Readonly. Indicates whether the item is removed from the data source.

isMissing : boolean;

Remarks

True means this value has benn removed from the data source.

Readonly. Gets the value of the pivot item

value : VObject;

Gets the name of the pivot item.

name : string;

Gets the index of the pivot item in cache field.

index : number;

Moves the item up or down

move(count: number, isSameParent: boolean) : void;

Parameters:

Parameter	Type	Description
count	number	The number of moving up or down. /// Move the item up if this is less than zero; /// Move the item down if this is greater than zero.
isSameParent	boolean	Specifying whether moving operation is in the same parent node or not

Gets the formula of this calculated item. Only works when this item is calculated item.

getFormula() : string;

Gets the string value of the pivot item If the value is null, it will return ""

getStringValue() : string;

Gets the double value of the pivot item If the value is null or not number ,it will return 0

getDoubleValue() : number;

Gets the date time value of the pivot item If the value is null ,it will return DateTime.MinValue

getDateTimeValue() : Date;