Help! Slow in posting parameters into web-based reports

[cheerfulskeptic]

Hello,
I'm using Crystal 7 in a web deployment. The actual crystal report within CR7 shows up in 20 seconds. We have a subreport within a group, which displays diff data for each group values.
I'm connecting via Pervasive SQL inthe subreport and SQL Server in the main report (3 tables in main, and 1 table in the subreport). I used recrystallize to generate the ASP pages for web deployment. We are using 2 parameters, and when we run the report through the recrystallized pages, it takes a full minute for the page with the crystal viewer to show up (ie, a fullminute to post the parameters to the ASP page that calls the report), and then another additional 20 seconds fo rhte report to show up inside the activex viewer.
Does anyone have any suggestions why this is so slow? its vry frustrating, because these reports being used on an on-demand basis, and there's high demand!
Thanks!

 

[pgtek]

hi
Usualy if the report is slow it a link problem.
check you links and if possible create a view to group your tables this will help alot in the time.
I had the same problem with Ingress database
1 report would take over 2 minutes to run on the web from ingress
and only 5 seconds when call from SQL database

hope this help

cheers



pgtek