Keith, Thank you - this is a very clever solution. Admittedly not as straightforward as it could be - wouldn't it be nice if there was a built in keyword such as ENABLE-COLS that did it automatically!
Edward -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Johnson (DSLWN) Sent: 16 July 2008 22:25 To: [email protected] Subject: RE: [U2] Multiple columns from a LIST statement? 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/ ------------------------------------------------------------------------------------------- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? ------------------------------------------------------------------------------------------- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney, London, SW15 6AR. ------------------------------------------------------------------------------------------- ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
