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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
PAGE-BREAK ISSUE
 Login/Join
 
chelsea
Silver Member
posted
Hi,
i am trying to create a html report in which i need to display only 5 locations per page. that is my sort field is location and i need to display only 5 locations per page. i tried page-break but somehow i could'nt get that.
any suggestions
Thanks
 
Posts: 37 | Registered: December 28, 2005Report This Post
Kamesh
Master
posted Hide Post
Define the counter to find the number of locations. If the number of location is 5 then give Page-Break.

Ex:

DEFINE FILE TEST
CNT/I1=IF LOCATION THEN CNT + 1 ELSE CNT;
CNT1/A1=IF CNT EQ 5 OR 10 OR 15 OR 20 OR 25 OR 30 THEN 'Y' ELSE 'N';
END

TABLE FILE TEST
PRINT XXX
XXX
BY YYY
ON YYY SUBFOOT PAGE-BREAK
WHEN CNT1 EQ 'Y'
END
-EXIT


WFConsultant

WF 8105M on Win7/Tomcat
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
susannah
Expert
posted Hide Post
Chelsea
i control my page breaking by letting my users' browser tell the printer when to break.
so your question doesn't say if you want pagebreak on screen because you want to repeat heaeder, or if you want pagebreaks on the printer, and you need to edit your profile so that your signature tells us what version and platform.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
chelsea
Silver Member
posted Hide Post
Hi sussanah/kamesh,
Kamesh i tried your code but it did not work for me may be i am missing something.
sussanah i want the page break on the screen to repeat the header and not while printing.
sorry for the late reply and thanks for your suggestions
 
Posts: 37 | Registered: December 28, 2005Report This Post
Kamesh
Master
posted Hide Post
Try this,

DEFINE FILE TEST
PGBK1/I11=IF LOCATION EQ LAST LOCATION THEN PGBK1 ELSE (PGBK1 + 1);
PGBK2/I11 = IF PGBK1 EQ LAST PGBK1 THEN PGBK2 ELSE (PGBK2 + 1);
PGBK3/A2 = IF PGBK2 EQ 2 OR 4 OR 6 OR 8 OR 10 OR 12 OR 14 OR 16 OR 18 OR 20 OR 22 OR 24 OR 26 OR 28 OR 30 OR 32 THEN 'PB' ELSE ' ';
END

TABLE FILE TEST
PRINT XXX
XXX
BY PGBK1 NOPRINT
BY LOCATION
ON LOCATION PAGE-BREAK WHEN PGBK3 EQ 'PB'
END
-EXIT

Hope this will work.


WFConsultant

WF 8105M on Win7/Tomcat
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Mike Johnson
Gold member
posted Hide Post
I came across this code on this forum.

It allows you to set the number of lines per page and also displays Page 1 of #. I think you should be able to modify it to meet your needs.

-SET &LNE = 3;
DEFINE FILE CAR
COUNTER/I5 WITH BODYTYPE = IF COUNTRY NE LAST COUNTRY THEN 1 ELSE
IF COUNTER GE &LNE THEN 1 ELSE COUNTER + 1;
PAGENO/I5 WITH BODYTYPE = IF COUNTRY NE LAST COUNTRY THEN 1 ELSE
IF COUNTER EQ 1 THEN PAGENO + 1 ELSE PAGENO;
END
TABLE FILE CAR
HEADING
"THIS IS PAGE <TABPAGENO OF <MAX.PAGENO "
SUM MAX.PAGENO
BY COUNTRY
PRINT RCOST
COUNTER
BY COUNTRY PAGE-BREAK REPAGE
BY PAGENO  PAGE-BREAK
BY CAR
BY MODEL
BY BODYTYPE
END
-RUN

This message has been edited. Last edited by: Kerry,
 
Posts: 84 | Location: Tallahassee, Fl. | Registered: December 02, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders