Hi,Kindly see the below sample code displaying excel report in multiple worksheet
1st worksheet contains the result of table output
2nd worksheet contains the graph

-SET &ECHO = ALL;

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT EXL2K
UNITS=IN, $
SECTION=section1,
LAYOUT=ON,
ORIENTATION=PORTRAIT,
PAGESIZE=Letter, $
PAGELAYOUT=1, $
COMPONENT='REPORT1', $
COMPONENT='HOLD1', $
END

SET TEMPERASE = OFF

SET COMPONENT='REPORT1'
TABLE FILE CAR
SUM
SALES
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
END

SET COMPONENT='HOLD1'
GRAPH FILE CAR
SUM
SALES
BY COUNTRY
ON GRAPH HOLD AS GIF1 FORMAT GIF
ON GRAPH SET STYLE *
SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, $
ENDSTYLE
END

TABLE FILE CAR
SUM
SALES NOPRINT
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, IMAGE=GIF1.GIF,$
ENDSTYLE
END

COMPOUND END


Error :
SET DISTRIBUTE=OFF
INVALID DISTRIBUTION FORMAT FOR COMPOUND REPORT
Compound Report is TERMINATING.....
Task error: INVALID DISTRIBUTION FORMAT FOR COMPOUND REPORT
No report to distribute.

Kindly provide me a solution to schedule compound excel reports having Multiple worksheets

The graph is created and then inserted in to Excel as an image. Runs fine until I try to schedule and run thru ReportCaster...

Are you trying to burst the report or just send out the entire book to a distribution list?

I am sending the entire book to the distribution list and not bursting the report...

Hi,

Perhaps reading this document could help you.
Read the part "Distributing a Graph Image in a PDF Report" in appendix C page 504.

Hope this helps you solving the problem.

If compound excel reports contains graph,then still not able to schedule them.Its getting scheduled if it doesn't have graph.

Since to have graph in excel report, the code is different and using COMPOUND LAYOUT PCHOLD FORMAT EXL2K and so on.

But for normal compound excel report, we use
ON TABLE PCHOLD FORMAT EXL2K OPEN

One of the error messages is

quote:

INVALID DISTRIBUTION FORMAT FOR COMPOUND REPORT

What format are you selecting in the ReportCaster scheduling tool when you create the schedule? The default is HTML. If you do not change the default to EXL2K in the scheduling UI then it will try to create the report in HTML. HTML is invalid for compound reports (you would need to select DHTML).

I am selecting EXL2K format in the ReportCaster scheduling tool.

Is it the limitation of tool for excel compound reports with graph getting scheduled?