I have an Active Report that I want to give the user the ability export to Excel, however, I have an across field that when I export, it doesn't export that field's headers. Is there a way to get these headers in the export?

This message has been edited. Last edited by: <Kathryn Henning>,

When I use the code below , my report looks the same whether I use EXL2K, PDF OR AHTML. Try coping my code and replace the table and field names. I know I am using OVER's and that could be the difference.

 

TABLE FILE COMP_DATA
SUM
     WAREHOUSE/D12!D AS 'Warehouse' OVER
     NEWPORT AS 'Newport' OVER
     BEDFORD AS 'Bedford' OVER
     LACONIA AS 'Laconia' OVER
     HOLLIS AS 'Hollis' OVER
     SULLYS AS 'Goffstown' OVER
     WOLFEBORO AS 'Wolfeboro' OVER
	 ALLENSTOWN AS 'Allenstown'
ACROSS CPR_FY NOPRINT
ACROSS CAFMO NOPRINT
ACROSS &BY1.EVAL AS ''

ON TABLE SET BYDISPLAY ON
ON TABLE SET DROPBLNKLINE ON
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

    INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENBlue_Medium1.sty,
$
TYPE=SUBHEAD,
JUSTIFY = CENTER,
$
ENDSTYLE
END