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     Page Numbering per Page Break

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Page Numbering per Page Break
 Login/Join
 
<Krysti710>
posted
I have a report that is by "agent". The whole report is 100 pages long. I have page breaks by "agent" so we can distribute each agent's section to him/her separately. So, for example, the first agent's section is only 1 page so the page number should be Page 1 of 1. The second agent's section is 5 pages so the page number should start over for him, Page 1 of 5, Page 2 of 5 and so on. If I just use the regular "Page <TABPAGENO of <TABLASTPAGE", it just numbers them Page 1 of 100, Page 2 of 100 and so on.

Does anyone know if this is possible to do?

Thanks for any and all help Smiler

Krysti
 
Report This Post
<Pietro De Santis>
posted
ON|BY} fieldname PAGE-BREAK REPAGE
 
Report This Post
jimster06
Guru
posted Hide Post
The REPAGE will not reset the total number of pages but consider the following:

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 NOPRINT BY COUNTRY
PRINT RCOST BY COUNTRY PAGE-BREAK REPAGE
BY PAGENO NOPRINT PAGE-BREAK
BY CAR BY MODEL
BY BODYTYPE
END
-RUN
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report This Post
<Krysti710>
posted
Hi Jimster,

Thanks for getting back to me so quickly and sorry it took so long to get back to you. I got caught up in some other stuff and just finally had a chance to get back to this.

It seems we're on the right track, but what is &LNE?

Thanks so much for your help!

Christy Smiler
 
Report This Post
jimster06
Guru
posted Hide Post
&LNE is lines per page.
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report This Post
<Krysti710>
posted
Am I supposed to set it as something?
 
Report This Post
jimster06
Guru
posted Hide Post
Set it to how many lines you want per page: eg -SET = 55; where the hyphen is in position 1.
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report This Post
jimster06
Guru
posted Hide Post
Better
-SET &LNE = 55;
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report This Post
<Krysti710>
posted
Thanks Jim, works great! Just one more small question. For some reason there are extra spaces:

Page 1 of 1

instead of:

Page 1 of 1.

People are really picky here. Have you come across this and know a way to fix it?
 
Report This Post
jimster06
Guru
posted Hide Post
Your example got squeezed but I think I understand the question.
What is the output format you are using? Also platform.
When I execute in WF to HTML there is no issue.
 
Posts: 252 | Location: USA | Registered: April 15, 2003Report 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     Page Numbering per Page Break

Copyright © 1996-2020 Information Builders