Hello,
I have searched the forum and it doesn't look like this is possible, but I'll ask anyway. My output is in PDF. My code looks like this:

TABLE FILE RAWDATA
SUM NUM_PATS AS '' ACROSS SEX AS '' ACROSS RACE AS ''
BY CATEGORY AS ''
BY RELIGION AS ''
ON CATEGORY PAGE-BREAK
ON TABLE PCHOLD FORMAT PDF
ON TABLE SUBHEAD

And my output is almost right, but the across columns at the top look like this:

----------------------------------------------
FEMALE MALE
----------------------------------------------
WHITE BLACK HISPANIC WHITE BLACK HISPANIC
----------------------------------------------
Then the table data here

What I really need is the FEMALE and MALE column "headings" centered across those columns. I have tried everything that I can think of. Any thoughts?

You need to add some styling

ON TABLE SET STYLE *
TYPE=ACROSSVALUE, ACROSS=1,
JUSTIFY=CENTER,
$

Well it works for html, pdf isn't is it.

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

mark
have you read the articles written by developers? they're getting increasingly hard to find, but they're now under 'Tips & Techniques' instead of 'Focus on Developers' on the Focal Point home page
There are a pair of articles by Mickey Grackin on PDF. Mickey is really really good at pdf..
have a read and see if you can get the help you need.

Thanks Susannah. I will check those out.

Mark,

Sorry for the delayed response. The "WebFOCUS HTML and PDF Report Design - Part II" article explains the techniques used in the code below.

I was not able to find a way to CENTER an ACROSSVALUE over the columns it contains. Ironically, JUSTIFY=RIGHT caused the ACROSSVALUE to appear over the last column on the right as opposed to the default of being over the first column on the left. However, JUSTIFY=CENTER did not put the ACROSSVALUE over the center column. This makes sense because you could have only two columns and therefore technically there is no CENTER column.

In order to get text CENTERed over the columns, I created a HEADING with the ACROSSVALUEs in it and then, using the technique explained in the "Part II" article, I CENTERed the values over the columns.

TABLE FILE CAR
HEADING
"CAR/MODEL<+0>ENGLAND<+0>W GERMANY"
SUM SALES
ACROSS COUNTRY NOPRINT
ACROSS SEATS AS '' COLUMNS 2 AND 4 AND 5
BY CAR
BY MODEL
WHERE COUNTRY EQ 'ENGLAND' OR 'W GERMANY'
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE,$
TYPE=REPORT, COLUMN=CAR, WRAP=1.00,$
TYPE=REPORT, COLUMN=MODEL, WRAP=1.00,$
TYPE=REPORT, ACROSSCOLUMN=SALES, WRAP=1.00, JUSTIFY=RIGHT,$
TYPE=ACROSSVALUE, ACROSS=SEATS, JUSTIFY=RIGHT,$
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1, WIDTH=2.30, JUSTIFY=CENTER,$
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=2, WIDTH=3.60, JUSTIFY=CENTER,$
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=3, WIDTH=3.50, JUSTIFY=CENTER,$
ENDSTYLE
END