RemoveAll (Method)

Applies To:

AggregateLimits collection, Association collection, AxisLabels collection, CategoryItems collection, ColorRanges collection, Columns collection, ControlsDropDown object, ControlsListBox object, ColorRanges collection, Fact collection, Images collection, Joins collection, Limits collection, LimitValues collection, Parentheses collection, PivotLabelsTotals collection, QueryLabel object, Requests collection, TargetFact collection, Topics collection, TopLabels collection, TrendLines collection

Description:

Removes all the items from a collection.

Note:

In a CubeQuery section, the RemoveAll method removes all member selectors from the label. This method should not be used as an the argument to MemberSelectors.RemoveAll() in an Interactive Reporting document file. It is only meant to be used forInteractive Reporting document files run as jobs.

Syntax:

Expression.RemoveAll()

Expression Required:

An expression that returns a collection for any of these items:

Example:

This example shows how to remove every column from a Results or Table section:

ActiveDocument.Sections["Results"].Columns.RemoveAll()