[Solved] Drill to 2 reports at same time

I have a drilldown that is taking a long time to run. I want to display infomation to the requestor at the "Click" time and still run the report in the background.
What I think I need to do is, drill to a fex that has embedded HTML form which has the infomation and image to be displayed. Then in javascript have an onLoad function that will run the report.

Does anyone have a sample of this or can give a sample of what they use for such a situation.

Thanks

This message has been edited. Last edited by: David Sibert,

dksib
DC Tech Services Inc
WF 8.2.1M

Posts: 117 | Location: US | Registered: February 09, 2004

susannah

Expert

posted

Hide Post

i use a redirect.
the drill runs a fex with an html with both a redirect fex and message that stays up until the redirected fex finishes.
stay tuned a minute...i'll get you some code


-*bvm_spread_op_redirect
-DEFAULT &LAUNCH = 'DEFAULT'; 
-DEFAULT &MYMEAS = 'VARIANCE';
-DEFAULT &MYYEAR= '2015'; 
 
-SET &redirectfex = 'bvm_spread_container.fex';
-HTMLFORM BEGIN
<html><title>bvm </TITLE>
<head>
<META HTTP-EQUIV="Refresh"
CONTENT="0 ;
URL=/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&|IBIC_server=EDASERVE&|IBIWF_msgviewer=OFF
&|IBIAPP_app=ec_app&|&|IBIMR_drill=X,dmmedcfr/dmmedcfr.htm
&|IBIF_ex=&redirectfex&|CLICKED_ON=&|LAUNCH=&LAUNCH&|MYMEAS=&MYMEAS&|MYYEAR=&MYYEAR"> 
</head>
   
<body   >
 
<table width="60%" align="center"  >
<tr><td style="padding-top:100">

Running Budget Spread for Year =&MYYEAR   
 
</TD></TR>
</table>
</body>
</html>
-HTMLFORM END

so my launch page runs this fex (called bvm_spread_op_redirect),
and this fex in turn redirects to whatever i've put in the variable &redirectfex, in this case something called 'bvm_spread_container.fex'.

See the CONTENT="0 ;
That says wait 0 seconds before you execute this redirect fex.
See the 'Running Budget Spread...' ?
That bit stays visible as long as it needs to, until the browser delivers the report.
You can put more parms in, display the parms selected, display the images you mention above, caution the user not to click the Run button a second time, etc.

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