Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     PDF& Excel Looping ( Resolved)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
PDF& Excel Looping ( Resolved)
 Login/Join
 
Platinum Member
posted
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,


WebFOCUS 7610
Windows
 
Posts: 121 | Registered: September 25, 2007Report This Post
Master
posted Hide Post
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
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Platinum Member
posted Hide Post
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


WebFOCUS 7610
Windows
 
Posts: 121 | Registered: September 25, 2007Report This Post
Master
posted Hide Post
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,


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
Master
posted Hide Post
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
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Expert
posted Hide Post
I think you need to research COMPOUND reports


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     PDF& Excel Looping ( Resolved)

Copyright © 1996-2020 Information Builders