RE: [U2] Multiple columns from a LIST statement?
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: u2-users@listserver.u2ug.org
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
u2-users@listserver.u2ug.org
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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
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/
Re: [U2] Multiple columns from a LIST statement?
You didn't say if you are on windows or unix but I addressed this issue using the split and paste commands from unix and sending the output to _HOLD_. The report was just a list of id numbers. Below is a sample. You may have to wrestle with lists that are more than 1 segment. I hope this helps. EXECUTE 'SSELECT FILENAME WITH @ID LIKE WHATEVER EXECUTE 'SAVE.LIST LISTNAME' [EMAIL PROTECTED] VAR=INT(VAR/4) + 1 PCPERFORM 'split -':VAR:' ./SAVEDLISTS/LISTNAME000 PCPERFORM 'paste DCaa DCab DCac DCad ./_HOLD_/DC.TXT' Rich Richard Sammartino Systems Analyst School District of Philadelphia 440 N Broad Street Philadelphia, PA 19130 Phone (215) 400-5086 Fax (215) 400-4411 - Original Message - From: Edward Brown [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 16, 2008 7:34:32 AM GMT -05:00 US/Canada Eastern 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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: 018682056005014039012250048003406038 0.00 0.00 0.00 0.00 01305401X035639170053181010017074056 0.00 0.00 0.00 0.00 021898062025114066015466055023506065 -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: ACCOUNTSBALANCE... ACCOUNTSBALANCE... 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
Re: [U2] Multiple columns from a LIST statement?
Edward,
Take a look at the LIST-LABEL command.
I don't have an Unidata system
handy so I did this in jBASE.
jsh ~ --LIST-LABEL MD
Cols,Rows,Skip,Indent,Size,Spaces{,C} :4,1,0,0,15,2
PAGE
110:10:02 16 JUL 2008
ENTER.FLDSPLYWIN.FTTOASC BLOCK-TERM NSELECT
LOADT
AUX.PGM SELECT-INDEX PIX.GUI.FORM.F
TERM
ECOPYPIX.GUI.CONTROL F/REALLOC
L/UPDENTER.VAL
WIN.DDE MEMO.ENTRY
WIN.TWUSESET-STACKCUSTOM.OPTIONS
WO.OPTIONS
CREATE-FILE S/AMCLFQ*0LOGOFF
.
.
.
The
LIST-LABEL command allows sorting, selecting, etc.
Good luck,
Don Robinson
Ashwood Computer Co.
513-563-2800
- Original Message
From: Edward
Brown [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday,
July 16, 2008 7:34:32 AM
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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
