Subfile Grid Display Top to Bottom then Left to Right

[llwood]

Developing a 4 column 5 row grid that contains a serial number, hyperlink, and checkbox within each box on the grid. This structure shows a max of 20 serial numbers on the screen at once. I have attached a screenshot.

Is it possible to display this subfile grid so it displays in order from top to bottom and then left to right? The first five serial numbers would be in column 1 and the next 5 would be in column 2, etc.

We have talked about doing all the element manipulation in the RPG program so that each subfile record would be loaded left to right but that when displayed would appear to have loaded top to bottom. For example, loading serial number 1, 6, 11 and 16 into subfile record one, 2, 7, 12, and 17 into subfile record 2, etc. This seems very convoluted and trying to find a better way.

In looking at the properties, I see an option on cursor progression that allows left to right or top to bottom, so I am hoping that there is a property that can be used to display the grid in a top to bottom approach as well. Any suggestions or ideas on how I can achieve this result?

[DanD]

Instead of having 4 subfiles, perhaps you can have 1 subfile with 4 fields, as you have demonstrated, and load the data into an array (or DS) in your RPG program (assuming that you are using RPG & not DB-driven).

Assuming you have 21 serial numbers, divide 21 / 4 to get total number of rows (6) Then have an algorithm that will populate in a similar fashion to

1, 7, 12, 17
2, 8, 13, 18
3, 9, 14, 19
4, 10, 15, 20
5, 11, 16, 21
6

Hope this helps