I would like to display three reports on one EXCEL sheet. I am using compound report to do it. However when I am running a report I am getting first report on the one sheet and two others on the second sheet instead of all three reports on one sheet

Here is code


-* File COMPEXCEL.fex
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT EXL2K
.
.
.
END
SET COMPONENT='report2'
-*component_type report
TABLE FILE PLEDGOR
PRINT
'PLEDGOR.PLEDGOR.PLEDGOR_ID'
'PLEDGOR.PLEDGOR.ABA_NR'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD FORMAT EXL2K OPEN NOBREAK
-*ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END
SET COMPONENT='report3'
-*component_type report
TABLE FILE ACCTS
PRINT
'ACCTS.ACCTS.ACCT_ID'
'ACCTS.ACCTS.ACCT_NAME'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END
SET COMPONENT='report4'
-*component_type report
TABLE FILE TCMM_ATBC
PRINT
'ATBC.TATBC.ACCT_ID'
'ATBC.ATBC.PLEDGOR_ID'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END
COMPOUND END


Can somebody help me

Try changing your first HOLD statement to PCHOLD:

ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK

Sorry for confusion
Report 2 is very first report on the page, Report 3 is second and Report 4 is a third. All these names were generated by WF