PivotItem class

PivotItem class

Represents a item in a PivotField report.

The PivotItem type exposes the following members:

Properties

PropertyDescription
is_hiddenGets and Sets whether the pivot item is hidden.
positionSpecifying the position index in all the PivotItems,not the PivotItems under the same parent node.
position_in_same_parent_nodeSpecifying the position index in the PivotItems under the same parent node.
is_hide_detailGets and sets whether the pivot item hides detail.
is_detail_hiddenGets and sets whether the detail of this pivot item is hidden.
is_calculated_itemIndicates whether this pivot item is a calculated formula item.
is_formulaIndicates whether this pivot item is a calculated formula item.
is_missingIndicates whether the item is removed from the data source.
valueGets the value of the pivot item
nameGets the name of the pivot item.
indexGets the index of the pivot item in cache field.

Methods

MethodDescription
moveMoves the item up or down
get_formulaGets the formula of this calculated item.
Only works when this item is calculated item.
get_string_valueGets the string value of the pivot item
If the value is null, it will return ""
get_double_valueGets the double value of the pivot item
If the value is null or not number ,it will return 0
get_date_time_valueGets the date time value of the pivot item
If the value is null ,it will return DateTime.MinValue

See Also