I have the following code which will provide 3 columns after the ACROSS columns. I can get the data to alternate colors in my styling but I cannot do anything with the Titles or column headings. The problem I think is that they actually appear on the same line as the ACROSS data. Any Sugestions

Sorry forgot to post the code:


DEFINE FILE VW_RPT_AIR_RAW_DATA
ENDDTR/MDYY ='&ENDDTMDYY.EVAL';
ENDDT/YYMD=ENDDTR;
STRTDT/YYMD= DATEADD(ENDDT,'M',-12);
RDATE/tMYY=RESULT_DATE;
TDATE/YYMD=RESULT_DATE;
END
TABLE FILE VW_RPT_AIR_RAW_DATA
SUM
RESULT/D12.2 AS ''
BY UNIT_NAME AS 'Proc Unit Ident'
BY PARAM_NAME AS 'Param Name'
BY RESULT_UNIT AS 'Unit'
ACROSS RDATE AS ''
COMPUTE
AVERAGE/D12.2 = ( C1 + C2 + C3 + C4 + C5 + C6 + C7 + C8 + C9 + C10 + C11 + C12 ) / 12;
AS 'Average'
COMPUTE
MINI/D12.2 = MIN(C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11, C12);
AS 'Minimum'
COMPUTE
MAXI/D12.2 = MAX(C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11, C12);
AS 'Maximum'
HEADING
"eCAT PI Raw Data Report"
"Site: "End Date: &ENDDT"
" "
WHERE SITE EQ '&SITE';
WHERE ( TDATE GT STRTDT ) AND ( TDATE LE ENDDT );

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

Duane,

Please post your code (and preferably within

[code]

[/code]

tags).

Cheers,

Try something like this.

TYPE=ACROSSTITLE,
ACROSS=1,
BACKCOLOR='SILVER',