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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] WebFocus Report That Can Refresh Itself?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] WebFocus Report That Can Refresh Itself?
 Login/Join
 
Gold member
posted
Hi,
We have a business requirement that if we have a WebFocus report showing on the screen, can we add some javascript code in it for e.g. to make it refresh itself every minute?
The user would use a html page to input the report criteria and the report would show on the screen and the user wants to know if it can refresh itself every few minutes so they can see the latest data from the database?
Can this be done by javascript or something else?
We haven't coded anyhting yet but just thinking if this is possible.
Thanks in advance.

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


WF V7.7.03
Platform: AIX 6.1 64-bit, WinXP, IE 8.0
Output Formats: Html, Pdf, Excel
 
Posts: 71 | Registered: October 16, 2006Report This Post
Gold member
posted Hide Post
I think I may hav efound something already after doing a search on the site. I will take a look at the usggestions put forward by Francis Mariani.


WF V7.7.03
Platform: AIX 6.1 64-bit, WinXP, IE 8.0
Output Formats: Html, Pdf, Excel
 
Posts: 71 | Registered: October 16, 2006Report This Post
Platinum Member
posted Hide Post
Yep - you can do this with javascript. I've done it for "alert" windows that autorefresh at specific time intervals. I've never done it in an MRE environment though.


prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9
 
Posts: 242 | Location: Minneapolis | Registered: February 16, 2006Report This Post
Gold member
posted Hide Post
Thanks, Norb. I will read up on it in the admin's manual that Francis Mariani suggested. Regards.


WF V7.7.03
Platform: AIX 6.1 64-bit, WinXP, IE 8.0
Output Formats: Html, Pdf, Excel
 
Posts: 71 | Registered: October 16, 2006Report This Post
Silver Member
posted Hide Post
Hi,

it should be sufficient to include somethings like this:
  
<script type="text/javascript">
setInterval("window.location.reload()",60000);
</script>


The way to include this, depends, how you create the final report.

If you use HTMLFORM you can include it there directly, otherwise you could include the script in a Title for a column.

regards,
Markus


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
Gold member
posted Hide Post
Thank you , Markus. I will pass it on to our developer. I managed to get the simple script from Francis Mariani to work in our MRE. Once we have mroe requirements we will do some more. Thanks again.


WF V7.7.03
Platform: AIX 6.1 64-bit, WinXP, IE 8.0
Output Formats: Html, Pdf, Excel
 
Posts: 71 | Registered: October 16, 2006Report This Post
Silver Member
posted Hide Post
In HTML only, I have had plenty of luck by adding this bit of code to the end of my report. Content=10 is the refesh rate in seconds.

-RUN                                                     
-HTMLFORM BEGIN                                          
<html>                                                   
<head>                                                   
<META HTTP-EQUIV=REFRESH CONTENT=10;                     
</head>                                                  
<body >                                                  
</body>                                                  
</html>                                                  
-HTMLFORM END                                            


WebFocus 7.7.03 - 7703_hotfix - Gen: 284
Dev Studio 7.7.03 - Gen: 06062011
Mainframe Focus 7.7.03
Windows WF Client Server
zOS Reporting server (hub-sub config)
Windows Reporting server
Windows RC Client Server
 
Posts: 30 | Location: Portland, Oregon, USA | Registered: September 11, 2009Report This Post
Gold member
posted Hide Post
Thank you, j42p11.


WF V7.7.03
Platform: AIX 6.1 64-bit, WinXP, IE 8.0
Output Formats: Html, Pdf, Excel
 
Posts: 71 | Registered: October 16, 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     [SOLVED] WebFocus Report That Can Refresh Itself?

Copyright © 1996-2020 Information Builders