Search results

DataSourceSettingsModel API in React Pivot Grid API component

Interface for a class DataSourceSettings

Properties

allowLabelFilter

boolean

It allows excel-like label filtering operation through UI and code-behind.

allowMemberFilter

boolean

It allows member filtering operation through UI and code-behind.

allowValueFilter

boolean

It allows excel-like value filtering operation through UI and code-behind.

alwaysShowValueHeader

boolean

It allows enable/disable single measure headers in pivot table.

calculatedFieldSettings

CalculatedFieldSettingsModel[]

It allows to set the settings of calculated field operation.

catalog

string

It allows to set the cube catalog name.

columns

FieldOptionsModel[]

It allows to set the column fields.

conditionalFormatSettings

ConditionalFormatSettingsModel[]

It allows to set the settings of Conditional Format operation.

cube

string

It allows to set the cube name.

dataSource

IDataSet[] | DataManager

It allows to set the data source.

drilledMembers

DrillOptionsModel[]

It allows to set the drilled state for desired field members.

emptyCellsTextContent

string

It allows to set the custom values to empty value cells .

enableSorting

boolean

It allows sorting operation UI.

excludeFields

string[]

It allows to hide fields from fieldlist.

expandAll

boolean

It allows to set the expanded state of headers.

filterSettings

FilterModel[]

It allows to set the settings of filtering operation.

filters

FieldOptionsModel[]

It allows to set the filter fields.

formatSettings

FormatSettingsModel[]

It allows to set the settings of number formatting.

groupSettings

GroupSettingsModel[]

It allows to set the settings for grouping the field.

localeIdentifier

number

It allows to set the locale code.

providerType

string

It allows to set the provider type.

rows

FieldOptionsModel[]

It allows to set the row fields.

showAggregationOnValueField

boolean

It allows enable/disable show aggregation on PivotButton.

showColumnGrandTotals

boolean

It allows enable/disable column grand total in pivot table.

showColumnSubTotals

boolean

It allows enable/disable column sub total in pivot table.

showGrandTotals

boolean

It allows enable/disable grand total in pivot table.

showHeaderWhenEmpty

boolean

If showHeaderWhenEmpty is set to false, then it will hide blank headers in pivot table.

showRowGrandTotals

boolean

It allows enable/disable row grand total in pivot table.

showRowSubTotals

boolean

It allows enable/disable row sub total in pivot table.

showSubTotals

boolean

It allows enable/disable sub total in pivot table.

sortSettings

SortModel[]

It allows to set the settings of sorting operation.

url

string

It allows to set the url string.

valueAxis

string

It allows to set the value fields in both column and row axis.

valueSortSettings

ValueSortSettingsModel

It allows to set the settings of value sorting operation.

values

FieldOptionsModel[]

It allows to set the value fields.