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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you have any questions or need access: Contact myibi@ibi.com


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Problem with the look of the PDF Report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Problem with the look of the PDF Report
 Login/Join
 
Platinum Member
posted
Why when I have compounded pages of different reports some of the pages look like if the text is shifted slightly down. For example:

If I have a table with 2 rows and 2 columns, the text is supposed to appear in the cell... but sometime i see the text in the cell, but practically sitting on the cell's bottom line.

Does this make sense? Why does this happen? Is there someway to fix/prevent this from happening?

Any ideas?
 
Posts: 178 | Registered: May 11, 2005Report This Post
Guru
posted Hide Post
Can you post your code? Can you make it happen using the CAR table? What version of WF are you using?

I would be really interest to see this since our reports are normally all PDF.
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report This Post
Platinum Member
posted Hide Post
I don't think I can make it happen using the car file, but I will see what I can do.

I am using WF Verion 5.2.6 (as well as 5.3). It happens in both.

I will see what I can do about getting code to you.

Thanks so much.
 
Posts: 178 | Registered: May 11, 2005Report This Post
Guru
posted Hide Post
Cool, if you can get it happening on the CAR table I will test it on WF 7.1 and see if the problem is fixed there.
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report This Post
Platinum Member
posted Hide Post
Okay, this didn't quite do what
was happening to me (since my r
eports are approx. 50 pages long
and it happens randomly).
BUT you can see that the words
look like they are higher in the
cell than in the following tables (when you
run it), than in the first table.
It looks as if the data/words are
shifted and the table stays in the
same area.

The ouput is like the table top
line and then the word starting practically on the line. Let me know what you think. Thank you
DEFINE FILE CAR
NUM/A50=IF
SEATS EQ 4 THEN CAR;
NUM2/A50=IF SEATS EQ 2 THEN CAR;
CONCAT/A101=NUM || ( ' ' | NUM2 );

COMPARE/A50=IF NUM EQ NUM2
THEN BODYTYPE ELSE ' ';
END
TABLE FILE CAR
HEADING
"Car Report"
"As of &DATEtMDYY <+0>"
"4 Seater vs 2 Seater"
PRINT NUM AS '4 SEATER'
NUM2 AS '2 SEATER'
BODYTYPE AS 'BODY'

BY CAR AS 'CAR'
ON TABLE
SET PAGE-NUM OFF
ON TABLE
NOTOTAL
ON TABLE PCHOLD FORMAT
PDF OPEN NOBREAK
ON TABLE SET
HTMLCSS ON
ON TABLE SET STYLE
UNITS=IN,

PAGESIZE='SCREEN',
LEFTMARGIN=0.15,

RIGHTMARGIN=0.15,

TOPMARGIN=0.10,

BOTTOMMARGIN=0.10,

SQUEEZE=ON,
O
RIENTATION=PORTRAIT,
$
TYPE=REPORT,GRID=ON,FONT='ARIAL',
SIZE=10,
COLOR='BLACK',BACKCOLOR='NONE',STYLE=
NORMAL,RIGHTGAP=0.125000,TOPGAP=0.013889,
BOTTOMGAP=0.027778,$
STYLE=NORMAL,$
TYPE=HEADING,LINE=1,GRID=OFF,SIZE=20,
STYLE=NORMAL,JUSTIFY=CENTER,$
TYPE=HEADING,LINE=2,GRID=OFF,
SIZE=14,STYLE=NORMAL,JUSTIFY=
CENTER,$
TYPE=HEADING,LINE=4,GRID=OFF,
SIZE=16,STYLE=NORMAL,$
TYPE=TITLE,STYLE=BOLD,SIZE=12,$
ENDSTYLE
END
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL

DEALER_COST

RETAIL_COST
WHERE
( COUNTRY EQ 'USA' )
ON TABLE HOLD AS CAR1
END
-TYPE LINE = &LINES
-TYPE RECORDS= &RECORDS

-IF &LINES
EQ 0 THEN GOTO OUT_NO ELSE GOTO
OUT_YES;

