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%20Client(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,

On 14 Sep 2006 13:15:48 -0700, pmkconsult***@gmx.net wrote:

Show quoteHide quoteWhat data connection is being used?
Try Installing CR designer on the web server and try the report(s) from there..You could be facing a timeout if the
report returns data slowly..
Check the query the report creates directly against the datasource..see how long it runs..

How to break up binaryWrite file into multiple chunks
random record with SELECT TOP does NOT work
FORM and javascript.location
how to choose a random record from a database
Server.Transfer and Load Balanced Environments