Report Hangs through ASP ??

[AndyNova]

I am using ASP to call a report that is based on a Stored Procedure, using CR8 and SQL 2000/IIS5.

All reports will run fine then one will be selected from the ASP page and the report simply hangs. The ActiveX viewer does not even appear.

It hangs on this line of code, when it is trying to open the report.

Set session("oRpt&quot = session("oApp&quot.OpenReport(basePath & "myreport.rpt", 1)

All the reports hang and the only way to get them back up and working is to reboot the web server. Once that is done they all work well again for a while then the problem occurs again.

Any suggestions ? Thanks

 

[kkashwani]

Try this code hope it will work

basePath = Request.ServerVariables("APPL_PHYSICAL_PATH" ) & "\myreport.rpt"

Set session("oRpt&quot = session("oApp&quot.OpenReport(basePath, 1)