PivotGridCommands Properties
Provides access to pivot grid commands.
Name | Description |
---|---|
Add |
Adds a format condition to the format condition collection. |
Change |
Toggles the specified field’s sort order. |
Change |
Toggles the specified field value‘s expanded state. |
Clear |
Clear format conditions from all measures. |
Clear |
Clear format conditions from the specified intersection of row and column fields. |
Clear |
Clear format conditions from the specified measure. |
Clear |
Disables sorting in OLAP mode. |
Collapse |
Collapses all the rows/columns which correspond to the specified column field or row field. |
Expand |
Expands all the rows/columns which correspond to the specified column field or row field. |
Hide |
Hides the specified field. |
Hide |
Hides the Field List. |
Hide |
Hides the Filter Editor. |
Reload |
Reloads data from the control’s data source and recalculates summaries. |
Reset |
Resets the Filter Editor settings to their default values. |
Show |
Invokes the ‘Above Average’ format condition dialog. |
Show |
Invokes the ‘A Date Occuring’ format condition dialog. |
Show |
Invokes the ‘Below Average’ format condition dialog. |
Show |
Invokes the ‘Between’ format condition dialog. |
Show |
Invokes the ‘Bottom 10 Items’ format condition dialog. |
Show |
Invokes the ‘Bottom 10%’ format condition dialog. |
Show |
Invokes the ‘Conditional Formatting Rules Manager’ dialog. |
Show |
Invokes the ‘Custom Condition’ format condition dialog. |
Show |
Invokes the ‘Equal To’ format condition dialog. |
Show |
|
Show |
Shows the Field List. |
Show |
Shows the Filter Editor. |
Show |
Invokes the ‘Greater Than’ format condition dialog. |
Show |
Invokes the ‘Less Than’ format condition dialog. |
Show |
Creates the print document from the Pivot |
Show |
Creates the print document from the Pivot |
Show |
Invokes the ‘Text That Contains’ format condition dialog. |
Show |
Invokes the ‘Top 10 Items’ format condition dialog. |
Show |
Invokes the ‘Top 10%’ format condition dialog. |
Show |
Shows the Expression Editor. |
Sort |
In OLAP mode, sorts values of the specified field in ascending order. |
Sort |
In OLAP mode, sorts values of the specified field in descending order. |
See Also