Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] URL Images not displaying in PDF reports
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] URL Images not displaying in PDF reports
 Login/Join
 
Member
posted
I am using the following code

SET PAGE-NUM=OFF
DEFINE FILE CAR
IMAGE/A300= "'';
END

TABLE FILE CAR
PRINT
COUNTRY
IMAGE
ON TABLE PCHOLD FORMAT PDF
END

URL IMAGE link in define field will be like this:
http://upload.wikimedia.org/wi...on_builders_logo.gif

When i use output format as "HTML" i am able to see the images in html output. But if i change the output format to PDF, URL values are displayed in pdf outputs instead of images.

Note: Image url value are a separate define field. So i need to print it as like a column.


Please help me how to get the image in PDF output.

Thanks in advance

This message has been edited. Last edited by: Kerry,
 
Posts: 7 | Registered: August 22, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
Read the documentation:

Creating Reports With WebFOCUS Language > Laying Out the Report Page > Adding an Image to a Report > Add an Image to a PDF, PS, or HTML Report With Internal Cascading Style Sheet


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Francis,

As of my understanding,In the link you provided has the 2 methods:
1) how to embed image from URL into HEADING/FOOTING of report.
TYPE={REPORT|heading}, IMAGE={url|file|(column)} [,BY=byfield]
[,POSITION=([+|-]x [+|-]y )] [,SIZE=(w h)] [,PRESERVERATIO={ON|OFF}],$

2) how to embed BLOB image field into report.
TYPE=DATA, COLUMN=imagefield, IMAGE=(imagefield), SIZE=(w h),
[PRESERVERATIO={ON|OFF},] $

My scenario is: I get URL value from one real field.
I need to display the images using the URL values in PDF.

Original Table data
-------------------
Sno Image-URL
--------------
1 urlvalue1
2 urlvalue2
3 urlvalue3


In PDF output it should be like
-------------------------------
Sno Images
--------------
1 Image1
2 Image2
3 Image3

Image1,2 and 3 are images in pdf.

If there is any other option, can you please suggest me .....


Selva

This message has been edited. Last edited by: selva ganapathy,
 
Posts: 7 | Registered: August 22, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
Images in PDF must be available as a file to the WebFOCUS server.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Here's a possible solution, found by doing a Search in FocalPoint:

Image in row of a PDF report


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
Are the images local or accessible to WebFOCUS ?

i.e. Not a url.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
I had the same problem with a self-service app. In my environment, I determined that images for HTML output must reside on the Web Server and images for PDF output must reside on the Reporting Server.


WF Client 7.6.10 on Solaris
WF Reporting Server 7.6.10 on AIX


WebFOCUS Client 7.6.11 on Sun Solaris
WebFOCUS Reporting Server 7.6.11 on AIX
DataMigrator 7.6.11 on AIX
WebFOCUS 8.0.05 on Windows Server
All output formats
 
Posts: 4 | Location: United States | In FOCUS since 1989 | Registered: March 10, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
Here is something that I have been playing with for a while.

If the images are on a webserver not accessible directly, and not behind a proxy server, this may help.

-SET &Conf = FGETENV(7,'EDACONF',80,'A80') ;
-SET &Conf = TRUNCATE(&Conf) ;
-SET &TmpDir = TEMPPATH(80,'A80') ;
-SET &TmpDir = TRUNCATE(&TmpDir) ;

FILEDEF CALL DISK call.ftm

-RUN

-SET &Img_Name = '{image name}' ;

-WRITE CALL BEGIN
-WRITE CALL  HOST = {webserver}
-WRITE CALL  PORT = {port number}
-WRITE CALL  REQUEST_METHOD = GET
-WRITE CALL  URI = {web alias}&Img_Name
-WRITE CALL  EXCLUDE=ON
-WRITE CALL END
-WRITE CALL BEGIN
-WRITE CALL CONTENT=data
-WRITE CALL END

-RUN
! type call.ftm
! attrib +r call.ftm
! dir
! &Conf.EVAL\bin\interp.bat -httptst &TmpDir..call.ftm
-RUN
! attrib -r call.ftm

! rename call.hto &Img_Name

! dir
-RUN

DEFINE FILE CAR
 LOGO/A20 = '&Img_Name' ;
END
TABLE FILE CAR
HEADING
" "
PRINT COUNTRY
      LOGO 
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
-*TYPE=REPORT, IMAGE=&Img_Name, $
TYPE=DATA, COLUMN=N2, IMAGE=(LOGO),$
ENDSTYLE
END


Its convoluted, but will pull an image from a web location and write it in the temp directory.

This is definitely not what interp was intended to be used for !



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6104 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] URL Images not displaying in PDF reports

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.