I have a compound Excel report and I want all the reports to be on one tab, but the first report is always on the first tab and the others are on the second tab. How do I get them to all be on the first tab?
I set up the compound report thusly:

SET HTMLARCHIVE=ON
*-HOLD_SOURCE
COMPOUND LAYOUT PCHOLD FORMAT EXL2K
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.5^Margins_Top=.25^Margins_Right=0.5^Margins_Bottom=.25^thumbnailscale=4', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, $
COMPONENT='report01', TEXT='report01', TOC-LEVEL=2, POSITION=(0.520 0.312), DIMENSION=(* *), ARREPORTSIZE=DIMENSION, $
COMPONENT='report02', TEXT='report02', TOC-LEVEL=2, POSITION=(-0.001 +0.127), DIMENSION=(* *), RELATIVE-TO='report01', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, BYTOC=0, ARREPORTSIZE=DIMENSION,$
COMPONENT='report03', TEXT='report03', TOC-LEVEL=2, POSITION=(-0.001 +0.127), DIMENSION=(* *), RELATIVE-TO='report02', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, BYTOC=0, ARREPORTSIZE=DIMENSION,$


And I have ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK on the first report. What am I missing?

Thanks,
Deb

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

A guess (not tested), remove

quote:

BYTOC=0

BYTOC is normally used to create a "break" in the report display which is a new tab in Excel.

Nice thought, MartinY, but it didn't work. I even tried removing the TOC-LEVEL parameters. Still getting two tabs.

I figured it out -- I removed the COMPOUND LAYOUT bit and just ran the reports with OPEN NOBREAK on the first and CLOSE on the last and that put them all on the same tab.
I've only done compound PDF reports before; I guess EXCEL is a bit different!