OLAPResults (Object)

Member of:

Sections collection

Description:

Represents an OLAP results set in a Table Catalog.

Example:

This example shows how to remove OLAPResults sets. This also removes the parent OLAPQuery and other sections dependent on the OLAPResults set.

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

Methods:

Activate(), Copy(), Duplicate, Export([optional] Filename as String, [optional] FileFormat as BqExportFileFormat, [optional] IncludeHeaders as Boolean, [optional] Prompt as Boolean, ExportToStream([optional] Filename as String, [optional] FileFormat as BqExportFileFormat, IncludeHeaders as Boolean, [optional] DataStreaming as Boolean, [optional] Prompt as Boolean), GetCell( nRow as Number, nCol as Number), PrintOut([optional] FromPage as Number, [optional] ToPage as Number, [optional] Copies as Number, [optional] Filename as String, [optional] Prompt as Boolean), Recalculate{}, Remove{}

Properties:

Read-only: Property Active as Boolean, Property RowCount as Number, Property Type as BqSectionType

Read-write: Property BackgroundAlternateColor as BQColorType, Property BackgroundAlternateFrequency as Number, Property BackgroundColor as BqColorType, BackgroundShowAlternateColor as Boolean, Property BorderColor as BqColorType, Property BorderWidth as Number, Property CSSExport as Boolean, Property ExportWithoutQuotes as Boolean, HTMLExportBreakRowCount as Number, HTMLVerticalPageBreakEnabled as Boolean, Property HTMLVerticalPageBreakUnits as BqHTMLPageBreakUnits, Property Name as String, Property ShowOutliner as Boolean, Property ShowRowNumbers as Boolean, Property Visible as Boolean

Collections:

UserValues as UserValues, Columns As Columns, Limits as Limits, SortItems as SortItems