View previous topic :: View next topic
|
Author |
Message |
charanmsrit
New User
Joined: 25 Oct 2007 Posts: 81 Location: Australia
|
|
|
|
Hi,
I am using ICETOOL DISPLAY operator for a report. i am not sure how to shrink each column to the size of my data field.
here is my TOOLIN
Code: |
DISPLAY FROM(OUTDD3) LIST(OUTDD5) -
TITLE('XXXXXXXXXXXXXXXXXX') DATE(MD4-) PAGE -
LINES(80) -
HEADER('CUSTOMER','NAME') ON(1,40,CH) -
HEADER('TIE','BREAK') ON(42,5,CH) -
HEADER('ACCOUNT','NUMBER') ON(48,9,CH) -
HEADER('BRANCH','OF ID') ON(58,5,CH) -
HEADER('REL','CODE') ON(64,3,CH) -
HEADER('XXXX','STATUS') ON(68,2,CH) -
HEADER('INT','XXXX','CODE') ON(71,2,CH) -
HEADER('PRINC','XXXX','CODE') ON(74,2,CH) -
HEADER('SUB','PROD','CODE') ON(77,2,CH) -
HEADER('XXXXXX','KEY') ON(80,9,CH) -
COUNT('TOTAL NUMBER OF ACCOUNTS: ') EDCOUNT(U05)
|
my output looks like this
Code: |
1XXXXXXXXXXXXXXXXXX 03-02-2012 - 1 -
CUSTOMER TIE ACCOUNT
NAME BREAK NUMBER
---------------------------------------- -------------------- --------------------
XXXXXXXXXXXXX XXX 00009 000005454
XXXXXXXXXXX XXXXXXX 00003 555554646
|
What changes to DISPLAY operator can give me report like the below? Any help?
Code: |
1XXXXXXXXXXXXXXXXXX 03-02-2012 - 1 -
CUSTOMER TIE ACCOUNT
NAME BREAK NUMBER
---------------------------------------- ----- ---------
XXXXXXXXXXXXX XXX 00009 000005454
XXXXXXXXXXX XXXXXXX 00003 555554646
|
forgive the truncation of report at the right. |
|
Back to top |
|
|
saiprasadh
Active User
Joined: 20 Sep 2006 Posts: 154 Location: US
|
|
|
|
Hi,
Please use below mentioned sort card.
Code: |
DISPLAY FROM(IN) LIST(OUT) -
TITLE('XXXXXXXXXXXXXXXXXX') DATE(MD4-) PAGE BLANK -
LINES(80) -
HEADER('CUSTOMER','NAME') ON(1,40,CH) -
HEADER('TIE','BREAK') ON(42,5,CH) -
HEADER('ACCOUNT','NUMBER') ON(48,9,CH) -
HEADER('BRANCH','OF ID') ON(58,5,CH) -
HEADER('REL','CODE') ON(64,3,CH) -
HEADER('XXXX','STATUS') ON(68,2,CH) -
HEADER('INT','XXXX','CODE') ON(71,2,CH) -
HEADER('PRINC','XXXX','CODE') ON(74,2,CH) -
HEADER('SUB','PROD','CODE') ON(77,2,CH) -
HEADER('XXXXXX','KEY') ON(80,9,CH) -
COUNT('TOTAL NUMBER OF ACCOUNTS: ') EDCOUNT(U05) |
i added BLANK keyword to remove the hyphens. |
|
Back to top |
|
|
charanmsrit
New User
Joined: 25 Oct 2007 Posts: 81 Location: Australia
|
|
|
|
that did what i wanted.. Thanks sai. |
|
Back to top |
|
|
|
|