 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point [PAINFULLY SOLVED] Images in TABHEADINGs for PDFs
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [PAINFULLY SOLVED] Images in TABHEADINGs for PDFs Read-Only TopicGo | Search | Notify | Tools |
| [PAINFULLY SOLVED] Images in TABHEADINGs for PDFs | Login/Join |
| Master |
I'm getting an error when I try to use the following, saying the image doesn't exist. TYPE=TABHEADING,
IMAGE=/ibi_apps/ibi_html/ls_logo.gif,
POSITION=(+0.000000 +0.000000),
SIZE=(1.000000 0.40000), $However, if I take the image path and go directly to it, it works fine.. http://localhost:8080/ibi_apps/ibi_html/ls_logo.gif Looks like the server is translating the path into the following which fails: http://localhost:8080/ibi_apps/WFServlet?IBIMR_drill=IBFS,runItem,/ibi_apps/ibi_html/ls_logo.gif,true What am I missing?This message has been edited. Last edited by: GavinL,  - FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server | ||
|
| Expert |
Images referenced in WebFOCUS style commands are usually located on the reporting server, not the web server. TYPE=REPORT,
IMAGE=baseapp/help.jpg,
POSITION=(+1.000000 -0.000000),
$
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 | |||
|
| Expert |
Well, oddly enough, when it's an HTML report my code works, but when I switch to PDF I get an "IMAGE FILE NOT FOUND" error! This works for HTML but doesn't work for PDF: TYPE=REPORT,
IMAGE=baseapp/help.jpg,
POSITION=(+1.000000 +0.000000),
$ But this works for both HTML and PDF: TYPE=REPORT,
IMAGE=help.jpg,
POSITION=(+1.000000 +0.000000),
$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 | |||
|
| Master |
Where did you have the image located? I tried same location as the fex, the ibi_html folder, and off the root reporting server with no luck. - FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server | |||
|
| Expert |
The fex is not in the ibi_html folder. That's a web server alias. It is possible the web server alias points to a physical folder that's on the reporting server... baseapp is the default reporting server app folder: drive:\ibi\apps\baseapp 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 | |||
|
| Master |
I can't put the fex in that folder.. This is client level reporting. Humm.. - FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server | |||
|
| Expert |
May I ask with what URL do you run the fex that is referenced in ibi_html? 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 | |||
|
| Expert |
Your fex could also be located in the Repository... 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 | |||
|
| Master |
None, I read in the help example, the image could be there. Help On Image image Specifies the file name of a graphical image file. The image must exist as a separate graphic file in a format that your browser supports. Most browsers support GIF and JPEG file types. You can specify a local image file, or identify an image elsewhere on the network using a URL. URLs can be absolute, such as, http://www.ibi.com/graphic.gif, or relative alias that can be identified to the application server or web server, such as, /ibi_apps/ibi_html/ibi_logo.gif . - FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server | |||
|
| Master |
Yea, I tried using /public_folder/ls_logo.gif, which is public_folder is one of our folders on the reporting server and that didn't work either. I'm starting to think this is a configuration issue. - FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server | |||
|
| Expert |
I'll tell you one thing: the rules don't apply for PDF formats. Here's a simple question for IBI'ers Tamra and Emily (or any other IBI'er that feels like piping in): Please explain why the all-GUI generated code below does not work when the &WFFMT parameter is set to PDF? The fex and image are in the same Repository folder. -DEFAULT &WFFMT='PDF';
TABLE FILE CAR
SUM
CAR.BODY.SALES
BY LOWEST CAR.ORIGIN.COUNTRY
HEADING
" "
" "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<PDF,PDF>,<Excel 2007,XLSX>,<Excel 2000,EXL2K>,<Excel 2007 Formula,XLSX FORMULA>,<Excel 2000 Formula,EXL2K FORMULA>,<HTML Active Report,AHTML>,<Active Report for Adobe Flash Player,FLEX>,<Active Report for PDF,APDF>,<PowerPoint,PPT>).Select type of display output.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=HEADING,
IMAGE=IBFS:/WFC/Repository/Test/FrancisMariani/ib_logo.gif,
POSITION=(+0.000000 +0.000000),
$
ENDSTYLE
END
It shows the image when &WFFMT is HTML, but throws an error when the value is PDF. 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 | |||
|
| Master |
Yea, IBFS:/WFC/Repository/ve/PropertyLienAlert/ls_logo.gif works in HTML..  - FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server | |||
|
| Expert |
With PDF, the images must be on the reporting server. With HTML they are a web reference and need to be available via the web server. This makes it interesting, especially if you have your client installation on a different server to your reporting server installation. Repository files are the exception as they are available both ways. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Master |
Well, I tried: TYPE=TABHEADING, IMAGE=IBFS:/EDA/EDASERVE/public_folder/ls_logo.gif, $ That didn't work: 0 ERROR AT OR NEAR LINE 21 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC253) INVALID FORMAT SPECIFICATION ON LEFT HAND SIDE: A80000V 0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1 0 ERROR AT OR NEAR LINE 96 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC3251) IMAGE FILE UNREADABLE OR INVALID: ls_logo.gif (RC=103) 0 ERROR AT OR NEAR LINE 96 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC3251) IMAGE FILE UNREADABLE OR INVALID: ls_logo.gif (FOC3298) ERROR FOUND IN A COMPOUND REPORT Compound Report is TERMINATING..... - FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server | |||
|
| Master |
I converted the GIF to JPG and it now works..  Welcome To Focus! - FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server | |||
|
| Expert |
That shouldn't be happening. 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 | |||
|
| Master |
I agree. I protest that solution. App Studio WebFOCUS 8.1.05M Windows, All Outputs | |||
|
| Master |
I totally agree, but I've recreated the GIF thinking it might have something corrupt in it and it still errors for GIFs, but works with JPGs. Doesn't work for PNGs either. Same error.  - FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server | |||
|
| Expert |
Kind of surprised - we use .gif in PDF format, it is located within the Domain calling the fex: TYPE=REPORT, IMAGE=fordham.gif, POSITION=(5.50 0.30), SIZE=(2.25 .55),$  Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Master |
I cannot get this to work in App Studio -- at all. But it works for HTML and AHTML formats if I run the fex from the WebFOCUS web interface. My test PNG image appears, no problem.  App Studio WebFOCUS 8.1.05M Windows, All Outputs | |||
|
| Master |
Well, this seems to be all over the place. Possibly configuration then or browser being used. I'm using Chrome. - FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server | |||
|
| Master |
I'm using Chrome as well, Version 50.0.2661.94 m. When App Studio launches Chrome, the image does not appear. Here is the image html it generates: <IMG SRC="data:image/png;base64," style='position:absolute;top:0pt;left:0pt;'> From the WebFOCUS web interface -- where the image does show -- I see this: <IMG SRC="/ibi_apps/WFServlet?IBIMR_drill=IBFS,runItem,IBFS:/WFC/Repository/balanced_scorecard/Common/webimages/green-button-small.png,true" style='position:absolute;top:0pt;left:0pt;'> App Studio WebFOCUS 8.1.05M Windows, All Outputs | |||
|
| Expert |
There's one or more bug involved - I can smell it/them... 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 | |||
|
| Master |
It's odd how it only does it if it's not a JPG and launching from AS. I'm pretty sure you almost have to code that bug on purpose.  - FOCUS Man, just FOCUS! ----------------------------- Product: WebFOCUS Version: 8.1.04 Server: Windows 2008 Server | |||
|
| Expert |
According to the WebFOCUS v8.0.08 documentation, GIF is the only valid format for PDF: Creating Reports With Report Painter > Styling Reports With Report Painter > Adding an Image
And no Excel format is mentioned here... 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 | |||
|
| Master |
This is an "inline" image... there should be base64 encoded data describing the image in this html tag: <IMG SRC="data:image/png;base64," style='position:absolute;top:0pt;left:0pt;'> But it's missing in action. It should look more like this: <IMG SRC="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIA..." style='position:absolute;top:0pt;left:0pt;'> App Studio WebFOCUS 8.1.05M Windows, All Outputs | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [PAINFULLY SOLVED] Images in TABHEADINGs for PDFs
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [PAINFULLY SOLVED] Images in TABHEADINGs for PDFsCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |