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     Displaying graph in a Report which is in EXL2K format

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Displaying graph in a Report which is in EXL2K format
 Login/Join
 
Deepthi
Member
posted
I want a report to be displayed with a graph below it, that is on the same page. The report formats can be HTML, PDF or EXL2K . Currently its working for HTML and PDF but I am not able to get the graph displayed in the EXL2K format of the report. I have also tried saving the graph in the APPROOT and fetching it . But its not working. The report gets displayed in Excel format but the graph image is not identified in the given APPROOT path. Is there any other way to do this? Please help me with this issue.

This message has been edited. Last edited by: Deepthi,


Deepthi Unnikrishnan
 
Posts: 3 | Registered: May 11, 2006Report This Post
<sandy_16>
posted
That was intresting posting.I tried you were right it is not displaying in the excel format,let me know if you crack it anytime

Regards
sandeep
 
Report This Post
Francis Mariani
Expert
posted Hide Post
Here's an example that works in WebFOCUS 5.3.2:
-* excel report and graph

-SET &ECHO=ALL;

SET PAGE-NUM=OFF
-RUN

-SET &TEMPDIR = TEMPPATH(80,'A80');
-SET &GIFFILE = &TEMPDIR || 'GRAPH1.GIF';

GRAPH FILE CAR
SUM SALES
BY COUNTRY
ON TABLE HOLD AS GRAPH1 FORMAT GIF
END
-RUN

DEFINE FILE CAR
IMGRAPH1/A150 WITH CAR='<img src="&GIFFILE">';
END
-RUN

TABLE FILE CAR
HEADING
"Sales Report"
" "
FOOTING
"<IMGRAPH1"
SUM SALES BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Sales', $
ENDSTYLE
END
-RUN


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
Deepthi
Member
posted Hide Post
Hi Francis,

Thanks for your help. But the code is not working on WebFocus 7.1 version, and that's what i want. The report gets displayed in Excel format , but it if not identifying the image file from the path. TEMPPATH does not work here. Any way thanks for the response. Do let me know if you come accross some other option.


Deepthi Unnikrishnan
 
Posts: 3 | Registered: May 11, 2006Report This Post
Deepthi
Member
posted Hide Post
Hi Francis
What does this TEMPPATH do?. Which path does it point to and do we have to set the TEMPPATH anywhere else? Please clarify my doubts.


Deepthi Unnikrishnan
 
Posts: 3 | Registered: May 11, 2006Report This Post
Francis Mariani
Expert
posted Hide Post
Please see http://techsupport.informationbuilders.com/known_problems/20412051.html for a possible fix to a problem with TEMPPATH.

And this on how to use it: http://techsupport.informationbuilders.com/sps/31751122.html

From http://documentation.informationbuilders.com/masterinde..._spr_713/05stp16.htm
quote:
TEMPPATH outlength,outfield - Retrieves the physical directory name of the current agent process.


Since all fexes run on the WebFOCUS Server in an individual "agent", all the temporary files generated by the fex are stored in the agent's directoy. I need to know the exact location of the agent's directory so I can build the complete image URL (<img src="&GIFFILE">), TEMPDIR gives me the directory.

Run the following:
-SET &ARGLEN = ARGLEN(120,TEMPPATH(120,'A120'),'I2')+1;
-SET &TP    = TEMPPATH( &ARGLEN, 'A&ARGLEN.EVAL');
-TYPE LENGTH=&ARGLEN , TEMPPATH=&TP

you should get something similar to this:
LENGTH=35 , TEMPPATH=C:\ibi\srv53\wfs\edatemp\ts000010\


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     Displaying graph in a Report which is in EXL2K format

Copyright © 1996-2020 Information Builders