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     [CLOSED] Controlling the timing of message output

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Controlling the timing of message output
 Login/Join
 
JohnB
Platinum Member
posted
I have a focexec that run a set of reports. This focexec is run via a launch page that supplies the parameters to the set of reports which produce an Excel Compound report. There is a frame in the launch page where output can be displayed. The output I want displayed would provide info as each report is being processed. The code is shown below. What happens is the messages are all displayed after the last focexec has finished executing. How can I get each message to display when each focexec executes?


  

-HTMLFORM BEGIN
<p>
    <font color="navy">
        Starting processing of Empdata Report  (report 1 of 7)...
    </font>
</p>

-HTMLFORM END
-RUN
-SET &ECHO=ALL;
-INCLUDE REPORT_1
-RUN


-HTMLFORM BEGIN
<p>
    <font color="navy">
        Finished processing of Empdata Report.
    </font>
</p>

<br />
    <div style="WIDTH: 290px; FONT-SIZE: 1pt; background-color:purple; POSITION: absolute; LEFT: 120px"" ></div>
<br />
<br />

<p>
    <font color="navy">
        Starting processing of Car Report  (report 2 of 7)...
    </font>
</p>
-HTMLFORM END

-INCLUDE REPORT_2
-RUN

-HTMLFORM BEGIN
<p>
    <font color="navy">
        Finished processing of Car Report.
    </font>
</p>

<br />
    <div style="WIDTH: 290px; FONT-SIZE: 1pt; background-color:purple; POSITION: absolute; LEFT: 120px"" ></div>
<br />
<br />

<p>
    <font color="navy">
        Starting processing of Training Report  (report 3 of 7)...
</p>
-HTMLFORM END
 .
 .
 .


Thank you,

John

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


WF 7.7.03, Windows 7, HTML, Excel, PDF
 
Posts: 225 | Location: San Francisco Bay Area, California | Registered: October 26, 2006Report This Post
Computix
Silver Member
posted Hide Post
AS far as I know, you cannot do that in WebFocus.
The resulting output is generated and sent back to the browser at the end of the processing.

You would have to do that at the client. You could use Javascript in order to request each report and collect the timing information.


WF 7.6.6 (MRE,BID, DevStudio, partly RC) on Windows 2003 /Apache/Tomcat
Output: HTML,Excel,PDF,PPT
Adapters: SQL Server, DB2, Oracle
 
Posts: 38 | Location: Austria, Linz | Registered: June 19, 2009Report This Post
<JG>
posted
Computix, your first statement is correct,however the idea of using JavaScript will not work.

Because WebFOCUS closes the session every time it returns something to the browser there is no
guarantee that you will connect to the same agent, in any case it will have deleted the work files
and previous parts of the compound Excel document being created.

Using the cache will not work because even though that will allow you to keep any work files
the Excel component will not be kept.

Additionally resubmitting using an onLoad event will refresh the frame so any messages will disappear.
 
Report This Post
Computix
Silver Member
posted Hide Post
JG, thats right. It will be almost impossible to do that with compound reports.

Though you might be able to export all the HOLD-Files to a physical directory (APP HOLD and APP HOLDMAST afaik) and use them again in the following request.

What I had in mind was not a form using submit but an XMLhttp-Request-Object. It allows you to call a URL from Javascript without submitting or refreshing.

But the question remains wether it is worth the effort or not. ;-)


WF 7.6.6 (MRE,BID, DevStudio, partly RC) on Windows 2003 /Apache/Tomcat
Output: HTML,Excel,PDF,PPT
Adapters: SQL Server, DB2, Oracle
 
Posts: 38 | Location: Austria, Linz | Registered: June 19, 2009Report 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     [CLOSED] Controlling the timing of message output

Copyright © 1996-2020 Information Builders