Back to Devexpress

PivotTableField Properties

blazor-devexpress-dot-blazor-dot-pivottable-dot-pivottablefield-dot-underscore-properties.md

latest28.0 KB
Original Source

PivotTableField Properties

Stores information about the current Pivot Table field.

NameDescription
ActualDataTypeGets the field’s actual data type. Inherited from PivotGridFieldBase.
ActualSortModeThis member supports the internal infrastructure and is not intended to be used directly from your code. Inherited from PivotGridFieldBase.
AllowedAreasGets or sets the areas within which the field can be positioned. Inherited from PivotGridFieldBase.
AnnotationAttributesReturns the object that contains current values for all existing Data Annotation Attributes. Inherited from PivotGridFieldBase.
AreaGets or sets the area in which the field is displayed. Inherited from PivotGridFieldBase.
AreaIndexGets or sets the field’s index from among the other fields displayed within the same area. Inherited from PivotGridFieldBase.
AutoPopulatedPropertiesGet or set a collection of OLAP member properties. Inherited from PivotGridFieldBase.
CalculateHiddenSummariesAllows you to calculate summary values for hidden data fields. Inherited from PivotGridFieldBase.
CanFilterThis member supports the .NET Framework infrastructure and is not intended to be used directly from your code. Inherited from PivotGridFieldBase.
CanHideThis member supports the .NET Framework infrastructure and is not intended to be used directly from your code. Inherited from PivotGridFieldBase.
CanRaiseEvents protectedGets a value indicating whether the component can raise an event. Inherited from Component.
CanSortThis member supports the .NET Framework infrastructure and is not intended to be used directly from your code. Inherited from PivotGridFieldBase.
CanSortBySummaryGets whether the current field’s values can be sorted by values in other columns/rows. Inherited from PivotGridFieldBase.
CaptionGets or sets the field’s display caption. Inherited from PivotGridFieldBase.
CellFormatProvides access to the format settings applied to cells. Inherited from PivotGridFieldBase.
ColumnHandleObsolete. Gets the field’s unique identifier. Inherited from PivotGridFieldBase.
ColumnValueLineCountIf the current field is displayed in the Column Header Area, this property gets or sets the height of the field’s values, in text lines. Inherited from PivotGridFieldBase.
ContainerGets the IContainer that contains the Component. Inherited from Component.
DataBindingGets or sets an object that specifies the Pivot Grid field’s source data. Inherited from PivotGridFieldBase.
DataTypeGets the field’s data type. Inherited from PivotGridFieldBase.
DefaultDateFormat staticProvides access to global formatting settings for date/time values. Inherited from PivotGridFieldBase.
DefaultDecimalFormat staticProvides access to global formatting settings for decimal values. Inherited from PivotGridFieldBase.
DefaultPercentFormat staticProvides access to global formatting settings for percent values. Inherited from PivotGridFieldBase.
DefaultTotalFormat staticProvides access to global format settings for total values. Inherited from PivotGridFieldBase.
DesignMode protectedGets a value that indicates whether the Component is currently in design mode. Inherited from Component.
DisplayFolderGets or sets the name of the folder containing the field. Inherited from PivotGridFieldBase.
DrillDownColumnNameFor internal use. Inherited from PivotGridFieldBase.
EmptyCellTextGets the text displayed by an empty cell. Inherited from PivotGridFieldBase.
EmptyValueTextGets the text used for an empty field value header. Inherited from PivotGridFieldBase.
Events protectedGets the list of event handlers that are attached to this Component. Inherited from Component.
ExpandedInFieldsGroupGets or sets the expansion status of the current field if it belongs to a field group. Inherited from PivotGridFieldBase.
ExpressionFieldNameGets the field’s name in unbound expressions. Inherited from PivotGridFieldBase.
FieldNameGets or sets the name of the database field that is assigned to the current PivotGridFieldBase object. Inherited from PivotGridFieldBase.
FilterColumnNameGets the column name mapped to the field in the filter control’s view model. For internal use. Inherited from PivotGridFieldBase.
FilterValuesGets or sets filter values for the current field. Inherited from PivotGridFieldBase.
GrandTotalCellFormatProvides access to the format settings applied to grand total values. Inherited from PivotGridFieldBase.
GrandTotalTextGets or sets the text displayed within the Grand Total‘s header that corresponds to the current field. Inherited from PivotGridFieldBase.
GroupGets the group which owns the current field. Inherited from PivotGridFieldBase.
GroupIndexGets the index of the field group which owns the current field. Inherited from PivotGridFieldBase.
GroupIntervalGets or sets how the values of the current column or row field are combined into groups. Inherited from PivotGridFieldBase.
GroupIntervalNumericRangeGets or sets the length of the intervals when values are grouped together. Inherited from PivotGridFieldBase.
HasNullValuesGets whether the field has null values. Inherited from PivotGridFieldBase.
HeaderDisplayTextReturns the string displayed within the field’s header, taking into account the field’s PivotGridFieldBase.Caption and the PivotGridFieldBase.SummaryType. The field’s summary type is appended to the field’s Caption if the PivotGridFieldOptions.ShowSummaryTypeName property is enabled. Inherited from PivotGridFieldBase.
HierarchyGets the hierarchy to which the dimension level represented by the current field belongs. Inherited from PivotGridFieldBase.
InnerGroupIndexGets the index of the field in a field group. Inherited from PivotGridFieldBase.
InvalidPropertyDisplayText staticFor internal use. Inherited from PivotGridFieldBase.
IsColumnGets whether the field is displayed within the Column Header Area. Inherited from PivotGridFieldBase.
IsColumnOrRowGets whether the current field is displayed within the Column Header Area or Row Header Area. Inherited from PivotGridFieldBase.
IsDataFieldThis member supports the .NET Framework infrastructure and is not intended to be used directly from your code. Inherited from PivotGridFieldBase.
IsUnboundExpressionValidGets whether the PivotGridFieldBase.UnboundExpression property’s value specifies a valid expression. Inherited from PivotGridFieldBase.
KPIGraphicGets or sets a graphic set used to indicate KPI values. Inherited from PivotGridFieldBase.
KPITypeGets the KPI type. Inherited from PivotGridFieldBase.
MinWidthGets or sets the minimum allowed width of columns that correspond to the current field. Inherited from PivotGridFieldBase.
NameGets or sets the field’s name. Inherited from PivotGridFieldBase.
NamePrefix staticGets the prefix that is used to create field names at design time. Inherited from PivotGridFieldBase.
OLAPDimensionCaptionSpecifies the OLAP dimension’s caption displayed in the Customization form’s field list. Inherited from PivotGridFieldBase.
OLAPDrillDownColumnNameIn OLAP mode, gets the name of the corresponding column in the underlying data source, on an OLAP server. Inherited from PivotGridFieldBase.
OLAPExpressionGets or sets an expression used to evaluate values for the current unbound field in OLAP. Inherited from PivotGridFieldBase.
OptionsContains the field’s options. Inherited from PivotGridFieldBase.
RowValueLineCountIf the current field is displayed in the Row Header Area, this property gets or sets the height of the field’s values, in text lines. Inherited from PivotGridFieldBase.
RunningTotalGets or sets whether Running totals are calculated for values in the Data Area that correspond to the current column or row field. Inherited from PivotGridFieldBase.
ShowActiveFilterButtonGets whether the Filter Button is displayed as active. Inherited from PivotGridFieldBase.
ShowFilterButtonGets whether the Filter Button is visible within the current field’s header. Inherited from PivotGridFieldBase.
ShowNewValuesGets or sets whether field values that have appeared in the datasource after the field’s filtering was configured should be shown. Inherited from PivotGridFieldBase.
ShowSortButtonGets whether the Sort Button is visible in the current field’s header. Inherited from PivotGridFieldBase.
SiteGets or sets the ISite of the Component. Inherited from Component.
SortByAttributeGets or sets the OLAP member property name by which the pivot grid’s data is sorted. Inherited from PivotGridFieldBase.
SortBySummaryInfoContains the settings used to sort the values of the current column field or row field by summary values in rows/columns. Inherited from PivotGridFieldBase.
SortModeGets or sets how the field’s data is sorted. Inherited from PivotGridFieldBase.
SortOrderGets or sets the field’s sort order. Inherited from PivotGridFieldBase.
SummaryDisplayTypeGets or sets how a summary value calculated against the current data field is represented in a cell. Inherited from PivotGridFieldBase.
SummaryFilterGets summary filtering settings. Inherited from PivotGridFieldBase.
SummaryTypeGets or sets the type of the summary function which is calculated against the current data field. Inherited from PivotGridFieldBase.
TagGets or sets the data associated with the field. Inherited from PivotGridFieldBase.
TopValueCountGets or sets the absolute or relative number of field values that should be displayed for the current column field or row field. Inherited from PivotGridFieldBase.
TopValueModeGets or sets whether top n values for a specified data field are calculated based on all data source records or in the parent category. Inherited from PivotGridFieldBase.
TopValueShowOthersGets or sets whether the “Others” item is displayed within the Pivot Grid when the Top X Value feature is enabled. Inherited from PivotGridFieldBase.
TopValueTypeGets or sets how the number of Top Values is determined. Inherited from PivotGridFieldBase.
TotalCellFormatProvides access to the format settings applied to total cells. Inherited from PivotGridFieldBase.
TotalsVisibilityGets or sets whether to display totals for the current field when it is in the Column Header Area or Row Header Area and if so, whether they are automatic or custom. Inherited from PivotGridFieldBase.
TotalValueFormatProvides access to the format settings applied to the total header. Inherited from PivotGridFieldBase.
UnboundExpressionGets or sets an expression used to evaluate the unbound field’s value. Inherited from PivotGridFieldBase.
UnboundExpressionModeGets or sets how the specified data field’s unbound expression is calculated. Inherited from PivotGridFieldBase.
UnboundFieldNameGets or sets the name of a column in a summary data source that corresponds to the current unbound field. Inherited from PivotGridFieldBase.
UnboundTypeGets or sets the field’s data type and binding mode. Inherited from PivotGridFieldBase.
UseDecimalValuesForMaxMinSummaryFor internal use. Inherited from PivotGridFieldBase.
UseNativeFormatGets or sets whether to use the current field’s data format when the Pivot Grid Control is exported in XLS/XLSX formats. Inherited from PivotGridFieldBase.
ValueFormatProvides access to the format settings applied to field values. Inherited from PivotGridFieldBase.
VisibleGets or sets whether the field is visible. Inherited from PivotGridFieldBase.
WidthGets or sets the width of columns that correspond to the current field. Inherited from PivotGridFieldBase.

See Also

PivotTableField Class

PivotTableField Members

DevExpress.Blazor.PivotTable Namespace