Focal Point
[CLOSED] Issue with Subfoot

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8967096436

November 14, 2013, 04:28 PM
Sandhya j
[CLOSED] Issue with Subfoot
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
November 14, 2013, 05:16 PM
njsden
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.
November 14, 2013, 08:40 PM
Sandhya j
 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

November 15, 2013, 08:08 AM
RSquared
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
November 15, 2013, 10:10 AM
Sandhya j
Hi RSquared,

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

Thank You
November 15, 2013, 10:48 AM
RSquared
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
November 15, 2013, 10:49 AM
RSquared
quote:
"<10> "<10>



sorry my copy / paste did not work before.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
November 15, 2013, 10:50 AM
RSquared
"<10> "<10>
this is what it should be


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
November 15, 2013, 10:51 AM
RSquared
"<10> "<10>


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
November 15, 2013, 12:40 PM
Sandhya j
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
November 15, 2013, 01:17 PM
RSquared
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
November 15, 2013, 02:04 PM
Sandhya j
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?
November 15, 2013, 02:19 PM
RSquared
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
November 15, 2013, 04:19 PM
Sandhya j
Hi,

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

Thank You
November 18, 2013, 01:47 PM
RSquared
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
November 18, 2013, 02:48 PM
njsden
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.
November 18, 2013, 03:38 PM
Sandhya j
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
November 18, 2013, 03:40 PM
Sandhya j
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.
November 19, 2013, 09:23 AM
njsden
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.