I don't think you can get it to do that, its best used if you just want to show a single field, but you could use an intelligent DICT item that concatenates the 2 fields you require together, but I think you would always have a problem with showing a suitable heading.
Trevor. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Edward Brown Sent: 16 July 2008 14:36 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Multiple columns from a LIST statement? Oh, okay - that's a useful command. Not come across it before. So I can get it to give this output: 018682056 005014039 012250048 003406038 0.00 0.00 0.00 0.00 01305401X 035639170 053181010 017074056 0.00 0.00 0.00 0.00 021898062 025114066 015466055 023506065 -3399.11 147.14 0.00 914.78 The 9 digit number being the record ID, then an amount underneath. Is it possible to get a more traditional report? More like this: ACCOUNTS BALANCE... ACCOUNTS BALANCE... 018682056 0.00 025114066 147.14 005014039 0.00 015466055 0.00 012250048 0.00 023506065 914.78 003406038 0.00 029207163 387.64 01305401X 0.00 016270057 0.00 035639170 0.00 01064201X 0.00 053181010 0.00 000190038 862.68 017074056 0.00 014662056 151.32 021898062 -3399.11 036370084 1067.44 005818046 -102.08 01627002X 0.00 Thanks Edward -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Trevor Fulton Sent: 16 July 2008 13:40 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Multiple columns from a LIST statement? Try using LIST-LABEL Trevor. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Edward Brown Sent: 16 July 2008 12:35 To: u2-users@listserver.u2ug.org Subject: [U2] Multiple columns from a LIST statement? Hello, This is a unidata (7.1) reporting question, and I'm asking because although I can't find the answer in the documentation, I do think I've seen it once on another developer's screen. Suppose I list a file with a command like LIST ACCOUNTS. I'd get a list of the IDs down the left hand side of the page but a lot of wasted space elsewhere - and a maximum of 22 / 60ish records per screen / A4 page. So what I'm wondering is if there's a way to have the report make use of multiple columns, using the horizontal space available before jumping to the next page? Thanks Edward ------------------------------------------------------------------------ ----- -------------- 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -------------------------------------------------------- Epicor Software (UK) is a limited company registered in England & Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -------------------------------------------------------- Epicor Software (UK) is a limited company registered in England & Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
