Hello,
I am using an asp script that uses rptserver.asp to display some
reports over http. It worked fine previously but now the webpages with
the report display just hang. I tried switching from the activex viewer
to java viewer and still the same. I don't know what changed, except I
do the Windows updates. Can anyone tell me the best way to trouble ASP
problems. The page just stays blank forever and that status bar slowly
progresses. No errors in the event log on the server. The HTTPerr log
has the following errors:
2006-09-14 19:13:14 x.x.x.133 30531 x.x.x.5 80 HTTP/1.1 GET
/webreport/reports.asp?Report=Project%20List%20Detailed%20w%2 0Client(P).rpt
- 1 Connection_Dropped ReportsPool
No entries for this in the W3SVC log.
This started hanging my other web app on the server, until I put it in
a separate Application pool.
Here is the reports.asp code:
<%@ LANGUAGE="VBSCRIPT" %>
<%
'================================================= ======================
' WORKING WITH THE REPORT DESIGNER COMPONENT AND ASP TO PREVIEW A
REPORT
'================================================= ======================
'
' CONCEPT
'
' ALWAYS REQUIRED STEPS (contained in AlwaysRequiredSteps.asp)
' - create the application object
' - create the report object
' - open the report
'
' MORE ALWAYS REQUIRED STEPS (contained in MoreRequiredSteps.asp)
' - retreive the records
' - create the page engine
'
' DISPLAY THE REPORT
' - display the report using a smart viewer
'================================================= =================
%>
<%
' This line creates a string variable called reportname that we will
use to pass
' the Crystal Report filename (.rpt file) to the OpenReport method
contained in
' the AlwaysRequiredSteps.asp.
reportname = Trim(Request("Report"))
%>
<%
'================================================= =================
' ALWAYS REQUIRED STEPS
'
' Include the file AlwaysRequiredSteps.asp which contains the code
' for steps:
' - create the application object
' - create the report object
' - open the report
'================================================= =================
%>
<!-- #include file="AlwaysRequiredSteps.asp" -->
<%
'================================================= =================
'
' MORE ALWAYS REQUIRED STEPS
'
' Include the file MoreRequiredSteps.asp which contains the code
' for the steps:
' - retreive the records
' - create the page engine
' - create the smart viewer and point it to rptserver.asp
'
'================================================= =================
%>
<!-- #include file="MoreRequiredSteps.asp" -->
<%
' INSTANTIATE THE REPORT VIEWER
'
'When using the Crystal Reports in an ASP environment, we use
'the same page-on-demand Report Viewers used with the Crystal Web
Component Server.
'There are six Report Viewers:
'
%>
<!-- #include file="SmartViewerActiveX.asp" -->
The other scritps are not modified from the crystal example.
Thank you,
