TIME DELAY WAITING FOR REPORT!

[johnvai]

I have a VB program with sybase database and crystal 8. the problem is that the reports are waiting too much time to be shown when they are asked (30 seconds on Pentium IV), unlike reports that has no parameters which need almost 2 seconds.
Can someone help me?

 

[synapsevampire]

Are you trying to say that you've a VB process which runs both parameterized and non-parameterized reports, but the ones with parameters are taking longer?

Generally the problem with this is that the record selection formula isn't being passed to the database.

Constructing a proper record selection formula is key, and I've a FAQ on this topic here:

faq767-3825

Another factor is whether you're just passing parameters, or whether you're directly modifying the record selection formula.

-k