Dimension (Object)

Member of:

Dimension collection

Description:

Represents a table dimension in the Report section. A dimension is typically a qualifiable text value, such as a region, and includes date values. It defines the secondary headings or labels that comprise a report. Dimensions ares repeated in each group. Usually, you use items containing text values (for example, Year or item type) for table dimensions. For example, if you select item type as the table dimension, item type is a dimension within each group header. Under the dimension Item Type, the name of each item type (such as CD ROM) appears. A fact is an quantifiable value, such as amount of sales, budget or revenue.

Example 1:

This example shows how to put the City dimension before the State Province :

ActiveDocument.Sections["Report"].Body.Tables["Table"].Dimensions["City"].Move("State Province")

Example 2:

This example shows how to suppress duplicate values in report table columns:

ActiveDocument.Sections["Report"].Body.Tables["Table"].Dimensions["City"].SuppressDuplicates = true
ActiveDocument.Sections["Report"].Body.Tables["Table"].Dimensions["State Province"].SuppressDuplicates = true

Example 3:

This example shows how to make the background color of the City dimension light blue and bold the font:

ActiveDocument.Sections["Report"].Body.Tables["Table"].Dimensions["City"].BackgroundColor = bqLightBlue
ActiveDocument.Sections["Report"].Body.Tables["Table"].Dimensions["City"].Font.Style = bqFontStyleBold

Methods:

Move(LabelNameBefore as String), Remove()

Properties:

BackgroundAlternateColor as BqColorType, BackgroundAlternateFrequency as Number, BackgroundColor as BqColorType, BackgroundShowAlternateColor as Boolean, HorizontalAlignment as BqHorizontalAlignment, Name as String, NumberFormat as String, SuppressDuplicates as Boolean, TextWrap as Boolean, VerticalAlignment as BqVerticalAlignment

Objects:

Font object