page then post to a 2nd page. In this second page is the code to
create the report. The output of the page when it is complete should
open the report(in excel or snapshot) and then close the page.
From the prompt page the post looks like this:
<FORM NAME='frmReport pr' method=POST
action=\aspobje cts\ReportPrevi ew.asp target='_blank' >
the ReportPreview page looks like this:
<%
'DECLARTION OF VARIABLES
......
Set oReport = CreateObject("G PReport.clsRepo rt")
'SUBMITT THE REQUEST TO THE REPORT QUEUE SERVER
If ( oReport.Request Report(Cstr(str ReportQueueServ er),
CStr(strReportT ype), Cstr(strWebGrou pName), CStr(strInputFi leName),
CStr(strReportN ame), CStr(strSQL), Cstr(strAppName ), 180)= True) then
'IF THE REQUEST WAS SUBMITTED SUCCESSFULLY, CHECK TO SEE WHAT TYPE OF
REPORT YOU ARE
filepath = replace(oReport .ReportName, "\", "\\")
%>
<script language="javas cript">
window.setInter val(self.close, 2000);
var shell=new ActiveXObject(" WScript.Shell") ;
cmdpath = "\"<%= filepath %>\" "
//alert(cmdpath)
shell.Run(cmdpa th,1);
//alert('Closing the Window');
window.setInter val(self.close, 2000);
</script>
<%
Else
The report runs fine, and opens in snapshot or excel. However I am
left with a blank page in a new instance of the browser. On some
computers the new browsers closes????????
Any ideas?????
Thanks