Remove (Method)

Applies To:

Association collection, CategoryItems collection, ChartSection object, (CubeQuery)QuerySection object,, Column object, ControlsDropDown object, ControlsListBox object, DataModelSection object, DashboardSection object, Fact collection, Images collection, Join object, Limit object, OLAPQuerySection object, PivotLabels collection, PivotSection object, QueryLabel object, QuerySection object, ReportSection, Requests collection, ResultsSection object, Section object, SortItems collection, TableSection object, TargetFact collection, Topic object. TrendLines collection

Description:

Removes an item from a category. You need not specify a name or index to delete an object.

Syntax:

Expression.Remove(NameOrIndex) or Expression.Remove()

Expression Required:

An expression that returns an object to any of these items:

CategoryItems
ChartSection
Column
ControlsDropDown
ControlsListBox
DataModelSection
DashboardSection
Join
Limit
LocalJoin
LocalResult
OLAPLabel
OLAPMeasure
OLAPQuerySection
OLAPSlicer
PivotLabel
PivotSection
QuerySection
Request
Section
TableSection
Topic

Example 1:

This example shows how to remove the Product ID column from a Results section:

ActiveDocument.Sections["Results"].Columns["Product Id"]. Remove()

Example 2:

This example shows how remove the Pivot section from an Interactive Reporting document file (BQY):

ActiveDocument.Sections["Pivot"].Remove()