-OUT_YES
TABLE FILE CAR
HEADING
"USA Manufactured Cars"
PRINT
MODEL AS 'Model
RETAIL_COST AS 'Retail Cost''
DEALER_COST AS 'Dealer Cost
BY CAR AS 'Car'
ON TABLE SET
PAGE-NUM OFF
ON TABLE NOTOTA
ON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE
UNITS=IN,PAGESIZE='SCREEN',
LEFTMARGIN=0.15,
RIGHTMARGIN=0.15,TOPMARGIN=0.10,
BOTTOMMARGIN=0.10,SQUEEZE=ON,
ORIENTATION=PORTRAIT,$
TYPE=REPORT,GRID=ON,FONT='ARIAL',
SIZE=10,COLOR='BLACK',
BACKCOLOR='NONE',STYLE=NORMAL,
RIGHTGAP=0.125000,TOPGAP=0.013889,
BOTTOMGAP=0.027778,$
TYPE=HEADING,GRID=OFF,SIZE=16,
STYLE=NORMAL,$
TYPE=TITLE,STYLE=BOLD,SIZE=12,$
ENDSTYLE
END

-OUT_NO
DEFINE FILE CAR
OUT_FIELD/A2000
WITH CAR = 'Not Applicable';
END TABLE FILE CAR
HEADING
USA Manufactured Cars"
PRINT OUT_FIELD AS ' '
WHERE
RECORDLIMIT EQ 1
ON TABLE
SET PAGE-NUM OFF
ON TABLE
NOTOTAL
ON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE
UNITS=IN,PAGESIZE='SCREEN',
LEFTMARGIN=0.15,
RIGHTMARGIN=0.15,
TOPMARGIN=0.10,
BOTTOMMARGIN=0.10,
SQUEEZE=ON,

ORIENTATION=PORTRAIT,
TYPE=REPORT,GRID=OFF,FONT='ARIAL',
SIZE=10,COLOR='BLACK',BACKCOLOR='
NONE',STYLE=NORMAL,RIGHTGAP=0.125000,
TOPGAP=0.013889,BOTTOMGAP=0.027778,$
TYPE=HEADING,GRID=OFF,SIZE=16,STYLE=
NORMAL,$
TYPE=TITLE,STYLE=BOLD,SIZE=12,$
>ENDSTYLE
END
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
DEALER_COST RETAIL_COST
WHERE ( COUNTRY EQ 'JAPAN' );
ON TABLE HOLD AS CAR2
END

-TYPE LINE
= &LINES
TYPE RECORDS= &RECORDS
IF &LINES EQ 0 THEN GOTO NO_JAPAN
ELSE GOTO OUT_JAPAN;
-OUT_JAPAN
TABLE FILE CAR
HEADING
"Japan Manufactured
Cars"
" "
PRINT
MODEL AS 'Model'
RETAIL_COST
AS 'Retail Cost''
DEALER_COST
AS 'Dealer Cost'
BY CAR AS 'Car'
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD
FORMAT PDF NOBREAK
ON TABLE
SET HTMLCSS ON
ON TABLE SET
STYLE *
UNITS=IN,PAGESIZE='SCREEN',
LEFTMARGIN=0.15,RIGHTMARGIN=0.15,
TOPMARGIN=0.10,BOTTOMMARGIN=0.10,
SQUEEZE=ON,ORIENTATION=PORTRAIT,$
TYPE=REPORT,GRID=ON,FONT='ARIAL',
SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',
STYLE=NORMAL,RIGHTGAP=0.125000,
TOPGAP=0.013889,BOTTOMGAP=0.027778,
/>TYPE=HEADING,GRID=OFF,SIZE=16,
STYLE=NORMAL,$
TYPE=TITLE,STYLE=BOLD,SIZE=12,$
ENDSTYLE
END
-NO_JAPAN
DEFINE FILE CAR
OUT_FIELD/A2000 WITH CAR = 'Not Applicable';
END
TABLE FILE CAR
HEADING
"Japan Manufactured Cars
"
PRINT OUT_FIELD AS
WHERE RECORDLIMIT EQ 1
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE
PCHOLD FORMAT PDF NOBREAK
>ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE UNITS=IN, PAGESIZE='SCREEN',
LEFTMARGIN=0.15,
RIGHTMARGIN=0.15,
TOPMARGIN=0.10,
BOTTOMMARGIN=0.10,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',
STYLE=NORMAL,RIGHTGAP=0.125000,TOPGAP
=0.013889,BOTTOMGAP=0.027778,$
NORMAL,$
ENDSTYLE


