Crosstab.property DataWindow object property

Description

Settings for a DataWindow object whose presentation style
is Crosstab.

Controls

DataWindows

Syntax

PowerBuilder dot notation:

<span>dw_control</span>.Object.DataWindow.Crosstab.<span>property</span>

1	<span>dw_control</span>.Object.DataWindow.Crosstab.<span>property</span>

Describe and Modify argument:

"DataWindow.Crosstab.<span>property</span> { =<span> value</span> }"

1	"DataWindow.Crosstab.<span>property</span> { =<span> value</span> }"

Parameter	Description
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.

Property for Crosstab	Value
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.

Usage

In the painter

For DataWindow objects with the Crosstab presentation style, set
the values in the Crosstab Definition dialog box. To display the
dialog box, right-click in the Design view to display the pop-up
menu and select Crosstab.

Examples

setting = dw1.Object.DataWindow.Crosstab.Columns

1	setting = dw1.Object.DataWindow.Crosstab.Columns

dw1.Object.DataWindow.Crosstab.Columns = "dept_id"

1	dw1.Object.DataWindow.Crosstab.Columns = "dept_id"

setting = dw1.Describe("DataWindow.Crosstab.Columns")

1	setting = dw1.Describe("DataWindow.Crosstab.Columns")

dw1.Modify("DataWindow.Crosstab.Columns='dept_id'")

1	dw1.Modify("DataWindow.Crosstab.Columns='dept_id'")

dw1.Modify("DataWindow.Crosstab.Rows='salary'")

1	dw1.Modify("DataWindow.Crosstab.Rows='salary'")

dw1.Modify("DataWindow.Crosstab.SourceNames=" &amp;

1	dw1.Modify("DataWindow.Crosstab.SourceNames=" &

&#160;&#160;&#160;+ "'Order Number, Item Number, Price'")

1	+ "'Order Number, Item Number, Price'")

dw1.Modify("DataWindow.Crosstab.Values='empname'")

1	dw1.Modify("DataWindow.Crosstab.Values='empname'")

dw1.Modify("DataWindow.Crosstab.StaticMode='yes'")

1	dw1.Modify("DataWindow.Crosstab.StaticMode='yes'")

See Also

CrosstabDialog function in
the PowerScript Reference
Table.property

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 12.6

and Functions Events Objects and Controls PB Docs 126 PowerBuilder .NET Powerbuilder Documentation Powerbuilder Documentation 12.6 Powerbuilder Documentation Older PowerBuilder Extension Reference PowerBuilder New Features 12.6 PowerDesigner Integration System Object Properties Using the ADO.NET Interface

August 14, 2023

Was this article helpful?

Subscribe

0 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

0

Would love your thoughts, please comment.x

()