Focal Point
can not get gif images to display
May 08, 2007, 12:31 PM
Jessica Bottonecan not get gif images to display
I just converted from WebFocus 5.3 to 7.1.4 and the gif images in my report no longer display. I get red x's. I believe I simply do not have the path to the image designated correctly since the image is in the folder indicated in the path name and the gif's are not corrupted. I searched Focal Point and found several cases about getting gif images into reports and tried all sorts of variations on getting the path name right, but to no avail. I created a sample of the code using the CAR file and it shows the last thing I tried. And in case you're curious, what I had before that worked looked like this: RED_UP/A80='
';
And approot was ibi/apps.
Thanks much!
SET PAGE-NUM=NOLEAD
SET NODATA=''
DEFINE FILE CAR
RED_UP/A80='
';
GREEN_DOWN/A80='
';
QUESTION/A80='?';
END
TABLE FILE CAR
SUM DEALER_COST
COMPUTE IMAGE/A120=IF DEALER_COST GT 10000
THEN RED_UP
ELSE IF DEALER_COST LT 10000
THEN GREEN_DOWN
ELSE QUESTION; AS ''
BY COUNTRY
BY CAR
END
Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
May 08, 2007, 12:49 PM
Jessica BottoneThe code I included is appearing to show Red x's to be in my forum post too. So I'll try to show you the code in sections:
The first part is the same for what I had and what I last tried:
RED_UP/A80='<
then img
then src=
I had used to have after the equal sign was this:
/approot/Cubes/RED_UP.GIF>';
And the last thing I tried was this:
"http:\\localhost\ibi\apps\Cubes\RED_UP.GIF" >';
Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
May 08, 2007, 12:52 PM
Francis MarianiJessica,
Please put your program code between code tags:
[code]
program code
[/code]
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
May 08, 2007, 12:55 PM
Jessica BottoneOh, thank you! I was trying to figure out how to show the code and not have the red x's display. So let's try this again.
What I had that used to work:
RED_UP/A80='<img src=/approot/Cubes/RED_UP.GIF>';
And what I last tried:
SET PAGE-NUM=NOLEAD
SET NODATA=''
DEFINE FILE CAR
RED_UP/A80='<img src="http:\\localhost\ibi\apps\Cubes\RED_UP.GIF" >';
GREEN_DOWN/A80='<img src="http:\\localhost\ibi\apps\Cubes\GREEN_DOWN.GIF" >';
QUESTION/A80='?';
END
TABLE FILE CAR
SUM DEALER_COST
COMPUTE IMAGE/A120=IF DEALER_COST GT 10000 THEN RED_UP
ELSE IF DEALER_COST LT 10000 THEN GREEN_DOWN
ELSE QUESTION; AS ''
BY COUNTRY
BY CAR
END
Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
May 08, 2007, 12:56 PM
Francis MarianiThe usual way to address an image in an app folder would be to use '/approot/Cubes/RED_UP.GIF'.
When you run the HTML report and get the red X, right click on it to view the image properties to check if the URL has been formed properly. The clue may be in there.
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
May 08, 2007, 01:00 PM
Francis MarianiThis works for me:
TABLE FILE CAR
PRINT
COMPUTE TEST/A100= '<IMG src=/approot/basel/bmo_fn_gp.gif>';
COUNTRY
end
When I right-click on the image and view Properties, I see
http://ocdt70070610:8080/approot/basel/bmo_fn_gp.gif.
Verify that the case is correct for the path name and the image name.
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
May 08, 2007, 01:09 PM
Jessica BottoneGot it.. would you believe it was the difference between GIF and gif? Apparently now it's case sensitive. Thank you.
Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
May 08, 2007, 01:45 PM
Francis MarianiI don't think it's WebFOCUS, you may be using a new or updated web server which may require case-sensitive URLs.
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
May 08, 2007, 02:00 PM
mgrackinJessica,
The Microsoft platform does not usually care about upper and lower case. However, unix based OS are case sensitive.
Please update your signature file to reflect your platform and WebFOCUS version.
Thanks!
Mickey
| FOCUS/WebFOCUS 1990 - 2011 |
May 09, 2007, 09:23 AM
Jessica BottoneIn this case, it's WF 7.1.4 on Windows XP Pro with IIS (don't know which version), and I too did not think case should make a difference and in this case it did. I put in my first entry for this post that I'd upgraded from WF 5.3 to 7.1.4 but did not include the platform. My apologies. I'd intentionally not updated my profile because my circumstances vary depending on the client I'm working for at the time. So that's what I put in my profile and will make sure I include all pertient info when I post in the future.
Thanks to all.
Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
May 09, 2007, 10:12 AM
Francis MarianiMickey,
If the web server is Apache Tomcat, even though it may be running on a Windoze machine, it is case-sensitive - therefore it's a good idea to respect case for folders/files on any platform, just as a precaution.
Cheers.
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