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: [email protected]
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: [email protected]
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
[email protected]
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
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
