Using the N-Up style
The N-Up style presents two or more rows of data next to each
other. It is similar to the Label style in that you can have information
from several rows in the database across the page. However, the
information is not meant to be printed on labels. The N-Up presentation
style is useful if you have periodic data; you can set it up so
that each period repeats in a row.
After you select a data source, you are asked how many rows
to display across the page.
For each column in the data source, PowerBuilder defines n columns
in the DataWindow object (column_1 to column_n),
where n is the number of rows you specified.
Table example
For a table of daily stock prices, you can define the DataWindow object as
five across, so each row in the DataWindow object displays five days’ prices (Monday
through Friday). Suppose you have a table with two columns, day and price,
that record the closing stock price each day for three weeks.
In the following n-up DataWindow object, 5 was selected as the number
of rows to display across the page, so each line in the DataWindow object shows five
days’ stock prices. A computed field was added to get the
average closing price in the week:
About computed fields in n-up DataWindow objects
You use subscripts, such as price[0], to
refer to particular rows in the detail band in n-up DataWindow objects.
For more information, see Chapter 19, “Enhancing DataWindow Objects .”
Here is the DataWindow object in the Preview view:
Another way to get multiple-column DataWindow objects
In an n–up DataWindow object, the data is displayed across
and then down. If you want your data to go down the page and then
across in multiple columns, as in a phone list, you should create
a standard tabular DataWindow object, then specify newspaper columns.
For more information on newspaper columns,
see Chapter 19, “Enhancing DataWindow Objects .”