Report is time out

Member 10836785

I am using vb.net,Crystal and Sql. Some Time My Reports Timeout, but Same Report execute. What to do?

Richard Deeming

Fix your query so the report doesn't time out.

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Member 10836785

What do you mean "fix query"? and How to do It.

Richard Deeming

Change the query so that it runs more efficiently, or add or change indexes on the tables. Seriously, how do you expect anyone here to be able to tell you what to do? We can't see you query or your data, and we can't access your database. What you've done is the equivalent of phoning a random garage, saying "My car's making a funny noise", and then hanging up and waiting for them to fix it.

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Member 10836785

Dear Richard, thank you for you advise My Software is Running in a hospital with one Server and 25 Client. The query execute with in SQL In Less then 3 Second. while executing in .net some time it Time Out. I Want to Know What are the other reason of Query timeout. with regard

Richard Deeming

You need to reply to the right message - I had no idea you'd posted this reply! :doh: There are lots of reasons why a query that runs fast in SQL Server Management Studio can be slow in .NET: Slow in the Application, Fast in SSMS?[^] The most common reason I've seen is the ARITHABORT setting - it's ON by default in SSMS, but OFF by default in .NET connections. Adding SET ARITHABORT ON to the start of your stored procedure often helps.

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer