OpenReport Method Very Slow

[swreng]

Hello to everyone,

I don't know if this the right forum about my problem:

I have an application in vb6 and i am using Crystal Report Viewer for printing purposes in my appl.

I made some reports in CR 9 and i execute them from my appl with the OpenReport method.
When do that it needs about 30-45 seconds to run the report, but if i run the report via Crystal Reports IDE it needs only 5 seconds.
My db is Sql Server 2005 , any ideas?

Thank you very much.

 

[Madawc]

Try

http://www.tek-tips.com/threadminder.cfm?pid=768

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[swreng]

Thanks for the reply my friend, i have already found the solution to my problem and i will post it here:

When you have a report which contains subreports then the options "On Demand Report" and "Re-Import" must be unchecked, else the dll of runtime is trying to find the specific path of the subreport and causes delay while trying to retrieve subreport.