Skip to main content

PivotGridFieldOptions Properties

Contains options for a field.
Name Description
AllowDrag Gets or sets whether an end-user is allowed to drag the Field Header.
AllowDragInCustomizationForm Gets or sets whether end-users are allowed to drag field headers between areas in the Customization Form.
AllowExpand Gets or sets whether an end-user is allowed to expand/collapse the rows or columns which correspond to the current field.
AllowFilter Gets or sets whether an end-user can apply a filter to the current field.
AllowFilterBySummary Gets or sets whether end-users are allowed to filter pivot grid data by summaries calculated against the current data field.
AllowRunTimeSummaryChange Gets or sets whether an end-user can change the data field’s summary type.
AllowSort Gets or sets whether an end-user can modify the field’s current sort order.
AllowSortBySummary Gets or sets whether end-users can sort the current row/column field values by other column/row summary values.
GroupFilterMode Gets or sets the filtering mode used for the field’s owner group.
HideEmptyVariationItems Gets or sets whether the first (empty) column/row that displays variation data for the current data field must be hidden.
OLAPFilterByUniqueName Gets or sets whether PivotGridControl should take into account OLAP member values or unique names when filtering data in an OLAP mode.
OLAPFilterUsingWhereClause Gets or sets whether to use the WHERE or subselect clause in an MDX query, when filtering against filter fields in OLAP mode.
OLAPUseNonEmpty Gets or sets whether the NonEmpty function should be used in MDX queries for the current measure.
ShowCustomTotals Gets or sets whether Custom Totals that correspond to the current Column Field or Row Field are visible.
ShowGrandTotal Gets or sets whether grand totals that correspond to the current data field are visible.
ShowGroupIntervalName Gets or sets whether to display a group interval name in the field header.
ShowInCustomizationForm Gets or sets whether the field’s header is displayed within the customization form when the field is hidden.
ShowInExpressionEditor Gets or sets whether the current field is available in the Expression Editor‘s field list.
ShowInFilter Gets or sets whether the field is available for selection in the Filter Editor.
ShowSummaryTypeName Gets or sets whether the summary type is displayed within the data field’s header.
ShowTotals Gets or sets whether Totals that correspond to the current data field are visible.
ShowValues Gets or sets whether data cells that correspond to the current data field are visible.
See Also