Using LIST.LABEL (on a Universe system) EVAL can create a dummy column
mergeing
two columns and you can replicate column headings using the page heading
as below.
LIST.LABEL TRANSACTION EVAL
"FMT(@ID,'L#15'):FMT(OCONV(TRAN.AMOUNT,'MD2$,'),'R#15')" ID-SUPP
HEADING "ID Amount ID
Amount"
Answer the prompt like this,
COUNT, ROWS, SKIP, INDENT, SIZE, SPACE {,C} ?2,1,0,0,30,2
and here is the output
ID Amount ID Amount
183046|11645|19 $2.49 28282|14248|147 $-0.34
99305|12650|116 $201.58 16308|13753|169 $84.77
11495|14099|141 $-23.14 2143|13275|16 $162.17
21782|14617|506 $164.09 21782|14617|749 $213.35
33661|12995|103 $23.21 92635|13095|635 $2.49
Note that TRAN.AMOUNT already had an output conversion, but I had to put
one inside the EVAL statement.
Regards, Keith
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
