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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     can not get gif images to display

Read-Only Read-Only Topic
Go
Search
Notify
Tools
can not get gif images to display
 Login/Join
 
Jessica Bottone
Platinum Member
posted
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
 
Posts: 126 | Registered: January 18, 2007Report This Post
Jessica Bottone
Platinum Member
posted Hide Post
The 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
 
Posts: 126 | Registered: January 18, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
Jessica,

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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Jessica Bottone
Platinum Member
posted Hide Post
Oh, 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
 
Posts: 126 | Registered: January 18, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
The 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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
This 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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Jessica Bottone
Platinum Member
posted Hide Post
Got 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
 
Posts: 126 | Registered: January 18, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
I 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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
mgrackin
Virtuoso
posted Hide Post
Jessica,

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
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Jessica Bottone
Platinum Member
posted Hide Post
In 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
 
Posts: 126 | Registered: January 18, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
Mickey,

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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 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     can not get gif images to display

Copyright © 1996-2020 Information Builders