Hi,When my report is accessible by multiple user it become very slow,how to speed up it,pls provide me proper solution as soon as possible

hi there..

This could be happen by a lot of things.. maybe the data you are getting is to much or hard to find. It's nearly imposible to try a solution not seeing all the aspect of this problem...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Thank for reply,

The above solution do not work for me, Pls Provide me some other solution as soon as possible, its very urgent.

Regards,
   Komal

is the free version of the crystal reports???

also you are not providing enough info to give you a better idea...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

mate it could be a hardware issue too..
because as i mentioned the occures when many users try to view the report..
try to cash the needed reports and delete what u don't need from the cash

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"

maybe the report is slow because is hard to get the data from the DB. this is a to general problem to try to fix with this little info...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

and that might be the reason too..
GIVE US SOME INFORMATION MATE :)

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"

Hi, Everyone
Thanks for reply

I am Using Crystal report XI with ASP.Net.I am populating my report using Sql Query, and my query is providing only relevent data only.
I have Observe that it might be problem of database, I am retreiving too many records from the database,but that is necessity.
Is SQL Expression can help me out. If yes Pls Provide me Information to use SQL Expression.

Regards,
    Komal.

I'll tell you what u can do.. do a trace in ur database for the slow queries.. and to make sure it's not a database problem.. try to lower down the data load for testing purposes, if things get better u'll have to start making some maintenance to your database and check your design so that you lower down the query and the retrieval time.. if the problem persists.. then you should either check ur hardware.. or check your code.. if you keep many sessions that are making a load on ur system.. or u save a lot in you cash … I suggest using stored procedure and emptying the sessions when u finish using it.. hope this will help :)

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"