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    Search    Search Results
Page 1 2 3 
Go
Search
Tools
Search Results: (43 matches) New Search Login/Join 

Discussion Topic  RE: [CLOSED] Page numbering in a compound report (in WebFOCUS/FOCUS Forum on Focal Point ) by Tony A
COUNTRY EQ 'ENGLAND' FOOTING "Page TABPAGENO /1" ON TABLE SET FOCFIRSTPAGE 2 ON TABLE PCHOLD FORMAT HTML ... MODEL WHERE COUNTRY EQ 'ENGLAND' FOOTING "Page TABPAGENO " ON TABLE SET FOCFIRSTPAGE 3 ON TABLE PCHOLD ... FOCFIRSTPAGE &FOCNEXTPAGE. Ok, this is HTML output but use in a PDF compound document and see how it...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Page numbering in a compound report (in WebFOCUS/FOCUS Forum on Focal Point ) by StuBouyer
It does say that, however it doesn't appear to be the caseTry this and see if it's ignored.SET FOCFIRSTPAGE = 5 TABLE FILE CAR PRINT MODEL SEATS RETAIL_COST BY COUNTRY BY CAR ON COUNTRY PAGE-BREAK HEADING "" FOOTING "Page TABPAGENO" ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Page numbering in a compound report (in WebFOCUS/FOCUS Forum on Focal Point ) by arvind
http://documentation.informationbuilders.com/masterinde.../source/topic194.htmHI tony ,In the above link , it is mentioned that if I use both TABPAGENO , theN FOCFIRSTPAGE is ignored. ???Please explain....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Page numbering in a compound report (in WebFOCUS/FOCUS Forum on Focal Point ) by Tony A
[IOTW]quote:SET PAGE-NUM = ON is the only option to display the page numberingSimply not true, but then if you had any training you would probably have known that.quote:When i use TABPAGENO variable i cannot use FOCFIRSTPAGE , so it is either one of the two..Really? I have many fexes that use this...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Page numbering in a compound report (in WebFOCUS/FOCUS Forum on Focal Point ) by arvind
HI TONY,Thanks a lot for your tip.. But , when i use the clause FOCFIRSTPAGE AND consequently hte ... variable i cannot use FOCFIRSTPAGE , so it is either one of the two..Can you please suggest a way where the page number can be displayed at the bottom using FOCFIRSTPAGE..Thank you for your patience T...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Page numbering in a compound report (in WebFOCUS/FOCUS Forum on Focal Point ) by Tony A
Arvind,Search on FOCFIRSTPAGE and you will find many suggestions on how to achieve what you want to do.T...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Sum a field value at header level or subhead level (in WebFOCUS/FOCUS Forum on Focal Point ) by Prasadbollam
: ' | &TIME | ' PM' ELSE ' TIME: ' | &TIME | ' AM'; -SET DATETIME=NOW; SET FOCFIRSTPAGE= 1 -RUN DEFINE...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Page numbering with coordinated compound PDF reports (in WebFOCUS/FOCUS Forum on Focal Point ) by Darin Lee
need Report4 to start on Page 14.I am using &FOCNEXTPAGE and SET FOCFIRSTPAGE to carry my page...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Reset page number in compound PDF Report (in WebFOCUS/FOCUS Forum on Focal Point ) by UC_Mark
/known_problems/92571114.htmlI did some searching on FOCFIRSTPAGE and found a couple of ideas to get...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Reset page number in compound PDF Report (in WebFOCUS/FOCUS Forum on Focal Point ) by FortuneCookie
This worked for me on my 7.1.7 Reporting ServerSET FOCFIRSTPAGE= 1-RUNTABLE FILE CARHEADING"This is report one""Page: TABPAGENO"PRINT RCOST BY COUNTRYON TABLE PCHOLD FORMAT PDF OPENEND-RUNSET FOCFIRSTPAGE= 1-RUNTABLE FILE CARHEADING"This is report two - page number should start over""Page...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Page numbering in multiple pdf reports (in WebFOCUS/FOCUS Forum on Focal Point ) by Jim Dale
I have one fex that produces 5 different reports. How can I get the page number to start at 1 when a new report starts. I tried using SET FOCFIRSTPAGE=1 but I must be using in incorrectly.Thanks,JimWebFocus 7.13UnixOracle...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Compund report in PDF format (in WebFOCUS/FOCUS Forum on Focal Point ) by wf1998
Hi Use FOCFIRSTPAGE to set the page And Compound Command To Open And Close Compound ReportHere is the exampleSET FOCFIRSTPAGE = &FOCNEXTPAGESET COMPOUND = OPEN-* Report ... FORMAT PDFEND-RUN-* Report 2 ----------------------------SET FOCFIRSTPAGE = &FOCNEXTPAGETABLE FILE CAR...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Letters in PDF (in WebFOCUS/FOCUS Forum on Focal Point ) by Francis Mariani
letter to start at page 1, you can add this to just before each TABLE FILE:SET FOCFIRSTPAGE = 1...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]Duplex printing (in WebFOCUS/FOCUS Forum on Focal Point ) by Jim_at_LM
. Research the FOCFIRSTPAGE variable. It works fine and increments from 1 in the same FEX as long as each ... &RPTOPTION EQ 'CMB' AND &RPT_TYPE EQ 'Receipt' - THEN 4 ELSE 1 ; SET FOCFIRSTPAGE = &FIRSTPAGE -RUN...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Page numbering in Report differs from PDF page numbering (in WebFOCUS/FOCUS Forum on Focal Point ) by Jim_at_LM
For our PDF reports, we used:SET FOCFIRSTPAGE=1 (or set it to whatever # you want)-RUN TABLE FILE ... setting with:SET FOCFIRSTPAGE = &FOCNEXTPAGETABLE FILE ..ON TABLE ... FORMAT PDF .. OPEN (for first rpt)END-RUN SET FOCFIRSTPAGE = &FOCNEXTPAGETABLE FILE ..:2nd report etc.END As long as you have all...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Compound PDFs to start with Page 1 (in WebFOCUS/FOCUS Forum on Focal Point ) by Francis Mariani
SET FOCFIRSTPAGE = 1 in between compound PDF reports does not appear to work in 5.3.4 - the page numbers are sequential....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Compound PDFs to start with Page 1 (in WebFOCUS/FOCUS Forum on Focal Point ) by reFOCUSing
Give this a try: SET FOCFIRSTPAGE = 1 SET COMPOUND = OPEN TABLE FILE CAR HEADING "tabpageno PRINT COUNTRY ON TABLE PCHOLD FORMAT PDF END -RUN SET FOCFIRSTPAGE = &FOCNEXTPAGE TABLE FILE CAR HEADING "tabpageno PRINT CAR ON TABLE PCHOLD FORMAT PDF END -RUN SET COMPOUND = CLOSE SET FOCFIRSTPAGE...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Compound PDFs to start with Page 1 (in WebFOCUS/FOCUS Forum on Focal Point ) by Carol Dobson
-SET APP PREPENDPATH CARTST -SET &FOCFIRSTPAGE = 1 ; -RUN TABLE FILE CAR SUM COUNTRY BY COUNTRY ON TABLE PCHOLD FORMAT PDF OPEN HEADING CENTER "REPORT NUMBER 1" END -SET &FOCFIRSTPAGE ... 2" END -SET &FOCFIRSTPAGE = 1 ; -RUN TABLE FILE CAR PRINT COUNTRY MODEL ON TABLE PCHOLD FORMAT...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Compound PDFs to start with Page 1 (in WebFOCUS/FOCUS Forum on Focal Point ) by Carol Dobson
Hi everyone! I have a user who wants to compound several reports but doesn't want the consecutive page numbering. She wants each report in the compound document to start with page 1. I've tried using tabpageno and focfirstpage independently, but it doesn't seem to work. Now you're asking then why...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: on demand paging (in WebFOCUS/FOCUS Forum on Focal Point ) by Kerry
CAR BY COUNTRY WHERE COUNTRY EQ 'ENGLAND' ON TABLE PCHOLD FORMAT PDF OPEN END -RUN SET FOCFIRSTPAGE ... END -RUN SET FOCFIRSTPAGE=&FOCNEXTPAGE TABLE FILE CAR PRINT CAR BY COUNTRY PAGE-BREAK WHERE COUNTRY...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 2 3  

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders