Hai,
We have an FEX which contains two procedures both having EXCEL2K output format.
Is there any method to display both the reports in a single worksheet or even in a single workbook as seperate worksheets.
Any workarounds on this?
Please help..
We have WEBFOCUS version 5.3.

multiple sheets is coming in version 7, so we're told.

This feature is in 5.3

SET COMPOUND = OPEN NOBREAK
report1
report2
SET COMPOUND = CLOSE
report3

This seems to have limitaions with 'BY'.
We have multiple Sub Totals being displayed.
Only first worksheet is displayed when i tried this option.

I am dealing like this.

-TYPE WEBFOCUS CGIVAR IBIWF_mreports=FRAME
-TYPE WEBFOCUS CGIVAR IBIWF_mrrows=2
TABLE FILE CAR
SUM DCOST RCOST
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN
TABLE FILE CAR
PRINT SEAT TYPE
BY COUNTRY
BY CAR
ON TABLE PCHOLD FORMAT EXL2K
END


EXCEL is opened and copy & paste.

Thanks

Here is a working example from IBI. It creates one workbook with three worksheets.

Note: MS Excel XP/2002/2003 are needed to create compound Excel Reports.



SET PAGE-NUM=OFF
TABLE FILE CAR
HEADING
"Sales Report"
" "
SUM SALES
BY COUNTRY
ON TABLE SET STYLE *
type=report, titletext='Sales Rpt', $
type=heading, size=18, $
ENDSTYLE
ON TABLE PCHOLD AS EX1 FORMAT EXL2K OPEN
END

TABLE FILE CAR
HEADING
"Inventory Report"
" "
SUM RC
BY COUNTRY
ON TABLE SET STYLE *
type=report, titletext='Inventory Rpt', $
type=heading, size=18, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END

TABLE FILE CAR
HEADING
"Cost of Goods Sold Report"
" "
SUM DC
BY COUNTRY
ON TABLE SET STYLE *
type=report, titletext='Cost Rpt', $
type=heading, size=18, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K CLOSE
END

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