Anyone know how to align subhead with across column?

October 05, 2006, 01:52 PM

Output is PDF. I don't like the choppy style that the across command gives you so I've included a subheading to create static column title in place of the across column being visible. I just can't get the data and subhead to align. The report is for quarters and will only return one row when using across. Here's my code...

  TABLE FILE VW_10CSR
SUM 
     TOTAL AS ''
BY GROUPID NOPRINT
SUM 
     SAVINGS AS ''
BY GROUPID NOPRINT
ACROSS defQuarter NOPRINT AS ''
     
ON GROUPID SUBHEAD
"Interventions<+0>Q1<+0>Q2<+0>Q3<+0>Q4<+0>Total"
ON TABLE SET PAGE-NUM OFF 
ON TABLE SET BYDISPLAY ON 
ON TABLE ROW-TOTAL AS 'TOTAL'
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=8,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
ENDSTYLE
END

October 05, 2006, 02:00 PM

Jim_at_LM

WIth PDF being postscript, try using a positional marker, say: <42 Start in position 42. It's not exactly at 42, but adjust as needed to keep up witht true font scaling. There may be a better way - we just haven't had the time to resarch it. Jim

October 05, 2006, 02:02 PM

Prarie

TRY
TYPE=SUBHEAD,ITEM=3,POSTITION=TOTAL,$

OR

TRY Playing with ACROSSCOLUMN

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

October 05, 2006, 03:58 PM

tryFOCUSing

Does anyone know the syntax to set the width of the across column?

Thanks!

WebFOCUS 7.1.4
WIN XP/SP2

October 05, 2006, 04:22 PM

Prarie

I know this works on Column...but you can try on acrosscolumn

SQUEEZE=2 or whatever number.

In Focus since 1993. WebFOCUS 7.7.03 Win 2003