Hi All,

I have to develop a compound report in PDF format, which have two sets of information:
1. Details by Product
2. Details by Category

I have to print Details by Product in LETTER page, whereas Summary by Category needs to print on LEGAL page.

I am trying with below code, but I am getting both reports on LEGAL page. Note: Below code is for DEMO purpose. I can't share actual code due to security reasons.

-------------------- Code Start -------------------------------------------------------------------------

  

-SET &RPT_TITLE  = 'INDEPENDENT REPAIR FACILITIES (IRF)';
-SET &RPT_TITLE2  = 'EXCEPTION LETTER RECAP';
-SET &WFFMT = 'PDF';
-SET &ITEM1WIDTH = 2;
-SET &ITEM2WIDTH = 6.8;
-SET &ITEM3WIDTH = 1;
-SET &ITEM4WIDTH = 1;
-SET &ORIENT      = 'LXX';


TABLE FILE GGSALES
PRINT
	UNITS/D11C AS 'TOTAL UNIT SALES' 
	DOLLARS/D11.2CM AS 'TOTAL DALLAR SALES' 
	BUDUNITS/D11C AS 'TOTAL BUDGET UNITS' 
	BUDDOLLARS/D11.2CM AS 'TOTAL BUDGET DOLLARS' 
BY PRODUCT  
HEADING
" <+0>ABC COMPANY<+0>"
" <+0>&RPT_TITLE<+0>"
" <+0>&RPT_TITLE2<+0>"

FOOTING BOTTOM
" "
" <+0>ABC Company Confidentials <+0> "
" "

ON TABLE PCHOLD FORMAT &WFFMT OPEN
ON TABLE SET PAGE NOLEAD
ON TABLE SET BYDISPLAY ON
ON TABLE SET STYLESHEET *
UNITS=IN, PAGESIZE='LETTER', ORIENTATION='LANDSCAPE',
     LEFTMARGIN=0.152778, RIGHTMARGIN=0.055556, TOPMARGIN=0.250000, BOTTOMMARGIN=0.00000,
     SQUEEZE=ON, BOTTOMGAP=0, TOPGAP=0, $

TYPE=REPORT, FONT='VERDANA', SIZE=7, COLOR='BLACK', STYLE=NORMAL, GRID=OFF, $

TYPE=TITLE,  SIZE=9, JUSTIFY=CENTER,
     COLOR='WHITE', BACKCOLOR=RGB(179 35 24), STYLE=-UNDERLINE+BOLD,
     BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR=RGB(179 35 24), BORDER-BOTTOM-COLOR=RGB(179 35 24),
     BORDER-LEFT-COLOR=RGB(179 35 24), BORDER-RIGHT-COLOR=RGB(179 35 24),
     BOTTOMGAP=0.05, TOPGAP=0.05, $

TYPE=HEADING,   SIZE=10, BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(179 35 24),  $
TYPE=HEADING,   LINE=1,  ITEM=1,  JUSTIFY=LEFT,    WIDTH=&ITEM1WIDTH.EVAL,  $
TYPE=HEADING,   LINE=1,  ITEM=2,  JUSTIFY=CENTER,  WIDTH=&ITEM2WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=HEADING,   LINE=1,  ITEM=3,  JUSTIFY=RIGHT,   WIDTH=&ITEM3WIDTH.EVAL,  $
TYPE=HEADING,   LINE=1,  ITEM=4,  JUSTIFY=LEFT,    WIDTH=&ITEM4WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=HEADING,   LINE=2,  ITEM=1,  JUSTIFY=LEFT,    WIDTH=&ITEM1WIDTH.EVAL,  $
TYPE=HEADING,   LINE=2,  ITEM=2,  JUSTIFY=CENTER,  WIDTH=&ITEM2WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=HEADING,   LINE=2,  ITEM=3,  JUSTIFY=RIGHT,   WIDTH=&ITEM3WIDTH.EVAL,  $
TYPE=HEADING,   LINE=2,  ITEM=4,  JUSTIFY=LEFT,    WIDTH=&ITEM4WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=HEADING,   LINE=3,  ITEM=1,  JUSTIFY=LEFT,    WIDTH=&ITEM1WIDTH.EVAL,  $
TYPE=HEADING,   LINE=3,  ITEM=2,  JUSTIFY=CENTER,  WIDTH=&ITEM2WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=HEADING,   LINE=3,  ITEM=3,  JUSTIFY=RIGHT,   WIDTH=&ITEM3WIDTH.EVAL,  $
TYPE=HEADING,   LINE=3,  ITEM=4,  JUSTIFY=LEFT,    WIDTH=&ITEM4WIDTH.EVAL,  COLOR=RGB(179 35 24), $

