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