Focal Point
PDF: Image in Heading and space between Heading and Title
August 15, 2012, 11:31 AM
Francis MarianiPDF: Image in Heading and space between Heading and Title
For PDF reports, if I have an image in the HEADING and also HEADING text lines, I have to add some blank lines at the top of the heading ("8") to make sure that the text does not overlay the image. Am I missing something or shouldn't I expect the text to automatically be shifted down?
Also, How do I reduce the space between the last heading text line and the Column Tile line? Is this another of those never been solved issues?
Thanks,
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 15, 2012, 11:51 AM
rfbowleyMaybe the best thing IBI has given us to handle pdf formated reports is the composer.
Put your image in one spot, Heading text that does not change in a text field, and a report with no HEADING in another, and then move them around to increase / reduce the space between each to your hearts content.
Such as:
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^1', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.707 2.190), DIMENSION=(7.292 3.850), METADATA='Z-INDEX: 100; LEFT: 0.707in; OVERFLOW: auto; WIDTH: 7.292in; POSITION: absolute; TOP: 2.19in; HEIGHT: 3.85in', $
OBJECT=IMAGE, NAME='image1', IMAGE=logo.jpg, POSITION=(0.729 0.625), DIMENSION=(2.604 0.969), METADATA='Z-INDEX: 101; LEFT: 0.729in; WIDTH: 2.604in; POSITION: absolute; TOP: 0.625in; HEIGHT: 0.969in', $
OBJECT=STRING, NAME='text1', TEXT='<font face="ARIAL" size=10>Heading Text goes in here</font>', POSITION=(0.729 1.667), MARKUP=ON, WRAP=ON, DIMENSION=(7.083 0.417), METADATA='', $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE bobbowle/app/car_test.fex
COMPOUND END
At one client we even used this to position the "borders" when they did not like pdf's redition of same. I believe you had another topic in this forum on the bizarre behavior of borders in pdf. I spent several WEEKS getting those lines to make PERFECT corners, but it got done.
Robert F. Bowley Jr.
Owner
TaRa Solutions, LLC
In WebFOCUS since 2001
August 15, 2012, 12:29 PM
Francis MarianiRobert,
Thanks for this - I'll keep this for reference. I was hoping I didn't have to resort to the Composer, but I suppose I should become more ambidextrous.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 15, 2012, 12:32 PM
J TABLE FILE CAR
PRINT
CAR.CARREC.MODEL
HEADING
"<CAR.ORIGIN.COUNTRY <+0>"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=DATA,
TOPGAP=0.000000,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
BACKCOLOR=RGB(205 205 205),
BOTTOMGAP=0.000000,
$
ENDSTYLE
END
With the use of topgap and bottom gap you won't. Also, the <+0> symbol separates items in the header. Especially useful with variables in the header.
WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
August 15, 2012, 02:26 PM
MAdams1This is how we do it. Haven't had any problems
TYPE=REPORT,
IMAGE=inside-top-logo.jpg,
POSITION=(0.50000 0.25),
SIZE = (3.0625 0.50),
ALT='KVCC Logo',
$
WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
August 15, 2012, 02:54 PM
Francis MarianiTYPE=HEADING, IMAGE=(IMG), POSITION=(0 -0.75), SIZE=(10.5 2), PRESERVERATIO=ON, $
Maybe using "REPORT" instead of HEADING makes a difference. For some reason I have to use a negative vertical position.
I'll test this soon.
I'd rather not change the TOPGAP in the DATA and the BOTTOMGAP in the HEADING as this affects all lines - I'd like to only do this for the last line of the heading and the first line of the data.
Thanks,
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 15, 2012, 03:01 PM
MAdams1Yes, REPORT will assign the image to the location you specify on the report but not in the Heading. It will look like it is in the heading though.
WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
August 15, 2012, 03:06 PM
Francis MarianiAnd the HEADING lines start after the bottom of the image?
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 15, 2012, 03:17 PM
MAdams1No the image actually sits behind the heading.
I wish I knew how to post a screen shot here, I would send you one.
WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
August 15, 2012, 03:30 PM
Tom FlynnClick on the link above, Forum Rules, and search for "Post an Image"...
Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
August 15, 2012, 04:12 PM
MAdams1
WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
August 15, 2012, 04:13 PM
MAdams1 http://tinypic.com/r/7klk/6
WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
August 15, 2012, 04:16 PM
MAdams1Well, not really what I wanted. I have seen others post their screen shot directly into the Focal Point post. At least you can see how the image assigned to the REPORT sits on the page with a header. And it depends on your position settings, you can move that image anywhere on the page. Hope it helps.
WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
August 15, 2012, 06:05 PM
Francis MarianiTinyPic provides code for the image location which should work in FocalPoint, note that it's not the URL to the page:
[IMG]http://i49.tinypic.com/7klk.jpg[/IMG]
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 15, 2012, 06:12 PM
Francis MarianiAn image based on a report column cannot be used in a REPORT image
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 16, 2012, 08:08 AM
MAdams1quote:
An image based on a report column
What do you mean? How are you doing this?
The optimist in me says there has to be a way to do this
WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
August 16, 2012, 08:14 AM
MAdams1quote:
Originally posted by Francis Mariani:
TinyPic provides code for the image location which should work in FocalPoint, note that it's not the URL to the page:
[IMG]http://i49.tinypic.com/7klk.jpg[/IMG]
Thank you for this!!
WebFOCUS Server 8.1.05
Windows 2008 Server
WebFOCUS AppStudio 8.1.05
Windows 7 Professional
IE 11 and Chrome Version 43.0.2357.124 m.
Mostly HTML, PDF, Excel, and AHTML
August 16, 2012, 03:02 PM
DougFrancis, Can you demo this using the CAR file?
I just had to ask
| In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |