How to group rows vertically in PowerBuilder?

Question

I have this sample rows of plate nos with bay nos:

Plate no | Bay no
------------------
AAA111   |   1
AAA222   |   1
AAA333   |   2
BBB111   |   3
BBB222   |   3
CCC111   |   1

Is there a way to make it look like this in a datawindow in powerbuilder?

  1    |   2    |   3
------------------------
AAA111 | AAA333 | BBB111
AAA222            BBB222
CCC111

@Strawberry To make my list look more uniformed. – fanboime12 Aug 14 '17 at 06:24 — fanboime12, Aug 14 '17 at 06:24
@Strawberry forgot to mention something. Edited post. – fanboime12 Aug 14 '17 at 06:30 — fanboime12, Aug 14 '17 at 06:30

score 1 · Answer 1 · answered Aug 15 '17 at 23:25

There isn't an simple answer, especially if you need cells to be update-able.

Variable Column Count Strategy

If the number of columns across the top is unknown at development time than you might get by with a "Crosstab" style datawindow but it would be a display only. If you need updates you'll need to do manual data manipulations & updates as each cell would probably represent one row.

Fixed Column Count Strategy

If the number of columns is known (fixed) you could flatten the data at the database and use a standard tabular (or grid) datawindow control but you'll still need to get creative if updates are needed.

score 1 · Answer 2 · answered Aug 16 '17 at 10:35

1

If you use Oracle to obtain the data you can use the Pivot and Unpivot function to perform what you are looking for. Here is an example of how to do it:

http://www.oracle.com/technetwork/es/articles/sql/caracteristicas-database11g-2108415-esa.html

answered Aug 16 '17 at 10:35

Eduardo G.

341
1
7

How to group rows vertically in PowerBuilder?

2 Answers2