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     Please help on page-break between reports

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Please help on page-break between reports
 Login/Join
 
<Vipul>
posted
I need to specify page break(s) between compound reports...please help. I am attaching the sample code below:

I need page-break after each report...

-* File carhtmlform.fex
-SET &CNTR = 1 ;
-SET &OLDCOUNTRY = ' ' ;
-LOOPBACK
TABLE FILE CAR
SUM DST.COUNTRY NOPRINT
BY COUNTRY NOPRINT
WHERE COUNTRY GT '&OLDCOUNTRY'
IF RECORDLIMIT EQ 1
ON TABLE SAVE
END
-RUN
-READ SAVE &COUNTRY.A10. ;
-TYPE &COUNTRY
-SET &OLDCOUNTRY = IF &OLDCOUNTRY NE '&COUNTRY' THEN &COUNTRY ;
-TYPE &OLDCOUNTRY
-IF &LINES EQ 0 THEN GOTO NEXTSTEP;

TABLE FILE CAR
PRINT COUNTRY
CAR
MODEL
SEATS
SALES
RETAIL_COST
DEALER_COST
WHERE COUNTRY = '&COUNTRY'
HEADING
"Car Details"
ON TABLE HOLD AS PYDYCBO1 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=HEADING, LINE=1, STYLE=BOLD, COLOR=BLUE, $
-INCLUDE STYLEV01IR.FEX
ENDSTYLE
END

-HTMLFORM BEGIN
!IBI.FIL.PYDYCBO1;
-HTMLFORM END

-GOTO LOOPBACK
-NEXTSTEP
TABLE FILE CAR
PRINT COUNTRY
CAR
SALES
RETAIL_COST
DEALER_COST
HEADING
"Car Details #2"
ON TABLE HOLD AS PYDYCBO4 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=HEADING, LINE=1, STYLE=BOLD, COLOR=BLUE, $
-INCLUDE STYLEV01IR.FEX

ENDSTYLE
END

-HTMLFORM BEGIN
!IBI.FIL.PYDYCBO4;
-HTMLFORM END


Thanks,

Vipul
 
Report This Post
<Grzegorz>
posted
Vipul,

You can try to experiment with something like:


...
COMPUTE BREAK_BEGIN/A42 = '
'; NOPRINT
COMPUTE BREAK_END/A6 = '
'; NOPRINT
WHERE COUNTRY = '&COUNTRY'
HEADING
"...

Note: the HTML/CSS page break is invisible in browser, it affects only printing. You can use some tag like HR to emulate multi-page HTML report.

Hope this helps
Grzegorz

This message has been edited. Last edited by: <Mabel>,
 
Report This Post
<Vipul>
posted
That worked but I am sure they will like to see the page break on screen also.

Thanks
Vipul
 
Report This Post
<Pietro De Santis>
posted
Vipul,

You may like to take a look at this:

http://www.blooberry.com/indexdot/css/properties/print/pbbefore.htm

It shows you hot to create page breaks for printing purposes for HTML files in Internet Explorer.

Pietro.
 
Report This Post
Expert
posted Hide Post
Pietro, what a great site! thanks!~
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
<Vipul>
posted
Thanks Peter,

Somehow I am not allowed to access the website at work. i will do so from home.

Regards,

Vipul
 
Report 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     Please help on page-break between reports

Copyright © 1996-2020 Information Builders