Hi
I created the looping of the report in HTML version with help of TD property . I need the help on PDF and Excel reports .

Please see my HTML code :

-SET &TXT_COUNT =2;
-SET &CNTT = 0;


-LOOP
-IF &CNTT GT (&TXT_COUNT -1) THEN GOTO LOOP_END;
-SET &CNTT = &CNTT +1;

-SET &RPT_HOLD_LINE = 'ON TABLE HOLD AS HTML' |&CNTT;


TABLE FILE CAR
SUM
RETAIL_COST
BY CAR
ON TABLE SET PAGE-NUM OFF
&RPT_HOLD_LINE.EVAL FORMAT HTML
END

-GOTO LOOP
-LOOP_END

-HTMLFORM BEGIN


-* START HTMLLOOP1

!IBI.FIL.HTML1; -*

!IBI.FIL.HTML2;

!IBI.FIL.HTML3;

!IBI.FIL.HTML4;

-HTMLFORM END

Please help me to achive the same thing in PDF and EXCEL reports .

Thanks
Gobinath Velusamy

This message has been edited. Last edited by: Gobinath Velusamy,

Gopi,
Are you looking for compound report with two reports positioned side by side? then PDF Layout Painter will work for both PDF as well as Excel.

-Ram

Hi Ram

The problem is here ... the 2 reports can change to 10 ... this number is dynamic one .. so i cant desigh the report with Compound layout

Is this an option?

-SET &TXT_COUNT = 2;
-SET &CNTT = 0;

-LOOP
-IF &CNTT GT (&TXT_COUNT -1) THEN GOTO LOOP_END;

-IF &CNTT LT (&TXT_COUNT -1) THEN GOTO LABEL1 ELSE GOTO LABEL2;
-LABEL1
SET COMPOUND = NOBREAK
-GOTO ENDIF
-LABEL2
SET COMPOUND = CLOSE
-ENDIF

-SET &CNTT = &CNTT +1;

TABLE FILE CAR 
SUM 
RETAIL_COST 
BY CAR 
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT HTML
END 

-GOTO LOOP 
-LOOP_END

?

Edited : tested working code

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

Hope this helps, Use Overflow option in case if its a growing report.

-*?FF GGSALES
-*-EXIT
-SET &CNTR=0;
-SET &RPT_CNT_1=-1;
-SET &RPT_CNT_2=0;

COMPOUND LAYOUT PCHOLD FORMAT PDF
-*COMPOUND LAYOUT PCHOLD FORMAT EXL2K
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5', MERGE=OFF,ORIENTATION=LANDSCAPE, PAGESIZE=LETTER, $
-REPEAT LOOP_1 2 TIMES

-SET &CNTR=&CNTR+1;
-SET &RPT_CNT_1=&RPT_CNT_1+2;
-SET &RPT_CNT_2=&RPT_CNT_2+2;
-SET &RPT_NM_1='REPORT_'||&RPT_CNT_1.EVAL;
-SET &RPT_NM_2='REPORT_'||&RPT_CNT_2.EVAL;

PAGELAYOUT=&CNTR.EVAL, 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='&RPT_NM_1.EVAL', TEXT='&RPT_NM_1.EVAL', POSITION=(1.2500 0.2500), DIMENSION=(4.00 *), $
COMPONENT='&RPT_NM_2.EVAL', TEXT='&RPT_NM_2.EVAL', POSITION=(4.2500 0.2500), DIMENSION=(4.00 *), $
-LOOP_1

END

-SET &RPT_CNT_1=-1;
-SET &RPT_CNT_2=0;

-REPEAT LOOP_2 2 TIMES

-SET &RPT_CNT_1=&RPT_CNT_1+2;
-SET &RPT_CNT_2=&RPT_CNT_2+2;
-SET &RPT_NM_1='REPORT_'||&RPT_CNT_1.EVAL;
-SET &RPT_NM_2='REPORT_'||&RPT_CNT_2.EVAL;

SET COMPONENT='&RPT_NM_1.EVAL'
TABLE FILE GGSALES
BY PRODUCT
BY CATEGORY
END
SET COMPONENT='&RPT_NM_2.EVAL'
TABLE FILE GGSALES
BY PRODUCT
BY CATEGORY
END

-LOOP_2
COMPOUND END

I think you need to research COMPOUND reports