SQL\Crystal Report 8.0

[ismail4]

Hello,

I have ERP system running on my server with crystal report 8.0, and reports sometimes takes long time to populate and sometimes takes short time.

Can anyone please explain this and possible solutions?

Regards

Ismail

 

[onpnt]

far to many variables that could cause long load times. does the same report show these load times with a simply query behind it?


____________ signature below ______________
General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[ismail4]

What i also observe is that the delay is always at the clients computer end not the server.

Please i need advice on what to do.

Thanks

 

[onpnt]

you didn't answer my question.

what are you viewing the reports with? is there version issues?
what client configuration exists?
are firewalls/filters applied on the network?
have you checked the sql logs and processes to see run times (profiler/process info)?
and on....

what have you done already to trouble shoot this problem??? As I said, there are hundreds of variables at play

with the details you've provided there is no answer you will get unless it is a guess and somehow is the correct answer to your setup


____________ signature below ______________
General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[ismail4]

Hello,

Sorry for the delay in response,

I am using crystal report 8.0

The Application Server is hosting the database as well as the exe's and the client computers make odbc connection to the server.

I also have Watchguard firebox 700 on my network.

regards