I'm trying to wrap a column title in a compute that comes after a crosstab. I've searched the forums and documentation and didn't find anything:

 
TABLE FILE CAR
SUM 
     CNT.CAR AS 'COUNT,CAR'
BY CAR NOPRINT
BY SPACER AS 'BODY TYPE'
ACROSS BODYTYPE
COMPUTE TEST/A1 = 'X'; AS 'MY WIDE, COLUMN TITLE'
ON CAR SUBHEAD
"<CAR"
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=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
TYPE=DATA,
	COLUMN=TEST, COLOR='WHITE', BACKCOLOR=RGB(100 0 0),
$
TYPE=REPORT,
	COLUMN=TEST, SQUEEZE=0.5,
$
ENDSTYLE
END
 

Doesn't seem to work...neither does the ',' in the title. Also, can you wrap column titles in PDF?

Thanks.

This message has been edited. Last edited by: Kerry,

Look here and find Mickey's article on PDF and HTML styling. Lot's of good tips.

Excellent. Thanks I'll check it out.

Mark,

You cannot wrap a TITLE for a COMPUTE which appears after an ACROSS.

The reason why is complicated but basically the TITLE for the COMPUTES after an ACROSS are treated like data values, not TITLEs. Therefore adding commas to the AS 'Whatever' for the COMPUTEs will not make it wrap.

Yeah, I noticed that recently when I BOLDed my ACROSSVALUES and those COMPUTE titles were also bolded. I wonder if I'm able to wrap across values, and if so, would it wrap those titles? I'll soon find out. Thanks Mickey.

Mac, did you ever solve this problem?
i'm struggling with the same thing.
I just want to WRAP my column titles.
i've memorized Mickey's articles, but there's nothing there about titles,
It just doesn't seem to work.
i still get the !
ah..heres the answer
http://techsupport.information...om/sps/20092010.html
now i'm going to try to get it to work on ACROSSVALUEs

I have never managed to wrap an across value.

This definitely does not work, you can wrap and acrosscolumn, but not an acrossvalue:

TABLE FILE CENTORD
SUM PRODCAT
ACROSS PRODNAME AS ''
ON TABLE SET STYLESHEET *
TYPE=REPORT, FONT='ARIAL', SIZE=9, ORIENTATION=LANDSCAPE, SQUEEZE=ON, LEFTGAP=0.1, RIGHTGAP=0.1, $

TYPE=ACROSSVALUE, COLOR=BLUE, WRAP=0.5, $

TYPE=REPORT, ACROSSCOLUMN=PRODCAT, COLOR=GREEN, WRAP=0.5, $

ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
END

Mickey has a workaround:

[SOLVED] wrap in a stylesheet

Quoting N.Selph in Wrap an Across Column, "It is a documented limitation at least in version 5.21 for PDF. I don't know if it was fixed in a later release"

- it ain't working in v7.6.5.

Lots of feedback to be found on wrapping ACROSSVALUES. I was wondering if anyone had any feedback on Susannah's post, wrapping PDF column titles. I know about the comma trick per the post she references, but didn't know if there was something a bit more dynamic.

I'm considering writing a function to insert the comma. Anyone already have that or is it a simpler solution than that?

- ABT

quote:

Originally posted by susannah:
Mac, did you ever solve this problem?
i'm struggling with the same thing.
I just want to WRAP my column titles.
i've memorized Mickey's articles, but there's nothing there about titles,
It just doesn't seem to work.
i still get the !
ah..heres the answer
http://techsupport.information...om/sps/20092010.html
now i'm going to try to get it to work on ACROSSVALUEs

Reclosing this. I discovered that IBI provides the PARAG function which gets me 99.5% there (just have to trim out some trailing whitespace to avoid extra breaks).

- ABT

NUMTEXT/A100 = PARAG(100, NUMTEXT_1, ',', 40, NUMTEXT);
DEMTEXT/A100 = PARAG(100, DEMTEXT_1, ',', 40, DEMTEXT);

sweet

As it turns out, jgross had an article (http://www.informationbuilders.com/support/developers/WrapACROSS) that got me the other .5% there (by implicating the GETTOK/concatenate option). Here's what I settled on:

DEFINE FILE VW_INDICATORMETRICVALUES_NUMDEM
	NUMTEXT_1/A100 = TRIM('T', NUM_TEXT, 100, ' ', 1, 'A100');
	DEMTEXT_1/A100 = TRIM('T', DEM_TEXT, 100, ' ', 1, 'A100');

    LGA40/A100 = PARAG(100,NUMTEXT_1,'\',40,'A100');
    LINE1/A40  = GETTOK(LGA40,100, 1, '\',40,'A40');
    LINE2/A40  = GETTOK(LGA40,100, 2, '\',40,'A40');

	NUMTEXT_OUT/A101V = LINE1 |',' | LINE2;

    LGA40/A100 = PARAG(100,DEMTEXT_1,'\',40,'A100');
    LINE1/A40  = GETTOK(LGA40,100, 1, '\',40,'A40');
    LINE2/A40  = GETTOK(LGA40,100, 2, '\',40,'A40');

	DEMTEXT_OUT/A101V = LINE1 |',' | LINE2;

END

TABLE FILE VW_INDICATORMETRICVALUES_NUMDEM
SUM
	MAX.NUMTEXT_OUT AS 'NUMTEXT'
	MAX.DEMTEXT_OUT AS 'DEMTEXT'

WHERE OrgUnitShortName EQ '&UNIT';
WHERE OrgEntityNo EQ '&ORG';
WHERE IndicatorName EQ '&IND';
WHERE Year EQ &FY;

ON TABLE HOLD AS BT_NUMDEM_NAMES FORMAT ALPHA
END


-RUN
-READ BT_NUMDEM_NAMES &NUMTEXT.A101V. &DEMTEXT.A101V.
-RUN


-SET &NUMTEXT = EDIT(&NUMTEXT, '$$$$$$9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999');
-SET &DEMTEXT = EDIT(&DEMTEXT, '$$$$$$9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999');

I'll be the first to say this could be done better, but it's good enough for the time being. I'd really like to see it calculate the halfway point of the text in the field and set that value in PARAG (so that the values look roughly equal). Too much to do to mess around with that for now...

- ABT

well, you could use the ARGLEN function to measure how long the text field's content actually is.
and divide by 2
'course you might be cutting a word in half.
but you could take the ARGLEN/2 minus, say, 10
and then check for the next blank using the POSIT function, starting with ARGLEN-10...