Auto-refresh report

March 25, 2008, 09:59 AM

Rob

Auto-refresh report

I'm relatively new to WF and am trying to create a report that will auto-refresh the content after a pre-determined interval. I can use in HTML or can use a Javascript snippet of code to do the same. Outside of WF, it works. Embedding either pieces of code in a WF HTML doc doesn't. I get "No query information to decode." when it refreshes. Any suggestions?

March 25, 2008, 10:22 AM

Francis Mariani

Here's a WebFOCUS program that refreshes every two seconds:

TABLE FILE CAR
SUM
SALES
BY COUNTRY
HEADING
"CAR REFRESH TEST"
"AT &TOD"
ON TABLE HOLD AS H001 FORMAT HTMTABLE
END
-RUN

-HTMLFORM BEGIN
<html>
<head>
<script language="JavaScript">
function doReload()
{
setTimeout( "location.reload(true);", 2*1000 );
}
</script>
</head>

<body onLoad="doReload();">
!IBI.FIL.H001;
</body>
</html>
-HTMLFORM END

I call it with this URL:

http://server-name/ibi_apps/WFServlet?&IBIF_ex=fmreload1

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

March 25, 2008, 11:01 AM

Rob

Thanks. Let me give that a shot. It looks similar to the code I tried using javascript:
<script language="JavaScript">
< !--
var time = null
function move() {
window.location.Reload
}
//-->

I'll post whether it works or not. Thanks again.

March 25, 2008, 02:44 PM

Rob

Francis,
It worked like a champ. Thanks!! I used this code:

END
-RUN
-HTMLFORM BEGIN
<html>
<head>
<META HTTP-EQUIV=REFRESH CONTENT=10;URL="http://myserver/ibi_apps/WFServlet?IBIF_ex=xyz">
</head>
<body >
</body>
</html>
-HTMLFORM END

at the end of the FOCEXEC stmts. One anomaly-I couldn't use the name that WebFOCUS created when the .fex file was created. I had to change it from z04r1hvi.fex to xyz.fex (just to get it to work) and figure out through trial and effort the directory in which I had to copy the .fex file. I really appreciate your assistance on this.

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

March 25, 2008, 03:32 PM

Francis Mariani

Rob,

Please edit your previous message and put your code between

[code]

[/code]

tags - the posting is actually performing the refresh!

Are you using MRE?

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