TYPE=FOOTING,   SIZE=9, BORDER-TOP=LIGHT, BORDER-TOP-COLOR=RGB(179 35 24),  $
TYPE=FOOTING,   LINE=1,  COLSPAN=12, $
TYPE=FOOTING,   LINE=2,  ITEM=1,  JUSTIFY=LEFT,    WIDTH=&ITEM1WIDTH.EVAL,  $
TYPE=FOOTING,   LINE=2,  ITEM=2,  JUSTIFY=CENTER,  WIDTH=&ITEM2WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=FOOTING,   LINE=2,  ITEM=3,  JUSTIFY=RIGHT,   WIDTH=&ITEM3WIDTH.EVAL,  $
TYPE=FOOTING,   LINE=2,  ITEM=4,  JUSTIFY=LEFT,    WIDTH=&ITEM4WIDTH.EVAL,  COLOR=RGB(179 35 24), $

TYPE=DATA, STYLE=NORMAL, $
ENDSTYLE
END

TABLE FILE GGSALES
SUM
	UNITS/D11C AS 'TOTAL UNIT SALES' 
	DOLLARS/D11.2CM AS 'TOTAL DALLAR SALES' 
	BUDUNITS/D11C AS 'TOTAL BUDGET UNITS' 
	BUDDOLLARS/D11.2CM AS 'TOTAL BUDGET DOLLARS' 
BY CATEGORY 

HEADING
" <+0>ABC COMPANY<+0>"
" <+0>&RPT_TITLE<+0>"
" <+0>&RPT_TITLE2<+0>"

FOOTING BOTTOM
" "
" <+0>ABC Company Confidentials <+0> "
" "

ON TABLE PCHOLD FORMAT &WFFMT CLOSE
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLESHEET *
UNITS=IN, PAGESIZE='LEGAL', ORIENTATION='LANDSCAPE',
     LEFTMARGIN=0.152778, RIGHTMARGIN=0.055556, TOPMARGIN=0.250000, BOTTOMMARGIN=0.00000,
     SQUEEZE=ON, BOTTOMGAP=0, TOPGAP=0, $

TYPE=REPORT, FONT='VERDANA', SIZE=7, COLOR='BLACK', STYLE=NORMAL, GRID=OFF, $

TYPE=TITLE,  SIZE=9, JUSTIFY=CENTER,
     COLOR='WHITE', BACKCOLOR=RGB(179 35 24), STYLE=-UNDERLINE+BOLD,
     BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR=RGB(179 35 24), BORDER-BOTTOM-COLOR=RGB(179 35 24),
     BORDER-LEFT-COLOR=RGB(179 35 24), BORDER-RIGHT-COLOR=RGB(179 35 24),
     BOTTOMGAP=0.05, TOPGAP=0.05, $

