PivotGridCommands Members
In This Article
#Properties
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. |
#Methods
Name | Description |
---|---|
Equals |
Determines whether the specified object instances are considered equal. Inherited from Object. |
Equals |
Determines whether the specified object is equal to the current object. Inherited from Object. |
Get |
Serves as the default hash function. Inherited from Object. |
Get |
Gets the Type of the current instance. Inherited from Object. |
Memberwise |
Creates a shallow copy of the current Object. Inherited from Object. |
Reference |
Determines whether the specified Object instances are the same instance. Inherited from Object. |
To |
Returns a string that represents the current object. Inherited from Object. |
See Also