Skip to main content

PivotGridCommands Properties

Provides access to pivot grid commands.
Name Description
AddFormatCondition static Adds a format condition to the format condition collection.
ChangeFieldSortOrder static Toggles the specified field’s sort order.
ChangeFieldValueExpanded static Toggles the specified field value‘s expanded state.
ClearFormatConditionsFromAllMeasures static Clear format conditions from all measures.
ClearFormatConditionsFromIntersection static Clear format conditions from the specified intersection of row and column fields.
ClearFormatConditionsFromMeasure static Clear format conditions from the specified measure.
ClearSorting static Disables sorting in OLAP mode.
CollapseField static Collapses all the rows/columns which correspond to the specified column field or row field.
ExpandField static Expands all the rows/columns which correspond to the specified column field or row field.
HideField static Hides the specified field.
HideFieldList static Hides the Field List.
HideFilterEditor static Hides the Filter Editor.
HidePrefilter static Hides the Prefilter.
ReloadData static Reloads data from the control’s data source and recalculates summaries.
ResetFilterCriteria static Resets the Filter Editor settings to their default values.
ResetPrefilter static Resets the Prefilter‘s settings to their default values.
ShowAboveAverageFormatConditionDialog static Invokes the ‘Above Average’ format condition dialog.
ShowADateOccurringFormatConditionDialog static Invokes the ‘A Date Occuring’ format condition dialog.
ShowBelowAverageFormatConditionDialog static Invokes the ‘Below Average’ format condition dialog.
ShowBetweenFormatConditionDialog static Invokes the ‘Between’ format condition dialog.
ShowBottom10ItemsFormatConditionDialog static Invokes the ‘Bottom 10 Items’ format condition dialog.
ShowBottom10PercentFormatConditionDialog static Invokes the ‘Bottom 10%’ format condition dialog.
ShowConditionalFormattingManager static Invokes the ‘Conditional Formatting Rules Manager’ dialog.
ShowCustomConditionFormatConditionDialog static Invokes the ‘Custom Condition’ format condition dialog.
ShowEqualToFormatConditionDialog static Invokes the ‘Equal To’ format condition dialog.
ShowFieldList static Shows the Field List.
ShowFilterEditor static Shows the Filter Editor.
ShowGreaterThanFormatConditionDialog static Invokes the ‘Greater Than’ format condition dialog.
ShowLessThanFormatConditionDialog static Invokes the ‘Less Than’ format condition dialog.
ShowPrefilter static Shows the Prefilter.
ShowPrintPreview static Creates the print document from the PivotGridControl and displays the Print Preview of the document.
ShowPrintPreviewDialog static Creates the print document from the PivotGridControl and displays the modal Print Preview of the document.
ShowTextThatContainsFormatConditionDialog static Invokes the ‘Text That Contains’ format condition dialog.
ShowTop10ItemsFormatConditionDialog static Invokes the ‘Top 10 Items’ format condition dialog.
ShowTop10PercentFormatConditionDialog static Invokes the ‘Top 10%’ format condition dialog.
ShowUnboundExpressionEditor static Shows the Expression Editor.
SortAscending static In OLAP mode, sorts values of the specified field in ascending order.
SortDescending static In OLAP mode, sorts values of the specified field in descending order.
See Also