As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
I have read Mickey's Tips and Techniques on this and I have seen posts on how to do this, but I have an example of what is going on and I am wondering if I am making this more difficult than it should be.
The below example is what I have. I need the CAR2 (across value that is now acting as a column title) to be wrapped. Right now it is not wrapping. Do I need to count the characters and then create an additional acrossvalue as I saw in Jack Gross's post under Tips and Techniques?
As you can see, the first column can be fairly small ... is there a way to dynamically size so that they are all not one width or when I do this will it have to be set?
Any help would be great! Thank you.
DEFINE FILE CAR CAR2/A51 = IF CAR EQ 'JENSEN' THEN CAR || 'THIS IS A TEST TO SHOW A LONG VALUE' ELSE CAR; END
TABLE FILE CAR SUM BODYTYPE AS '' BY SEATS NOPRINT ACROSS COUNTRY AS '' ACROSS CAR2 AS '' WHERE COUNTRY EQ 'ENGLAND'; ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, ORIENTATION=LANDSCAPE, $ TYPE=ACROSSVALUE, ACROSS=1, COLUMN=P1,GRID=OFF, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, JUSTIFY=CENTER, $ TYPE=ACROSSVALUE, ACROSS=1, COLUMN=P2,GRID=OFF, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, JUSTIFY=CENTER, $ TYPE=ACROSSVALUE, ACROSS=1, COLUMN=P3,GRID=OFF, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-RIGHT=LIGHT, JUSTIFY=CENTER, $ TYPE=ACROSSVALUE, ACROSS=2,GRID=OFF, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, JUSTIFY=CENTER, $ TYPE=DATA, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, $ TYPE=TITLE,GRID=ON,$ TYPE=DATA,GRID=ON,$ ENDSTYLE ENDThis message has been edited. Last edited by: Kerry,
Dev, SIT, UAT, Production:7.6.6 Dev Sandbox:7.6.11
I have a long long way to go with what I need, but I am slowly manually manipulating it. I'd rather have the columns be dynamically widened or wrapped based on the value so that say:
AUDI needs only say 0.5 of a wrap but 'JENSEN THIS IS A LONG VALUE' get's 0.8 so that it only wraps to once (maybe twice if needed).
I at least have everything fitting on one page... my code below
TABLE FILE CAR SUM CNT.DST.CAR ON TABLE HOLD AS CARCNT FORMAT ALPHA END -RUN
-READ CARCNT &CARCNT.A5. -SET &CARCNT = &CARCNT; TYPE &CARCNT -SET &ECHO='ALL'; DEFINE FILE CAR CAR2/A52 = IF CAR EQ 'JENSEN' THEN CAR || ' THIS IS A LONG VALUE' ELSE CAR; CARCNT/I5 = &CARCNT; COLWDTH/D12.2 = IF &CARCNT GT 4 THEN (&CARCNT/13); TKNSZE/I4 = COLWDTH*10; ATKN/A4 = EDIT(TKNSZE, '$$99'); ATKNSZE/A5 = 'A'||ATKN; END
TABLE FILE CAR PRINT ATKNSZE COLWDTH TKNSZE CAR2 CARCNT ATKN COUNTRY BODYTYPE SEATS ON TABLE HOLD AS H1 FORMAT ALPHA END -RUN
Per our technicals: this should be added as a new feature (wrap available for across fields in PDF) in 7.6.11 & 7.70. To confirm and/or for further assistance, you may want to open a case with Customer Support Services. You may either call at 1-800-736-6130, or access online at InfoResponse.
Kerry Zhan Focal Point Moderator Information Builders, Inc.
Posts: 1948 | Location: New York | Registered: November 16, 2004