Crystal Report ,Asp and Progress Database

lsuresh_76

New Member
This mail is regarding some issues while using crystal report 8 in
ASP, to display reports from progress database. We used Merant ODBC
progress driver to connect the progress DB running in Unix server.The sql
query uses multiple databases and in turn it returns or looks huge no of
data to generate the output. If I am executing the query directly from
crystal report then it takes 5 to 20 mins. But output is coming at last.

The issue comes,when I am calling same report in ASP, it takes a lot (
5 mins to 10 mins) to process the data and then its showing the "Page
can not be displayed". After doing a detail study about it, we found
that when the crystal report component reading the records, internally its
stopping all the IIS services (including FTP/Admin also). The server
where it runs, is a high configured system. We have enough virtual memory
to process high end applications.

Just to inform you that the above query takes few input
parameter(selection ranges). If the ranges are less then some time it is able display
the ouput, but in case i give little big range, it stops the web
services and displays "Page can not be displayed".

We need some kind of input from you regarding where its going wrong,
as I have checked all system related possibilities which can throw this
kind of error.
 
Top