TABLE FILE CAR
PRINT

COUNTRY
CAR

MODEL
DEALER_COST
RETAIL_COST
WHERE ( COUNTRY EQ
'GERMANY' );
ON TABLE HOLD AS
CAR2
END

-TYPE LINE =
&LINES
-TYPE RECORDS= &RECORDS
-IF &LINES EQ 0 THEN GOTO
NO_GER ELSE GOTO OUT_GER;
-OUT_GER

TABLE FILE CAR
HEADING

German Manufactured Cars"
PRINT
MODEL AS 'Model'
RETAIL_COST AS 'Retail Cost''
DEALER_COST AS 'Dealer Cost'
BY CAR AS 'Car'
ON TABLE SET
PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,PAGESIZE='SCREEN',
LEFTMARGIN=0.15,RIGHTMARGIN=0.15,
TOPMARGIN=0.10,BOTTOMMARGIN=0.10,
SQUEEZE=ON,ORIENTATION=PORTRAIT,$
TYPE=REPORT,GRID=ON,FONT='ARIAL',
SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',
STYLE=NORMAL,RIGHTGAP=0.125000,TOPGAP=
0.013889,BOTTOMGAP=0.027778,$
TYPE=HEADING,GRID=OFF,SIZE=16,
STYLE=NORMAL,$
TYPE=TITLE,STYLE=BOLD,SIZE=12,$
ENDSTYLE
END
-NO_GER
DEFINE FILE CAR
OUT_FIELD/A2000
WITH CAR = 'Not Applicable';
END
ABLE FILE CAR
HEADING
German Manufactured Cars"
PRINT OUT_FIELD AS ' '
WHERE
RECORDLIMIT EQ 1
ON TABLE SET
PAGE-NUM OFF
ON TABLE NOTOTAL
ON
TABLE PCHOLD FORMAT PDF NOBREAK

ON TABLE SET HTMLCSS ON
ON TABLE
SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN', LEFTMARGIN=0.15,
RIGHTMARGIN=0.15, TOPMARGIN=0.10,
BOTTOMMARGIN=0.10 SQUEEZE=ON,
ORIENTATION=PORTRAIT,
TYPE=REPORT,GRID=OFF,FONT='ARIAL',
SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',
STYLE=NORMAL,RIGHTGAP=0.125000,TOPGAP=
0.013889,BOTTOMGAP=0.027778,$
TYPE=HEADING,GRID=OFF,SIZE=16,
STYLE=
NORMAL,$
TYPE=TITLE,STYLE=
BOLD,SIZE=12,$
ENDSTYLE
END

TABLE FILE CAR
HEADING
"Car Information"
PRINT
MODEL AS 'MODEL'
RPM AS 'RPM'

BHP AS 'BHP' FUEL_CAP AS 'Fuel
Cap'
MPG AS 'Miles Per
Gallon'

ACCEL AS 'Accelerator'
BY CAR
AS 'CAR'
ON TABLE
SET PAGE-NUM OFF
ON TABLE NOTOTAL

ON TABLE PCHOLD FORMAT PDF
NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,PAGESIZE='SCREEN',
LEFTMARGIN=0.15,RIGHTMARGIN=0.15,
TOPMARGIN=0.10,BOTTOMMARGIN=0.10
=ON,ORIENTATION=PORTRAIT,$
TYPE=REPORT,GRID=ON,FONT='ARIAL',
SIZE=10,COLOR='BLACK',BACKCOLOR='
NONE',STYLE=NORMAL,RIGHTGAP=0.125000,
TOPGAP=0.013889,BOTTOMGAP=0.027778,$
TYPE=HEADING,GRID=OFF,SIZE=16,
STYLE=NORMAL,$
TYPE=TITLE,STYLE=BOLD,SIZE=12,$ENDSTYLE
END
TABLE FILE CAR
"ADDITIONAL CAR INFORMATION/>PRINT
LENGTH
WIDTH
HEIGHT

