Hi,

Is it possible to create a compound document report with 4 procedures and all output at one sheet?
I am able to create it but with 4 sheets. One to each report.

Thanks

This message has been edited. Last edited by: Ricardo Augusto,

Have you tried adding NOBREAK to the COMPOUND command ?

Hi Waz, How are you?
No, not yet. I will try it asap then I post here.

Thanks

I added the NOBREAK but it still creates 2 sheets.

 

-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON

SET COMPOUND = NOBREAK
*-HOLD_SOURCE
COMPOUND LAYOUT PCHOLD FORMAT XLSX
UNITS=CM, $
SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.5^Margins_Top=0.5^Margins_Right=0.5^Margins_Bottom=0.5^thumbnailscale=4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=A4, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(-0.053 0.000), DIMENSION=(20.798 9.436), BYTOC=0,  ARREPORTSIZE=DIMENSION, METADATA='left: -0.053cm; top: 0cm; width: 20.798cm; height: 9.436cm; position: absolute; z-index: 1;', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(-0.053 9.790), DIMENSION=(20.902 11.377), BYTOC=0,  ARREPORTSIZE=DIMENSION, METADATA='left: -0.053cm; top: 9.79cm; width: 20.902cm; height: 11.377cm; position: absolute; z-index: 2;', $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE jatohl_ren_total_industry.fex
SET COMPONENT='report2'
-*component_type report
-INCLUDE vesir_21815_r_jatohl.fex
COMPOUND END
 

Reprocuding it using CAR.

report1:

 
SET NODATA = 0
SET COMPMISS = ON
-* File: IBFS:/localhost/EDA/EDASERVE/APPPATH/ibisamp/exemplos/Report1.fex Created by WebFOCUS AppStudio
TABLE FILE CAR
SUM
     CAR.BODY.SALES/D12C
 RANKED BY  LOWEST CAR.COMP.CAR
ACROSS LOWEST CAR.ORIGIN.COUNTRY AS ''

ON CAR.COMP.CAR NOSPLIT
ON TABLE SUBHEAD
"Sales Analysis"
ON TABLE SUBFOOT
"Powered by WebFOCUS"
"&DATEtrMDYY <+0> &TOD"
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE SET ASNAMES ON
ON TABLE SET POPUPDESC ON
ON TABLE ROW-TOTAL AS 'TOTAL'
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT XLSX 
ON TABLE SET XLSXPAGESETS ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
     PAGESIZE='A4',
     LEFTMARGIN=0.000000,
     RIGHTMARGIN=0.000000,
     TOPMARGIN=0.000000,
     BOTTOMMARGIN=0.000000,
     ORIENTATION=LANDSCAPE,

$
TYPE=DATA,
     COLUMN=ROWTOTAL(1),
     STYLE=BOLD,
$
TYPE=DATA,
     COLUMN=ROWTOTAL(*),
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=ROWTOTAL(1),
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=10,
     STYLE=BOLD+ITALIC,
     JUSTIFY=CENTER,
$
TYPE=ACROSSVALUE,
     ACROSS=1,
     COLUMN=ROWTOTAL(1),
     STYLE=-UNDERLINE+BOLD,
$
ENDSTYLE
END
 

report2:

 
-* File: IBFS:/localhost/EDA/EDASERVE/APPPATH/ibisamp/exemplos/Report1.fex Created by WebFOCUS AppStudio
TABLE FILE CAR
SUM
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
     CAR.BODY.SALES
BY  CAR.CARREC.MODEL
ON TABLE SUBHEAD
"Sales by Model"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT XLSX 
ON TABLE SET XLSXPAGESETS ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$

ENDSTYLE
END

compound:
 [CODE] 
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
SET COMPOUND = NOBREAK
*-HOLD_SOURCE
COMPOUND LAYOUT PCHOLD FORMAT EXL2K
UNITS=CM, $
SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.5^Margins_Top=0.5^Margins_Right=0.5^Margins_Bottom=0.5^thumbnailscale=4', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=A4, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(1.531 0.000), DIMENSION=(17.659 8.265), BYTOC=0,  ARREPORTSIZE=DIMENSION, METADATA='left: 1.531cm; top: 0cm; width: 17.659cm; height: 8.265cm; position: absolute; z-index: 1;', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(1.005 8.731), DIMENSION=(27.781 11.642), BYTOC=0,  ARREPORTSIZE=DIMENSION, METADATA='left: 1.005cm; top: 8.731cm; width: 27.781cm; height: 11.642cm; position: absolute; z-index: 2;', $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE sales_by_country.fex
SET COMPONENT='report2'
-*component_type report
-INCLUDE sales_by_models.fex
COMPOUND END


 

[/CODE]

That is because you have to code the first report as PCHOLD FORMAT EXL2K OPEN and the second report as PCHOLD FORMAT EXL2K CLOSE