CrossTab DataWindow

Controls in CrossTab DataWindow

Supported

Button

Text

Picture

GroupBox

Line

Oval

Rectangle

RoundRectangle

Computed Field

Graph

GroupBox is visible before inputting any data and is invisible after inputting data.

Unsupported

Column

Report

TableBlob

 

DataWindow object properties for CrossTab presentation style

Supported

Crosstab.SourceNames(r/w)

Crosstab.Rows(r)

Crosstab.Columns(r)

Crosstab.Values(r)

Crosstab.StaticMode (r)

Table.CrosstabData (r)

Properties marked with "(r)" can be read - but not changed - in script. Properties marked with "(r/w)" can be read or changed in script.

It is supported to use expressions like sum (units for crosstab) only in CrossTab.Values. It is unsupported to use such expressions in other properties that can contain expressions.

Unsupported

Help.TypeID.SetCrosstab

DataWindow control methods for CrossTab DataWindow

Supported

GetMessageText

Unsupported

CrosstabDialog

DataWindow expression functions for CrossTab DataWindow

Supported

CrosstabAvg

CrosstabCount

CorsstabMax

CrosstabMin

CrosstabSum

 

Performance differences between PowerBuilder and Web

Differences

Adding columns in CrossTab DataWindow is unsupported. If you add a column in CrossTab DataWindow by "copy" and "paste" in PowerBuilder, the new column will not display on the Web.

When the footer band of a Crosstab DataWindow is higher than the DataWindow, detail band displays in PowerBuilder while footer band displays on the Web.

If the argument of SetFilter() is NULL, in the Specify Filter dialog it displays the columns in detail band in PowerBuilder. On the Web, it displays the columns in detail band as well as the dynamically generated columns.

After dynamically modifying Expression property of a computed field control in CrossTab DataWindow, data will be recalculated according to the new expression on the Web. In PowerBuilder, the data will not be recalculated.

When dynamically modifying the properties that affect position, it automatically refreshes the interface on the Web but it does not in PowerBuilder.

After retrieving data in CrossTab DataWindow, the position of controls (excluding Text control, Column control and Computed Filed control) will be rearranged on the Web. This is different from in that in PowerBuilder.

Unsupported features

Unsupported

SlideLeft property is unsupported in CrossTab DataWindow.

For graph control in CrossTab DataWindow, Values cannot contain aggregate functions.

For a CrossTab nested report with arguments, retrieval arguments are unsupported.