[SOLVED] WebFocus Report That Can Refresh Itself?

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9247070206

April 13, 2011, 12:48 PM

Adrian Wong

[SOLVED] WebFocus Report That Can Refresh Itself?

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,

April 13, 2011, 01:00 PM

Adrian Wong

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.

April 13, 2011, 01:44 PM

Norb Eckert

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.

April 13, 2011, 02:04 PM

Adrian Wong

Thanks, Norb. I will read up on it in the admin's manual that Francis Mariani suggested. Regards.

April 18, 2011, 05:06 AM

Computix

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

April 18, 2011, 09:37 AM

Adrian Wong

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.

April 18, 2011, 10:02 AM

j42p11

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