Crosstab.property – PB Docs 2022

property

A property for a Crosstab DataWindow. Properties
and their settings are listed in the table below.

value

A string expression listing the items to be
assigned to the property. For Crosstab properties, value is
always quoted and can be a DataWindow expression.

Columns

(exp) A string containing a comma- or tab-separated
list of the names of columns that make up the columns of the
crosstab. These are the columns that display across the top of
the crosstab.

Painter: Columns
option.

Rows

(exp) A string containing a comma- or tab-separated
list of the names of columns that make up the rows of the
crosstab.

Painter: Rows option.

SourceNames

(exp) A string containing a comma-separated list of
column names to be displayed in the Crosstab Definition dialog
box. The default names are the column names from the
database.

Painter: Source Data
option.

StaticMode

A string indicating whether a dynamic crosstab
should be put into a static mode. The dynamic crosstab remains
in static mode until you set StaticMode to No. While the dynamic
crosstab is in static mode, you can manipulate the properties of
individual columns.

Values are:

Yes —
StaticMode is enabled

No — (Default) StaticMode is
disabled

Painter: Not set in painter.

Values

(exp) A string containing a comma- or tab-separated
list of expressions that will be used to calculate the values of
the crosstab.

Painter: Values option.