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     Save a graph as image and then display.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Save a graph as image and then display.
 Login/Join
 
Cyril Joy
Platinum Member
posted
Hello friends,

When I save a graph as GIF/JPEG and then try to display the same in html/excel, its is not displaying the image.(Saving is working fine). When i type the url for the image, it is displayed but opening as an applet. I doubt this is why it is not displayed when i call the image through fex.

FILEDEF G2 DISK E:\wwwroot\test\G2.GIF

GRAPH FILE TEST
SUM CNT.PROJECT AS PROJECT
ACROSS REGION
ON GRAPH SET LOOKGRAPH PIE
ON GRAPH SAVE AS G2 FORMAT GIF
END

TABLE FILE TEST
PRINT PROJECT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, IMAGE=http://<SERVERNAME>/test/G2.GIF, POSITION=(4 0), SIZE=(5 3), $
ENDSTYLE
ON TABLE PCHOLD FORMAT HTML
END

-EXIT

I want the image to be displayed in the Html/Excel.
Please anyone let me know what mistake I am doing.
 
Posts: 143 | Location: Rochester,NY. | Registered: August 20, 2004Report This Post
<WFUser>
posted
Should work. What release are your running? Make sure you delete the gif and the first part of your request is actually running sucessfully.
 
Report This Post
susannah
Expert
posted Hide Post
Cyril, there's a thread #1055 above yours that addresses the same thing. "Adding Image to HTML report". Your syntax, with type=report, works for pdf output.
For web output, you define a text field
that is a long character string containing the URL of the image. Then put that text element whereever you want it in your report, making sure that your webserver (e.g. IIS) can find the image file.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
<WFUser>
posted
Susannah,

I wan't sure either, but I tested this code in 5.3 and it works in HTML.
 
Report This Post
susannah
Expert
posted Hide Post
ah! good to know
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Cyril Joy
Platinum Member
posted Hide Post
I am using WebFOCUS 521 Server. The image can be displayed well as the report output if i use an existing gif/jpeg/jpg image. For example using the following command.

TYPE=REPORT, IMAGE=http://<SERVERNAME>/test/logo.GIF, POSITION=(4 0), SIZE=(5 3), $

The problem comes only if i first save a graph file as an image and then try to display that image. The no-image icon will be displayed as the output. But when I right click on the icon and see the properties, it is showing the correct path.(If I use this path in browser, image will be displayed but opened as a java applet even after saving as jpeg or gif)
 
Posts: 143 | Location: Rochester,NY. | Registered: August 20, 2004Report This Post
susannah
Expert
posted Hide Post
Cyril, are you running in MRE or in self-serv?
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Cyril Joy
Platinum Member
posted Hide Post
I am not running in MRE. I have the WebFOCUS 521 Server and running the fex files using it. To be frank, I just not used that product yet.
 
Posts: 143 | Location: Rochester,NY. | Registered: August 20, 2004Report This Post
<Kalyan>
posted
Cyril ,
I have not tried what you are doing exactly. But I did create graphical reports. I also faced the problem of the graph loading as applet. Found that using
SET GRAPHEDIT =SERVER

solved the problem.

Dont know if this would help you..

Kalyan.
 
Report This Post
Cyril Joy
Platinum Member
posted Hide Post
No kalyan, the image is not getting displayed. Also the image is still opening as an applet.Below is the code I am using.

FILEDEF G2 DISK E:\wwwroot\user\G2.GIF

SET SQLENGINE=SQLORA
SQL SQLORA
SELECT * FROM &USER.TEST_GRAPH&DSN
;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS T_GTEST FORMAT ALPHA
END
-RUN

SET GRAPHEDIT =SERVER

GRAPH FILE T_GTEST
SUM CNT.PROJECT AS PROJECT
ACROSS REGION
ON GRAPH SET LOOKGRAPH PIE
ON GRAPH SAVE AS G2 FORMAT GIF
END

TABLE FILE T_GTEST
PRINT PROJECT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, IMAGE=http://server/user/G2.GIF, POSITION=(4 0), SIZE=(5 3), $
ENDSTYLE
ON TABLE PCHOLD FORMAT HTML
END

-EXIT
 
Posts: 143 | Location: Rochester,NY. | Registered: August 20, 2004Report This Post
Prarie
Virtuoso
posted Hide Post
Did this ever get resolved? I'm having the same problem...5.3.2 Developer Studio.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
<Thiru>
posted
Check with the access permissions on that folder in the server. The folder where you save the GIF files should have the RW access and should be in the application path.
 
Report This Post
<mbroxter>
posted
I experienced this same issue in 5.2.3 a few months ago with self-service reports. The problem ended up being that Java WebStart was locking up on the Reporting Server, thus the image was not being created nor was an error being returned. The HTML reports were also showing the correct path, but an empty image.

If you have access to the Reporting Server, start Java Webstart from the desktop to see if it starts OK. My problem ended up being that Java and the video card had a conflict.
 
Report 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     Save a graph as image and then display.

Copyright © 1996-2020 Information Builders