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 Page break issue

Read-Only Read-Only Topic
Go
Search
Notify
Tools
PDF Page break issue
 Login/Join
 
Ranjana
Member
posted
HI,

I require a PDF report with my Heading and the column headers appearing with change in every by field value.

TABLE FILE CAR
PRINT
CAR
MODEL
BY COUNTRY NOPRINT PAGE-BREAK
HEADING
"COUNTRY: ON TABLE PCHOLD FORMAT PDF
END

I am not able to print the different countries to one page.
I have seen many threads with the same concern but didnt find any answers,
Can anyone help me with the work around?

Thanks!
Rj


7.1.4
Windows XP
Excel, HTML, PDF



 
Posts: 26 | Registered: February 21, 2008Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Ranjana,

Could you please post your example again, enclosing it in CODE /CODE tags (you click on the right-most icon in the "Reply" window.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Ranjana
Member
posted Hide Post
Thanks, hope this displays my heading

TABLE FILE CAR
PRINT
CAR
MODEL
BY CAR NOSPLIT
BY COUNTRY NOPRINT PAGE-BREAK
HEADING
 "COUNTRY: <COUNTRY"

ON TABLE PCHOLD FORMAT PDF
END]
I am not able to print the different countries to one page.
I have seen many threads with the same concern but didnt find any answers,
Can anyone help me with the work around?

This message has been edited. Last edited by: Ranjana,


7.1.4
Windows XP
Excel, HTML, PDF



 
Posts: 26 | Registered: February 21, 2008Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Ranjana,

You are saying that you want all your countries on the same page but in your code you write
  
BY COUNTRY NOPRINT PAGE-BREAK


If you use this construct then each country will appear on a page of its own.
If you do not use PAGE-BREAK then the HEADING and the column titles will appear only on top.

So if you want all your countries on the same page and the values of COUNTRY as a type of heading and then having column headings appear, you should use SUBHEAD (and SUBFOOT for clarity). See the code:
  
-* File ranjana2.fex
TABLE FILE CAR
PRINT
     CAR AS ''
     MODEL AS ''
-* AS '' will prevent WF from printing titles
BY COUNTRY NOPRINT 

-* SUBHEAD will display both country and your titles
ON COUNTRY SUBHEAD
"COUNTRY: <COUNTRY "
" "
"CAR <+0>MODEL "
"--- <+0>----- "

-* SUBFOOT for clarity
ON COUNTRY SUBFOOT
"</1 "
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='COURIER NEW',
     SIZE=10,
$

-* This styling aligns your titles with the data
TYPE=SUBHEAD,
     BY=1,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     POSITION='N2',
$
TYPE=SUBHEAD,
     BY=1,
     LINE=3,
     OBJECT=TEXT,
     ITEM=2,
     POSITION='N3',
$
TYPE=SUBHEAD,
     BY=1,
     LINE=4,
     OBJECT=TEXT,
     ITEM=1,
     POSITION='N2',
$
TYPE=SUBHEAD,
     BY=1,
     LINE=4,
     OBJECT=TEXT,
     ITEM=2,
     POSITION='N3',
$
ENDSTYLE
END

Is this what you wanted?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Ranjana
Member
posted Hide Post
thanks Daniel for your suggestion... that works!!!


7.1.4
Windows XP
Excel, HTML, PDF



 
Posts: 26 | Registered: February 21, 2008Report This Post
focuzsambit
Platinum Member
posted Hide Post
wat abt putting a small loop and printing within that loop... Idea


WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI
 
Posts: 133 | Registered: May 12, 2007Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Loop? Nice joke! Back to COBOL...


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
focuzsambit
Platinum Member
posted Hide Post
if you wish you can and if you wish alternatively, i don't have any idea....


WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI
 
Posts: 133 | Registered: May 12, 2007Report This Post
Leah
Virtuoso
posted Hide Post
If you want the heading to contain the by field information on all by fields, and not just the most current on the page, then you have to do your page break on the lowest by field. Which could result in a lot of pages, or you might look into subheads.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report 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 Page break issue

Copyright © 1996-2020 Information Builders