RE: [U2] Multiple columns from a LIST statement?

2008-07-17 Thread Edward Brown
ehalf 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 headi

RE: [U2] Multiple columns from a LIST statement?

2008-07-16 Thread Keith Johnson (DSLWN)
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

RE: [U2] Multiple columns from a LIST statement?

2008-07-16 Thread Trevor Fulton
ginal 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

Re: [U2] Multiple columns from a LIST statement?

2008-07-16 Thread Don Robinson
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-

Re: [U2] Multiple columns from a LIST statement?

2008-07-16 Thread rogu2
Does Unidata have a SORT.LABEL/LIST.LABEL command? Duplicates how you'd want a label to print, but does support such multiple columns. 01 LIST.LABEL CUST NAME ADDR1 ADDR2 CSZ COUNT, ROWS, SKIP, INDENT, SIZE, SPACE {,C} ?2,5,1,10,25,1 Row 1 header?CUSTNO Row 2 header?NAME Row 3 header?ADDR1 Row

RE: [U2] Multiple columns from a LIST statement?

2008-07-16 Thread Edward Brown
dward -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: [

Re: [U2] Multiple columns from a LIST statement?

2008-07-16 Thread Richard Sammartino
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.

RE: [U2] Multiple columns from a LIST statement?

2008-07-16 Thread Trevor Fulton
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,