WEIGHT
WHEELBASE
BY CAR AS 'CAR'
WHERE (LENGTH GT 180);
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,PAGESIZE='SCREEN',LEFTMARGIN
.150000,RIGHTMARGIN=0.150000,TOPMARGIN=0.100000,BOTTOMMARGIN=
0.100000,SQUEEZE=ON,ORIENTATION=
PORTRAIT,$
TYPE=REPORT,GRID=ON,FONT=
'ARIAL',SIZE=9,COLOR='BLACK',BACKCOLOR=
'NONE',STYLE=NORMAL,RIGHTGAP=0.125000,
TOPGAP=0.013889,BOTTOMGAP=0.027778,$
TYPE=TITLE,STYLE=BOLD,SIZE=12,$
TYPE=HEADING,SIZE=16,STYLE=NORMAL,GRID=OFF,$
ENDSTYLE
END

TABLE FILE CAR
PRINT
CAR
DEALER_COST
RETAIL_COST
SALES
WARRANTY
STANDARD
WHERE (DEALER_COST GT 10000 );
ON TABLE HOLD AS CAR1
END

-TYPE LINE = &LINES
-TYPE RECORDS= &RECORDS

-IF &LINES EQ 0 THEN GOTO OUT_NONE ELSE GOTO OUT_CARS;

-OUT_CARS
TABLE FILE CAR
HEADING
"Cost Information"
"Where Dealer Cost is Greater Than 40,000"
" "
PRINT
DEALER_COST AS 'DEALER,COST'
RETAIL_COST AS 'RETAIL,COST'
SALES AS 'SALES'
WARRANTY AS 'WARRANTY'
STANDARD AS 'STANDARD'
BY CAR AS 'CAR'
WHERE ( DEALER_COST GT 10000 );
ON TABLE SET NODATA ' '
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE
UNITS=IN,PAGESIZE='SCREEN',
LEFTMARGIN=0.15,RIGHTMARGIN=0.0,TOPMARGIN=
0.10,BOTTOMMARGIN=0.10,
SQUEEZE=ON,ORIENTATION=PORTRAIT,WRAP=1,$
TYPE=REPORT,GRID=ON,FONT='ARIAL',SIZE=10,COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,$
TYPE=HEADING,GRID=OFF,SIZE=16,STYLE=NORMAL,$
TYPE=TITLE,STYLE=BOLD,SIZE=12,JUSTIFY=CENTER,$
ENDSTYLE
END
-GOTO END_CAR ;

-OUT_NONE
DEFINE FILE CAR
OUT_FIELD/A2000 WITH CAR = 'Not Applicable';
END
TABLE FILE CAR
HEADING
"Cost Information"
"Where Dealer Cost is Greater Than 40,000"
" "
PRINT OUT_FIELD AS ' '
WHERE RECORDLIMIT EQ 1
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.15,
RIGHTMARGIN=0.15,
TOPMARGIN=0.10,
BOTTOMMARGIN=0.10,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,FONT='ARIAL',SIZE=10,
COLOR='BLACK',BACKCOLOR='NONE',STYLE=
NORMAL,RIGHTGAP=0.125000,TOPGAP=0.013889,
BOTTOMGAP=0.027778,$
TYPE=HEADING,GRID=OFF,SIZE=16,STYLE=
NORMAL,$
TYPE=TITLE,STYLE=BOLD,
SIZE=12,$
ENDSTYLE
END
-END_CAR

This message has been edited. Last edited by: <Mabel>,
 
Posts: 178 | Registered: May 11, 2005Report This Post
Guru
posted Hide Post
I think I see what you mean.

In the '4 Seater vs 2 Seater' report the data is at the bottom of the cell and then in all the other reports the data is at the top of cell.
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report This Post
Guru
posted Hide Post
slfmr,
I was able to get the data to be at the bottom of the cell. I did it by removing the NOBREAK which I'm guessing you want in there to make the report smaller. I will take a look at it again later to see if I can find something else that can help you.
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report This Post
Platinum Member
posted Hide Post
Correct, if you don't compound the report, and each individual report starts on a new page, then the tables look fine... it's when they are compounded. Sometime the data might even run on top of each other in extreme cases as well as run of the page and disappear.

In turn if a lot of this happens then we get that pdf corrupted error which is not fun to deal with... which I also have a question out there about.

Thanks for looking in to this.
 
Posts: 178 | Registered: May 11, 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     Problem with the look of the PDF Report

Copyright © 1996-2020 Information Builders