IField

23 Sep 20252 minutes to read

Allows you to configure the information retrieved from the data source for the field list.

Properties

aggregateType string

It allows to set the current aggregate type to the specific field.

allowDragAndDrop boolean

It allows to enable/disable the drag and drop option to grouping bar and field list button.

baseField string

It allows to set the selective field name to the field to perform aggregation.

baseItem string

It allows to set the selective member of the specific field to perform aggregation.

caption string

It allows to set the field caption.

dateMember IAxisSet[]

It allows to set date members information of the specific field.

expandAll boolean

Allows you to expand or collapse all of the pivot table’s headers for a specific field.

filter string[]

It allows to set the current filter members to the specific field.

filterType string

It allows to change the specific field’s type.

format string

It allows to set the format to the specific field.

formatString string

It allows to set the current number format string of the field.

formattedMembers IMembers

It allows to set members caption information of the specific field.

formula string

It allows to set the calculated field formula.

id string

It allows to set the field name.

index number

It allows to set the exact position of the specific field situated in the given data source.

isAlphanumeric boolean

It allows you to check if the custom sort type of a specific field is Alphanumeric or not.

isCalculatedField boolean

Allows to set whether is is a calculated field or not.

isCustomField boolean

Allows to set whether the specific field is custom grouped or not.

isExcelFilter boolean

Allows to set the specific field for excel-like filtering.

isSelected boolean

Allows to set whether the specific field is selected or not.

members IMembers

It allows to set members information of the specific field.

membersOrder string[]|number[]

It allows to set custom sort members of the specific field.

pid string

It allows to set the parent name.

showEditIcon boolean

It allows to set the visibility of calculated field edit icon in grouping bar and field list button.

showFilterIcon boolean

It allows to set the visibility of filter icon in grouping bar and field list button.

showNoDataItems boolean

Allows to set the specific field to display the data items that are not in combination with respect to current report.

showRemoveIcon boolean

It allows to set the visibility of remove icon in grouping bar button.

showSortIcon boolean

It allows to set the visibility of sort icon in grouping bar and field list button.

showSubTotals boolean

It allows enable/disable sub total in pivot table.

showValueTypeIcon boolean

It allows to set the visibility of summary type drop down icon in grouping bar and field list button.

sort string

It allows to set the current sort order to the specific field.

type string

It allows to set the field type to be either number or string or data or datetime.