TYPE=HEADING,   SIZE=10, BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(179 35 24),  $
TYPE=HEADING,   LINE=1,  ITEM=1,  JUSTIFY=LEFT,    WIDTH=&ITEM1WIDTH.EVAL,  $
TYPE=HEADING,   LINE=1,  ITEM=2,  JUSTIFY=CENTER,  WIDTH=&ITEM2WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=HEADING,   LINE=1,  ITEM=3,  JUSTIFY=RIGHT,   WIDTH=&ITEM3WIDTH.EVAL,  $
TYPE=HEADING,   LINE=1,  ITEM=4,  JUSTIFY=LEFT,    WIDTH=&ITEM4WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=HEADING,   LINE=2,  ITEM=1,  JUSTIFY=LEFT,    WIDTH=&ITEM1WIDTH.EVAL,  $
TYPE=HEADING,   LINE=2,  ITEM=2,  JUSTIFY=CENTER,  WIDTH=&ITEM2WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=HEADING,   LINE=2,  ITEM=3,  JUSTIFY=RIGHT,   WIDTH=&ITEM3WIDTH.EVAL,  $
TYPE=HEADING,   LINE=2,  ITEM=4,  JUSTIFY=LEFT,    WIDTH=&ITEM4WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=HEADING,   LINE=3,  ITEM=1,  JUSTIFY=LEFT,    WIDTH=&ITEM1WIDTH.EVAL,  $
TYPE=HEADING,   LINE=3,  ITEM=2,  JUSTIFY=CENTER,  WIDTH=&ITEM2WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=HEADING,   LINE=3,  ITEM=3,  JUSTIFY=RIGHT,   WIDTH=&ITEM3WIDTH.EVAL,  $
TYPE=HEADING,   LINE=3,  ITEM=4,  JUSTIFY=LEFT,    WIDTH=&ITEM4WIDTH.EVAL,  COLOR=RGB(179 35 24), $

TYPE=FOOTING,   SIZE=9, BORDER-TOP=LIGHT, BORDER-TOP-COLOR=RGB(179 35 24),  $
TYPE=FOOTING,   LINE=1,  COLSPAN=12, $
TYPE=FOOTING,   LINE=2,  ITEM=1,  JUSTIFY=LEFT,    WIDTH=&ITEM1WIDTH.EVAL,  $
TYPE=FOOTING,   LINE=2,  ITEM=2,  JUSTIFY=CENTER,  WIDTH=&ITEM2WIDTH.EVAL,  COLOR=RGB(179 35 24), $
TYPE=FOOTING,   LINE=2,  ITEM=3,  JUSTIFY=RIGHT,   WIDTH=&ITEM3WIDTH.EVAL,  $
TYPE=FOOTING,   LINE=2,  ITEM=4,  JUSTIFY=LEFT,    WIDTH=&ITEM4WIDTH.EVAL,  COLOR=RGB(179 35 24), $

TYPE=DATA, STYLE=NORMAL, $

ENDSTYLE
END

-------------------- Code End -------------------------------------------------------------------------

Output: 1. Details by Product




Output: 2. Details by Category




Please let me know, how can i achieve my requirement. Thanks in Advance.

Regards,
Sandy Sagar

This message has been edited. Last edited by: FP Mod Chuck,

I believe the document has its own orientation and layout which apply to both reports. I just tried something like your example and in the top of the document this is what I see:

 COMPOUND LAYOUT PCHOLD FORMAT PDF
SECTION=Section_1, LAYOUT=ON, PAGESIZE=LEGAL, ORIENTATION=LANDSCAPE, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page 1', TEXT='Page 1', LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $
COMPONENT=TableChart_1, COMPONENT-TYPE=REPORT, POSITION=(0.520833 0.4375), DIMENSION=(* *), ARREPORTSIZE=DIMENSION, METADATA='VERSION:1.0;WIDTH:4.0;HEIGHT:3.0;LEFT:0.520833;TOP:0.4375', $
COMPONENT=TableChart_2, COMPONENT-TYPE=REPORT, POSITION=(0.291666 3.739583), DIMENSION=(* *), ARREPORTSIZE=DIMENSION, METADATA='VERSION:1.0;WIDTH:4.0;HEIGHT:3.0;LEFT:0.291666;TOP:3.739583', $
END 

Hi sandy2sagar,

I don't think that 7.6 will support two different page sizes.

I do remember using a third part tool to combine two reports with different page sizes to get the desire result.

Hi Waz,

I am trying this in WebFOCUS 8.105M version. And I don't want to use third party tool for merging two separate reports. I need only one report contains both sub-reports.

Regards,
Sandy

I would suggest trying the compound layout.

If you are on 8.1.05 (Your signature states 7.6), then you could try creating two sections one for legal and one for letter.

Perhaps using the compound layout tool may help.