June 24, 2008, 07:16 AM
PrasadbollamCompound Reports in EXL2K format
As suggested in FP forum replies, I used EXL2K OPEN and EXL2K CLOSE for compound reports, when I execute the FEX ,the compound report is not opening in EXCEL 2000/2003
I have tried below source, Please suggest if any changes.
Thanks in advance
SET PAGE-NUM=OFF
-RUN
SET COMPOUND=OPEN
-RUN
TABLE FILE CAR
SUM SALES
BY COUNTRY
HEADING
"Sales Report"
" "
ON TABLE SUBHEAD
"HEADER_IMG"
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Sales', $
TYPE=HEADING, STYLE=BOLD, COLOR=BLUE, $
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN
SET COMPOUND=CLOSE
-RUN
TABLE FILE CAR
SUM DC
BY COUNTRY
HEADING
"Cost of Goods Sold Report"
" "
ON TABLE SUBHEAD
"HEADER_IMG"
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Cost', $
TYPE=HEADING, STYLE=BOLD, COLOR=BLUE, $
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END
Thanks,
Prasad Bollam
June 24, 2008, 07:36 AM
Danny-SRLPrasad,
I ran you example and it works quite well. I have Excel 2007.
I get 2 separate worksheets.
If you add NOBREAK after the ON TABLE PCHOLD of the first TABLE, you get both outputs in the same worksheet.
June 24, 2008, 07:36 AM
<Naak>HI Prasadbollam,
PLEASE CHECK THIS CODE. CHANGE AT SET COMPOUND = OPEN NOBREAK.
SET PAGE-NUM=OFF
-RUN
SET COMPOUND=OPEN NOBREAK
-RUN
TABLE FILE CAR
SUM SALES
BY COUNTRY
HEADING
"Sales Report"
" "
ON TABLE SUBHEAD
"HEADER_IMG"
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Sales', $
TYPE=HEADING, STYLE=BOLD, COLOR=BLUE, $
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN
SET COMPOUND=CLOSE
-RUN
TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
HEADING
"Cost of Goods Sold Report"
" "
ON TABLE SUBHEAD
"HEADER_IMG"
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Cost', $
TYPE=HEADING, STYLE=BOLD, COLOR=BLUE, $
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END