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     Display of HTML Graphs in Reportcaster's ReportLibrary

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Display of HTML Graphs in Reportcaster's ReportLibrary
 Login/Join
 
Master
posted
Hi

I have a procedure that works fine generating a html web page as output.

Here are the on graph commands

ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRWIDTH 0
ON GRAPH PCHOLD FORMAT PNG

Yet when I move this into reportcaster with output options as HTML held in reportlibrary the report appears as HTML with place markers where the graphs should be.

Once you view the source you see that you get an applet with a set of parameters that would allow the graph to be reconstructed by the APPLET.

APPLET id="graph" name=graph codebase=/ibi_html/javaassist archive=IBITDGChartApplet.jar code=ServerSidePngGraph.class width=760 height=400 alt=""

However I do not have GRAPHEDIT=OFF or ON coded in my procedure and it seems as if the action of running under RCASTER has put the setting to GRAPHEDIT=OFF where a "Java Rendered Graph" is returned.

Does anyone out there have any suggestions.

Regards

John



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
Expert
posted Hide Post
John,

When you get an HTML report from Report Caster the file references are localised to where you open it from. e.g. they could be referencing your "temporary internet files" folder on the recipient's local machine.

The important bit here is the "codebase" parameter in the APPLET object. If you were to amend this to contain the full path to where the IBITDGChartApplet.jar resides, save it and reopen the saved version, it would probably work OK.

I would always recommend sending graphical output from Report Caster in PDF format because all graphical elements (logos, graphs etc.) are included in the PDF stream before it is sent to the email recipient.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
Oops, forgot to mention the one exception to the PDF streaming of graphics.

When you output an active report (which is HTML) the images contained within it are "bit streamed" within the Scripting. So, as these exist within the file there are no problems seeing them in the output as they require no external references.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Master
posted Hide Post
Tony

First of all Thank you for your help.

The URL I use to reference the reportcaster output is:

http://chaos/rcaster/library/report?id=R11r66ur4t3&version=4

Using the codebase url

/ibi_html/javaassist

Since a relative URL that begins with / (a slash) always replaces the entire pathname of the base URL the equivalent absolute URL is given by

http://chaos/ibi_html/javaassist

Now in the client settings I get:

IBI_HTML_DIR = &IBI_DOCUMENT_ROOT/ibi_html
IBI_DOCUMENT_ROOT = C:/ibi/WebFOCUS71

This suggests that IIS will convert the URL to
directory

C:/ibi/WebFOCUS71 + /ibi_html + /javaassist

And I checked this does contain the referenced .JAR.

I did try saving the page as you say changing the rel URL to the full spec, but that did not work presumably for this reason.

Hope you've got another avenue up your sleeve.

Regards

John



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
Master
posted Hide Post
Tony

Tried putting

SET GRAPPLETONLY=ON
ON GRAPH SET GRAPHEDIT OFF

Now it works and it changed the URL for the applet.

APPLET id="graph" name=graph codebase=/ibi_html/javaassist archive=IBINewTDGChartApplet.jar,threed.jar,ibi_log4j_1.2.8.jar code=IBINewTDGChartApplet.class width=760 height=400

Anyone out there with a good explanation?

John

PS It also mulches the caption on the X axis when I do this but that's the least of my worries.



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
Expert
posted Hide Post
Hi John,

The first thing I notice is that the URL references report library, is that right?
If so then I'm afraid I have no answer for you as I have not used Report Library and therefore am not sure how it functions.

I suppose one possibility is to try playing with the GRAPHSERVURL setting? I think that there is also a setting for using the OLD or NEW graphing engine but cannot find reference to that at the moment. I'm sure someone will have it to hand though.

Good luck

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Expert
posted Hide Post
John,

It would appear that we were responding at the same time, although your response is good news!!

The archive value has changed to using the NEW engine (see my last suggestion) instead of the OLD and that is probably the important thing.

As for munching your titles etc. then I would advise the use of the java set syntax instead of letting WF do it for you. To get a good start, run the report as is and grab the java code from the source. Add it into your existing code between ON GRAPH SET GRAPHSTYLE * and ENDSTYLE, then look out the Graphing Manual for your release. Invaluable to have by your side or else ask the Forums graphing wizard JG.Wink

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Master
posted Hide Post
Thanks Tony again

I'm guessing report library forces client side graphics in HTML so that it does not have to keep track of the server generated png files.

Strangely the mulching of my titles has disappeared once the initial download of Java applet has occurred! I think it might have been trying some too clever async processing during the download.

Great stuff!



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report 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     Display of HTML Graphs in Reportcaster's ReportLibrary

Copyright © 1996-2020 Information Builders