How to sort crosstab columns? And crosstab bug in 6.5

Is it posibble to specify sort order of crosstab columns? PowerBuilder's
default order is ascending sort by first column of crosstab column
definition.

Our crosstab column header should consist of two columns: Description and
Code (eg. Salary, A1). We want to sort by second one. But PB sorts itself,
by first one.
Our solution was: In PB 6.0 we duplicate Code column, make it first column
in definition and hide it in Design Painter.

It worked. But in PB 6.5, when I try to add third column to crosstab column
definition, PB crashes in Preview.

Any help? Thanks in advance

Witek Juda, wjuda@elbacsb.com.pl,
ELBA CSB SA, Wroclaw, Poland

0 Witek 1/12/1999 8:47:55 AM

Hi, Witek

To sort columns in a datawindow (even if it is a crosstab dw), use the
SetSort() Powerscript function. Consult PowerBuilder Help for more
information about SetSort
Common sintax example:
dw_1.SetSort(Column1 A,Column2 D)

Regards
Marcelo Benedeti Palermo
(TSE Team - Sybse Brazil)

Witek Juda wrote in message ...
>Is it posibble to specify sort order of crosstab columns? PowerBuilder's
>default order is ascending sort by first column of crosstab column
>definition.
>
>Our crosstab column header should consist of two columns: Description and
>Code (eg. Salary, A1). We want to sort by second one. But PB sorts itself,
>by first one.
>Our solution was: In PB 6.0 we duplicate Code column, make it first column
>in definition and hide it in Design Painter.
>
>It worked. But in PB 6.5, when I try to add third column to crosstab column
>definition, PB crashes in Preview.
>
>Any help? Thanks in advance
>
>Witek Juda, wjuda@elbacsb.com.pl,
>ELBA CSB SA, Wroclaw, Poland
>
>
>
>

0 Marcelo 2/2/1999 6:25:37 PM

Marcelo,

Did you try it yourself? I mean, actually take a CROSSTAB datawindow and
write a sorting string which will sort dynamically generated columns?
if yes, then the question is - how did you find out these columns names?

Igor

Marcelo Benedeti Palermo  wrote in message
news:cElZzktT#GA.207@forums.powersoft.com...
>Hi, Witek
>
>To sort columns in a datawindow (even if it is a crosstab dw), use the
>SetSort() Powerscript function. Consult PowerBuilder Help for more
>information about SetSort
>Common sintax example:
>dw_1.SetSort(Column1 A,Column2 D)
>
>Regards
>Marcelo Benedeti Palermo
>(TSE Team - Sybse Brazil)
>
>Witek Juda wrote in message ...
>>Is it posibble to specify sort order of crosstab columns? PowerBuilder's
>>default order is ascending sort by first column of crosstab column
>>definition.
>>
>>Our crosstab column header should consist of two columns: Description and
>>Code (eg. Salary, A1). We want to sort by second one. But PB sorts itself,
>>by first one.
>>Our solution was: In PB 6.0 we duplicate Code column, make it first column
>>in definition and hide it in Design Painter.
>>
>>It worked. But in PB 6.5, when I try to add third column to crosstab
column
>>definition, PB crashes in Preview.
>>
>>Any help? Thanks in advance
>>
>>Witek Juda, wjuda@elbacsb.com.pl,
>>ELBA CSB SA, Wroclaw, Poland
>>
>>
>>
>>
>
>

0 Igor 2/8/1999 6:34:33 PM