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     [CLOSED] Issue with Subfoot

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Issue with Subfoot
 Login/Join
 
Sandhya j
Gold member
posted
Hi,

I have report similar to the one below. Second line in subfoot is not at printing on page2 and showing blank box. Please experts help me.

Execute the below report you will see the issue Iam talking about.
Thank You


DEFINE FILE CAR
sample1/A200 ='MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 ';
sample2/A200 ='MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 ';
END

TABLE FILE CAR
PRINT
'CAR.BODY.BODYTYPE' NOPRINT
BY 'CAR.BODY.SEATS' NOPRINT PAGE-BREAK


ON CAR.BODY.SEATS SUBHEAD
"<10> "<10>

HEADING
""
FOOTING
""

ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $

TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=8, LEFTMARGIN=0.50, RIGHTMARGIN=0.50,$

TYPE=SUBHEAD,GRID=ON, WRAP=0.5, $
TYPE=SUBHEAD,LINE=2, COLOR='RED', $

ENDSTYLE

END

This message has been edited. Last edited by: <Kathryn Henning>,


WEBFOCUS 8202/Windows
PDF/HTML/XML
 
Posts: 53 | Registered: December 06, 2011Report This Post
njsden
Virtuoso
posted Hide Post
Please post your sample code inside of CODE tags.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Sandhya j
Gold member
posted Hide Post
 DEFINE FILE CAR
sample1/A200 ='MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 ';
sample2/A200 ='MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST8 MY SAMPLE TEST9 MY SAMPLE TEST10 ';
END

TABLE FILE CAR
PRINT
'CAR.BODY.BODYTYPE' NOPRINT
BY 'CAR.BODY.SEATS' NOPRINT PAGE-BREAK


ON CAR.BODY.SEATS SUBHEAD
"<10> sample1"
"<10> sample2"

HEADING
""
FOOTING
""

ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $

TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=8, LEFTMARGIN=0.50, RIGHTMARGIN=0.50,$

TYPE=SUBHEAD,GRID=ON, WRAP=0.5, $ 
TYPE=SUBHEAD,LINE=2, COLOR='RED', $

ENDSTYLE

END
 
Posts: 53 | Registered: December 06, 2011Report This Post
RSquared
Guru
posted Hide Post
try it this way
 
DEFINE FILE CAR
sample1/A200 ='MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 MY SAMPLE TEST1 ';
sample2/A200 ='MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST2 MY SAMPLE TEST8 MY SAMPLE TEST9 MY SAMPLE TEST10 ';
END

TABLE FILE CAR
PRINT
'CAR.BODY.BODYTYPE' NOPRINT
BY 'CAR.BODY.SEATS' NOPRINT PAGE-BREAK


ON CAR.BODY.SEATS SUBHEAD
"<10> <sample1"
"<10> <sample2"

HEADING
""
FOOTING
""

ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $

TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=8, LEFTMARGIN=0.50, RIGHTMARGIN=0.50,$

TYPE=SUBHEAD,GRID=ON, WRAP=0.5, $ 
TYPE=SUBHEAD,LINE=2, COLOR='RED', $

ENDSTYLE

END


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
Sandhya j
Gold member
posted Hide Post
Hi RSquared,

I don't see any updates in the code. Could you please post your changes again?

Thank You
 
Posts: 53 | Registered: December 06, 2011Report This Post
RSquared
Guru
posted Hide Post
quote:
"<10> sample1"
"<10> sample2"

the change is to
quote:

"<10> "<10>


You need to add the "<" in front of your defined fields on the Sub-head line. This tells WebFOCUS to insert the values in the field.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
RSquared
Guru
posted Hide Post
quote:
"<10> "<10>



sorry my copy / paste did not work before.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
RSquared
Guru
posted Hide Post
"<10> "<10>
this is what it should be


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
RSquared
Guru
posted Hide Post
"<10> "<10>

WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
Sandhya j
Gold member
posted Hide Post
Hi RSquared,

Actually < was there, when I copy paste it it got missed.

With < only it is not working properly. Can you try running the code in your studio?
Problem is second in my subfoot not completely shown on second page, it just showing the blank lines.

Thank You for helping me.


WEBFOCUS 8202/Windows
PDF/HTML/XML
 
Posts: 53 | Registered: December 06, 2011Report This Post
RSquared
Guru
posted Hide Post
i got 2 pages because of the WRAP=0.5. The length of the sub-header cause it to print over multiple lines


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
Sandhya j
Gold member
posted Hide Post
I created that way to come in 2 pages, because in my original scenario I have move fileds which has lenght on 1000 bytes.

Do you get text displayed on second page? or you are getting blank box?
 
Posts: 53 | Registered: December 06, 2011Report This Post
RSquared
Guru
posted Hide Post
I am getting text on the second page. I get
'MY
SAMPLE
TEST20'


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
Sandhya j
Gold member
posted Hide Post
Hi,

It seems your version is 7.6.11, mine is 7.6.4. Do you think that makes difference?

Thank You
 
Posts: 53 | Registered: December 06, 2011Report This Post
RSquared
Guru
posted Hide Post
i ran the code in 5.3.7 and I got all of the sub-header on each page.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
njsden
Virtuoso
posted Hide Post
Have you tried using SET PRINTPLUS = ON to see if it helps?


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Sandhya j
Gold member
posted Hide Post
I just tried the printplus option, but still no luck.

Is there any way to put the screen shot here with the issue?

Thank You
 
Posts: 53 | Registered: December 06, 2011Report This Post
Sandhya j
Gold member
posted Hide Post
quote:
Originally posted by RSquared:
i ran the code in 5.3.7 and I got all of the sub-header on each page.


It's good to hear but for me no luck.
 
Posts: 53 | Registered: December 06, 2011Report This Post
njsden
Virtuoso
posted Hide Post
Yup! Just capture your screen, save the relevant piece in a .png file, upload it at www.tinypic.com and and finally post the URL they provide you.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report 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     [CLOSED] Issue with Subfoot

Copyright © 1996-2020 Information Builders